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
  • Verified Answer

    0
    Hi Rajiv,

    The error shows your SM server is not able to connect to database. So reason can be wrong password, connectivity with DB or wrong ora file entries for database.

    So check the following.

    Go to cmd and type sqlplus
    connect by username/password@SMDB

    And see or you able to connect sucessfully from your machine.

    Also from the machine, you can try tnsping SMDB to see your network connection.

    Regards,
    Pankaj
Reply
  • Verified Answer

    0
    Hi Rajiv,

    The error shows your SM server is not able to connect to database. So reason can be wrong password, connectivity with DB or wrong ora file entries for database.

    So check the following.

    Go to cmd and type sqlplus
    connect by username/password@SMDB

    And see or you able to connect sucessfully from your machine.

    Also from the machine, you can try tnsping SMDB to see your network connection.

    Regards,
    Pankaj
Children
No Data