Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I trace hanging "connect / as sysdba"?

Re: How do I trace hanging "connect / as sysdba"?

From: pcroft <pcroft_at_cix.co.uk>
Date: 18 Feb 2006 03:32:05 -0800
Message-ID: <1140262325.743510.80100@g47g2000cwa.googlegroups.com>


Frank,
Thank you for your reply.

>How long did you allow it to hang?

10 minutes

>How do you try to create a database?

Initially I tried doing that during the install using dbca but as it hung there I undid the install, then re-did it and just installed the software. I then tried the command-line route to simplify things and found this problem occurred really early, so I suspect something basic like a network problem.

>How experienced are you with Oracle?

My dba knowledge is patchy as I just tend to learn enough to get by. However I have successfully created databases via scripts on Linux, and previously installed Oracle 9.2 on a w2k server just like this.

>If you have little to no experience, fire
>up the Database Creation Assistant (dbca).
Do you mean the Database Configuration Assistant?

>Go through the screens, and on the last screen (#12
>if memory serves), make sure you also save the
>scripts.

It only gives me the option to save the parameter settings as an html file; I can't see how to save the creation scripts. Am I overlooking something?

>You can use the scripts to:
>- study what it takes to create a database
>- switch off options (comment out parts of the script)
>- modify and create yet another database
>- create a database one step at the time.
I think my problem is before you get to this stuff.

>One thing you will notice, is that windows requires
>the creation of services. One service is the oracle
>engine itself, and initially that service is *not*
>autostarting.
>Check if you can find something called OracleserviceORCL;
>the "ORCL" is actually the SID; you may have chosen
>something different (how about TEST? :) ).
>If found, make sure the service is started.
It is.

>Then, open the command line interface ("DOS-box"), and:
>c:\>set oracle_sid=ORCL (or what else you found as SID)
>c:\>sqlplus "/ as sysdba"
>That should work now - if not, post the exact error.
There is no error - it just hangs - which I why I ask what happens at this point and how to trace it. Thank you for your input but it doesn't address the problem I have. Regards,
Peter Received on Sat Feb 18 2006 - 05:32:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US