Re: New Oracle Server/Instance/Database...

You created the instance only. If you want to do it this way you need to set oracle_sid env var to the sid of the new instance, start svrmgr30
issue connect internal
issue startup nomount
issue your own create database statement.

Basically the instance manager has a gui and a dos operation mode. Running it in gui mode WILL create a database. You need to have a correct init<sid>.ora before you do that.

You probably would be better off using the Oracle Database Assistant (yes, I know there are lots of assistants which veterans like me would like to have had years ago. But then the disadvantage is IMO people don't know anymore what they are doing). Anyway, the Database Assistant will guide you completely through the process.

Hth,

--
Sybrand Bakker, Oracle DBA
Greg Akins <gakinsNOgaSPAM_at_gatewayhealthplan.com.invalid> wrote in message news:11f733ec.4058b90f_at_usw-ex0101-001.remarq.com...
> Hi,
>
> I was having a problem connecting to a new instance.
>
> I installed Oracle8.0.5 on a NT box and skipped the create database
> step.
>
> Then I followed Oracle's documentation for creating a database.
>
> I ran the Oradim (-starttype auto) to create the instance, modified my
> registry updated the TNSNAMES.ora & Listener.ora.
>
> However, I still couldn't connect. Finally I realized that the Net80
> services hadn't started. Also, I don't appear to have an OracleStartup
> Service (Though I do have an OracleService service).
>
> Can anybody suggest which steps I might have missed, or performed
> incorrectly.
>
> -greg
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu Oct 28 1999 - 14:22:24 CDT