Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I trace hanging "connect / as sysdba"?
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