Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Verified Answer
  • Replies replies
    8
  • Subscribers subscribers
    8
  • Views views
    421
  • Users 0 members are here
  • Locked Locked
Related
Options
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

MigrationDeletedUser
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*******************

  • 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
  • 0
    Hi Pankaj,

    This is working fine from command prompt when using sqlplus username/password@SMDB, connects successfully to the database and SQL> prompt appears.

    TNSPING SMDB is also working fine and result is ok

    Only issue is connecting through SM application as the connection to database fails(verification failed when running configure batch file).

    Tried both with and without $ORACLE_HOME and $TNS_ADMIN variables but no success.
  • 0
    Do you have lines like this in your sm.ini file:

    sqldictionary:oracle

    [oracle11]

    sqldb:SMDB

    sqllogin:xxx/xxx

    sqllibrary:sqoracle.oci10.so
  • 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
  • 0
    Are you using the 32 bit version of the Oracle client?
  • 0
    Hi, Rajiv Tiwary ,
    I don't know whether you have found the solution. I met the same problem last week. Maybe you can modify your listener.ora file to make the monitor listen youself SID forcibly. I upload my ora file. You can view it and try. My english is not very good, please forgive.
  • 0
    Change in ORA setting resolved this issue
  • 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,

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.