This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

sqociExec error:sqlcode=12154 message=ORA-12154:TNS:could't resolve the connect identifier specified

Getting the following error message while starting the SM , it seems that database is not getting connected by SM .I have used the default port for Oracle 1521 but do not have idea how to check for the port on which Oracle is running .

Can some please help me to understand whether this issue is because of port issue or some setting in Oracle which is missing in sm.ini file
***********************************************

3996( 3360) 12/07/2010 05:52:03 RTE I sqociExec error: sqlcode=12154 message=ORA-12154: TNS:could not resolve the connect identifier specified
3996( 3360) 12/07/2010 05:52:03 RTE E sqociExec error: sqlcode=12154 message=ORA-12154: TNS:could not resolve the connect identifier specified
3996( 3360) 12/07/2010 05:52:03 RTE I sqociExec error statement=Connecting to dbtype 'oracle10' Oracle server 'SMDB' as user 'servicemgr'
3996( 3360) 12/07/2010 05:52:03 RTE E sqociExec error statement=Connecting to dbtype 'oracle10' Oracle server 'SMDB' as user 'servicemgr'
3996( 3360) 12/07/2010 05:52:03 RTE I Going to sleep for 15 seconds and try again to connect
3996( 3360) 12/07/2010 05:52:18 RTE I sqociExec error: sqlcode=12154 message=ORA-12154: TNS:could not resolve the connect identifier specified
3996( 3360) 12/07/2010 05:52:18 RTE E sqociExec error: sqlcode=12154 message=ORA-12154: TNS:could not resolve the connect identifier specified


**************tns ora entry*******************

SMDB =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=doomsday.dev01.aops-eds.com)
(PORT=1521)
)
)
(CONNECT_DATA=
(SID=SMDB)
)
)

**************tns ora entry*******************

Parents
  • 0
    Hi Rajiv Tiwary,

    I have been suffering the same issue can you please tell me that what changes did you made in ORA file to resole it i will also attaching the file showing ORA setting
    Hopes for your reply

    Thanks In Advance,
    -Mohsin,
Reply
  • 0
    Hi Rajiv Tiwary,

    I have been suffering the same issue can you please tell me that what changes did you made in ORA file to resole it i will also attaching the file showing ORA setting
    Hopes for your reply

    Thanks In Advance,
    -Mohsin,
Children
No Data