Yaping's Weblog

August 30, 2008

SQL*Plus using prelim connection

Filed under: Oracle — Yaping @ 2:52 am
Tags:

Since Oracle 10g SQL*Plus introduces prelim connection. This connection doesn’t create session, so it doesn’t invoke some internal call, but can access SGA. In some situations, the database has issues, such as hang, even though as SYSDBA can’t logon normally, but we want to dump system information for diagnoses before recycle database. How can we do?

 

[oracle@chen ~]$ sqlplus -prelim

SQL*Plus: Release 10.2.0.3.0 – Production on Tue Jul 8 19:47:30 2008

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Enter user-name: /as sysdba

ERROR:

ORA-01012: not logged on

@>oradebug setorapid 15

Unix process pid: 2623, image: oracle@chen (TNS V1-V3)

@>oradebug dump hanganalyze 3

Statement processed.

@>oradebug dump systemstate 3

Statement processed.

 

Or

[oracle@chen ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 – Production on Tue Jul 8 19:57:21 2008

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

@>set _prelim on

@>conn /as sysdba

Prelim connection established

ERROR:

ORA-01012: not logged on

 

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: