|
-
You must want to be proven wrong. I'd bet there's a big enough brain in the group to figure this one out. Is stecal still around?
Let's start here:
The original question was for a SQL query for all SID's under a given installation.
I know it's not SQL now, but how about:
ls -lrt $ORACLE_HOME/dbs/init*.ora $ORACLE_HOME/dbs/spfile*
Just thinking here ... about the rules.
Is $ORACLE_HOME set?
Is $ORACLE_HOME/bin in $PATH?
Is $ORACLE_SID set?
Is the $ORACLE_SID open and accepting connections?
Last edited by KenEwald; 10-27-2004 at 05:59 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote