There is an another way to connect to a database through Sqlplus when all other connection methods are hanging. Using a Sqlplus preliminary connection you will be able to connect to the database since no session is actually created,
but you will have limited access to the SGA. This will help in capturing diagnostic information like hanganalyze and systemstate dumps to aid in problem resolution.
There are two ways to connect to Sqlplus using a preliminary connection.
D:\oracle\product\10.2.0\admin\HOMEDEV\udump>sqlplus -prelim / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 27 11:48:06 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL>
D:\oracle\product\10.2.0\admin\HOMEDEV\udump>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 27 11:48:58 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> set _prelim on
SQL> connect / as sysdba
Prelim connection established
SQL>
but you will have limited access to the SGA. This will help in capturing diagnostic information like hanganalyze and systemstate dumps to aid in problem resolution.
There are two ways to connect to Sqlplus using a preliminary connection.
D:\oracle\product\10.2.0\admin\HOMEDEV\udump>sqlplus -prelim / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 27 11:48:06 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL>
D:\oracle\product\10.2.0\admin\HOMEDEV\udump>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 27 11:48:58 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> set _prelim on
SQL> connect / as sysdba
Prelim connection established
SQL>
No comments:
Post a Comment