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 Suggested Answer
  • Replies reply
    1
  • Answers answer
    1
  • Subscribers subscribers
    11
  • Views views
    613
  • Users 0 members are here
Related
Options

Error: SQL code=12154 message=ORA-12154: TNS:could not resolve the connect identifier specified, while configuring sm 9.70 on RHEL

Dave Chappelle

I'm configuring SM9.70 on RHEL 8.6 and Oracle 19 and the script failed with the below error in the smconfig.log 

Error: SQL code=12154 message=ORA-12154: TNS:could not resolve the connect identifier specified 

I've tried some steps to troubleshoot this but none helped. 

1. I've followed the suggestion in this post and edited the tnsnames.ora file 

and the listener.ora file

but that didn't help. 

Here is sm.ini:

2. I've tried to check the db user access with instructions in this post. But db user cannot run command tnsping and sqlplus

Can anyone advise on how to resolve this issue? TIA

  • Suggested Answer

    0  

    Hi Dave

    Linux needs to install Oracle client
    www.oracle.com/.../linux-x86-32-downloads.html


    #cp instantclient-basic-linux-19.10.0.0.0dbru.zip /opt/SM
    #cd /opt/SM
    #unzip instantclient-basic-linux-19.10.0.0.0dbru.zip
    #mv instantclient-basic-linux-19.10.0.0.0dbru client32
    #vi /opt/SM/client32/network/admin/tnsnames.ora
    orclmf =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = *******)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl***)
    )
    )
    #vi ~/.bash_profile
    # User specific environment and startup programs
    PATH=$PATH:$HOME/.local/bin:$HOME/bin
    export PATH
    export ORACLE_HOME=/opt/SM/client32
    export PATH=$ORACLE_HOME:$PATH
    export ORACLE_SID=orcl***
    export TNS_ADMIN=$ORACLE_HOME/network/admin
    export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
    export NS_LANG='AMERICAN_AMERICA.AL32UTF8'
    # source ~/.bash_profile

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.