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

Home -> Community -> Usenet -> c.d.o.misc -> Re: cannot create DB

Re: cannot create DB

From: Vladimir Andreev <1meter_at_beer.com>
Date: 9 Apr 2002 05:01:10 -0700
Message-ID: <e2683c0b.0204090401.4e0ba9fb@posting.google.com>


Daniel Morgan <damorgan_at_exesolutions.com> wrote in message news:<3CB1DB21.6A5EDCC0_at_exesolutions.com>...
> Try to log in from server manager directly. (svrmgrl followed by connect
> internal)
>
> Check to see if the listener is started (lsnrctl status)
>
> Check to see if the Windows services have been created and are started
>
> Check the TNSNAMES.ORA file to see if there is an entry for you machine
>
> Check the environment variables to see if one exists for the SID.
>
> Daniel Morgan
>

If you can successfuly connect via Server Manager/SQL*Plus, have the Assistant generate the scripts for you and not execute them directly. Then run the scripts one by one.
On Windows, there is a quirk - the OracleServiceSID service must be running before you can access the instance. Hope this helps
Flado Received on Tue Apr 09 2002 - 07:01:10 CDT

Original text of this message

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