Re: Can't connect to new database until all services are restarted

From: Venkat <vreddy_at_!no_spam!ix.netcom.com>
Date: Fri, 3 Jul 1998 09:09:47 -0400
Message-ID: <6nilbt$f28@dfw-ixnews6.ix.netcom.com>

Heidi:
Try this
c:\> oradim80 -new -sid AAAA -intpwd manager -startmode auto -starttype SRVC, INST -pfile c:\orant\database\initAAAA.ora

C:\SET ORACLE_SID=AAAA
C:\svrmgr30>connect internal/manager
C:\svrmgr30>startup nomount pfile=c:\orant\database\initAAAA.ora
c:\> svrmgr30 @c:\orant\database\CreateAAAA.sql

At this point your database should be open. You can verify that by looking at NT services or ctrl+alt+del and checking the processes running. Now you can run catalog.sql and other scripts if you have not already called them from your createAAAA.sql script.

Venkat

>I can create a database without any problem, but am unable to use it until I
>stop the newly created database service and all previously running services,
>related to Oracle, and then restart them.
>
>The error that I get when I don't stop and restart all the services is:
>ORA-01034: ORACLE not available.
>
>I am using Oracle8 on NT and the way in which I created the new database is
>as follows:
>
>c:\> oradim80 -new -sid AAAA -intpwd manager -startmode auto -pfile
>c:\orant\database\initAAAA.ora
>c:\> oradim80 -startup -sid ORCL -starttype srvc,inst -usrpwd manager -pfile
>c:\orant\database\initAAAA.ora
>c:\> svrmgr30 @c:\orant\database\CreateAAAA.sql
>
>The new database service is also added properly to the tnsnames.ora file.
>
>The only difference in it working and not working is when the services are
>all stopped and then restarted. Could I be missing a flag or something?
>
>If anyone knows anything about how to connect to a newly created database I
>would really appreciate if you could tell me where I am going wrong.
>
>Thanks,
>
>heidi
>
>(heidi_at_gestalt.com)
>
>
Received on Fri Jul 03 1998 - 08:09:47 CDT