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,

    We have the oracle entries in sm.ini file, below is sm.ini file
    ************************************
    shared_memory:32000000
    log:../logs/sm.log
    alertlog:../logs/sm.alert.log
    system:13080
    httpPort:13080
    sslConnector:0
    httpsPort:13443
    sqldictionary:oracle10
    [oracle10]
    sqldb:QMUSPLN
    sqllogin:moneng/spacemonkey
    sqllibrary:sqoracle.oci10.DLL
    plugin0:kmplugin.dll
    ************************************
    have tried connecting to two different databases 10g and 11g, to both I can connect from command prompt and SQLPLUS but connection to both cannot be established from SM application. The connection verification fails when running configure batch file
Reply
  • 0
    Hi,

    We have the oracle entries in sm.ini file, below is sm.ini file
    ************************************
    shared_memory:32000000
    log:../logs/sm.log
    alertlog:../logs/sm.alert.log
    system:13080
    httpPort:13080
    sslConnector:0
    httpsPort:13443
    sqldictionary:oracle10
    [oracle10]
    sqldb:QMUSPLN
    sqllogin:moneng/spacemonkey
    sqllibrary:sqoracle.oci10.DLL
    plugin0:kmplugin.dll
    ************************************
    have tried connecting to two different databases 10g and 11g, to both I can connect from command prompt and SQLPLUS but connection to both cannot be established from SM application. The connection verification fails when running configure batch file
Children
No Data