Oracle 10g - after Installation Error
Jay Maheshkar
I hope, you all doing well
i have installed oracle 10g in CENTOS -5.5, Oracle was installed successfully, but when i am trying to connect
my database "comdata" using its username and password
like SQL> conn s/s@comdata
it gave me below error
----------------------------------------------------------------------------------------------------------------------------output start
[oracle@oracle ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 14 11:11:29 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn s/s@comdata
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
------------------------------------------------------------------------------------------------------------------------------output end
i have did google but unable to solve this error
my listener.ora file is looks like
----------------------------------------------------------------------------------------------------------------------------------------listener file starting
[oracle@oracle ~]$ vim /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 1**.1**.95.2*)(PORT = 1521))
)
)
---------------------------------------------------------------------------------------------------------------------listener file Ending
and my tnsnames.ora file looks like
--------------------------------------------------------------------------------------------------------------------------tnsnames.ora file starting
[oracle@oracle ~]$ vim /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1**.1**.9*.2*)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
-----------------------------------------------------------------------------------------------tnsnames.ora file ending
oracle installed on remote linux machine and it has also live static ip
can anybody help me to solve this error
Any help will be greatly appreciate...
--
Regards,
Jay Maheshkar
( MCA, RHCE )
(M)+91 972.583.67.33
https://www.redhat.com/wapps/training/certification/verify.html?certNumber=805010775851036
pulin patel
Why are you using @comdata service name, when u haven't created any? check the Oracle_sid with the command echo $ORACLE_SID [should be specified in the .bash_profile or .bash_rc] which will result in the DB name as an output. Use sys@orcl as sysdba as this is ur service name and also do check listener status whether its running or not. lsnrctl is the CLI. commands as follows: lsnrctl status lsnrctl start ( this will start the listener if configured properly) Also try using Tnsping utility with the service name orcl and not comdata. commnad as follows: tnsping orcl tnsping comdata If you want to user comdata as the service name then create the service with the name
comdata first!!! Netca or netmgr are the tools to create the services in Oracle Net layer of DB. Regards, Pulin --- On Tue, 14/12/10, Jay Maheshkar <jay.ma...@gmail.com> wrote: |
|
Jay Maheshkar
Let me try, then i will get back to you
Ashok Kumaran
Set ORACLE_SID=orcl and export it
then start sqlplus / as sysdba
then type startup
it may work u can try it.
Regds,
Ashok
Dhwanil Raval
Create COMDATA tns service with Net manager/manually..
Or use sys@orcl as sysdba..
Best Regards,
Dhwanil Raval
Oracle DBA
On 12/14/10, Ashok Kumaran <ashokku...@gmail.com> wrote:
> Hi Jay,
>
> Set ORACLE_SID=orcl and export it
> then start *sqlplus / as sysdba*
>
> then type *startup*
>
> it may work u can try it.
>
> Regds,
> Ashok
>
> On Tue, Dec 14, 2010 at 1:28 PM, Jay Maheshkar
> <jay.ma...@gmail.com>wrote:
>
>> Thanks Mr. Pulin for your help
>> Let me try, then i will get back to you
>>
>> On Tue, Dec 14, 2010 at 12:02 PM, pulin patel <puli...@yahoo.co.in>wrote:
>>
>>>
>>> Why are you using @comdata service name, when u haven't created any?
>>> check the Oracle_sid with the command echo $ORACLE_SID [should be
>>> specified in the .bash_profile or .bash_rc] which will result in the DB
>>> name
>>> as an output.
>>>
>>> Use *sys@orcl as sysdba* as this is ur service name and also do check
>>> listener status whether its running or not.
>>> lsnrctl is the CLI.
>>> commands as follows:
>>> lsnrctl status
>>> lsnrctl start ( this will start the listener if configured properly)
>>>
>>> Also try using Tnsping utility with the service name orcl and not
>>> comdata.
>>> commnad as follows:
>>> tnsping orcl
>>> tnsping comdata
>>>
>>> If you want to user comdata as the service name then create the service
>>> with the name comdata first!!!
>>> Netca or netmgr are the tools to create the services in Oracle Net layer
>>> of DB.
>>>
>>
>>
>>
>>>
>>> Regards,
>>> Pulin
>>> http://www.catb.org/~esr/faqs/smart-questions.html<http://www.catb.org/%7Eesr/faqs/smart-questions.html>before
>>> posting.
>>> You received this message because you are subscribed to the "Vibrant
>>> GNU/Linux User Group".
>>> To stop receiving emails from this group, mail to
>>> VGLUG+un...@googlegroups.com <VGLUG%2Bunsu...@googlegroups.com>
>>> To post to this group, send email to VG...@googlegroups.com
>>> For more options, visit this group at
>>> http://groups.google.com/group/VGLUG
>>>
>>>
>>> --
>>> Please read
>>> http://www.catb.org/~esr/faqs/smart-questions.html<http://www.catb.org/%7Eesr/faqs/smart-questions.html>before
>>> posting.
>>> You received this message because you are subscribed to the "Vibrant
>>> GNU/Linux User Group".
>>> To stop receiving emails from this group, mail to
>>> VGLUG+un...@googlegroups.com <VGLUG%2Bunsu...@googlegroups.com>
>>> To post to this group, send email to VG...@googlegroups.com
>>> For more options, visit this group at
>>> http://groups.google.com/group/VGLUG
>>>
>>
>>
>>
>> --
>> Regards,
>>
>> Jay Maheshkar
>> ( MCA, RHCE )
>> (M)+91 972.583.67.33
>>
>>
>> https://www.redhat.com/wapps/training/certification/verify.html?certNumber=805010775851036
>>
>> --
>> Please read
>> http://www.catb.org/~esr/faqs/smart-questions.html<http://www.catb.org/%7Eesr/faqs/smart-questions.html>before
>> posting.
>> You received this message because you are subscribed to the "Vibrant
>> GNU/Linux User Group".
>> To stop receiving emails from this group, mail to
>> VGLUG+un...@googlegroups.com <VGLUG%2Bunsu...@googlegroups.com>