Scenerio
----------
Local connection fails when connecting with / as sysdba
$ sqlplus
SQL*Plus: Release 9.2.0.3.0 - Production on Tue May 7 12:15:02 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name : / as sysdba
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
Work around
---------------
Relink the Oracle binaries by executing the following command,
$ cd ORACLE_HOME/bin
$ relink all
$ sqlplus
SQL*Plus: Release 9.2.0.3.0 - Production on Tue May 7 12:17:05 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning option
JServer Release 9.2.0.3.0 - Production
----------
Local connection fails when connecting with / as sysdba
$ sqlplus
SQL*Plus: Release 9.2.0.3.0 - Production on Tue May 7 12:15:02 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name : / as sysdba
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
Work around
---------------
Relink the Oracle binaries by executing the following command,
$ cd ORACLE_HOME/bin
$ relink all
$ sqlplus
SQL*Plus: Release 9.2.0.3.0 - Production on Tue May 7 12:17:05 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning option
JServer Release 9.2.0.3.0 - Production
No comments:
Post a Comment