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
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.