Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Tuesday, September 27, 2011

How To Connect Using A Sqlplus Preliminary Connection

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>

No comments: