Online Tutorials & Training Materials | STechies.com
Register Login

Warning:You are no longer connected to ORACLE.

Sugandh || 26 Mar 2015 5:10 pm || 1

Hello Experts,

How to fix this problem
SQL> conn sys/sys@db11g as sysdba
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Warning: You are no longer connected to ORACLE.
SQL> conn sys/sys@db11g as sysdba
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Comments

  • 03 Aug 2016 10:11 am Helpful Answer

    Hi I think it is connection error.

    For HP-UX 10.20 and Oracle 8.0.5.2 download and implement bugfix from sapservx under:
    ~ftp/general/3rdparty/oracle/HP_UX/8.0.5/bug944523.

    For Digital-Unix implement Oracle Patchset 8.0.5.2 (as described in Note 127395. Note also additional information for Digital Unix in this note.)

    Or you can use the following workaround (valid for all platforms):
    Change parameter AUTOMATIC_IPC in the file
    $ORACLE_HOME/network/admin/sqlnet.ora
    AUTOMATIC_IPC=OFF
    This has the result that a connect uses the TCP/IP log to set up the connection between R/3 and database, even if the SAP instance and the database run on the same host.
    Consequently the performance of your system is affected. Due to this change every call must be processed via the network card, even if it is started on the same machine.
    For  Oracle 8.0.5.2 under HP-UX 10.20 a fix is available on sapservx under:
       ~ftp/general/3rdparty/oracle/HP_UX/8.0.5/bug944523
    For installation note file README.bug944523.