Re: Create database problem.. Please help

Did you start the thing using oradim73 -sid DOG -intpwd CAT .... etc

1. Try ... go to the instance manager, highlight the ORCL and DOGS
   > DOGS
   > Services Started Automatic
   > Instance Started Automatic
   >
   > ORCL
   > Services Started Automatic
   > Instance Started Automatic
   and delete them (stop all services first)
2. now go to your database directory and delete the initorcl.ora and other files, only leave initdog.ora file in your directory.
3. at dos prompt, type "net start", you should see the oracleservicesdog and oracleserviceorcl ---->both disappeared
4. now, type at dos prompt oradim73 -new -sid dog -intpwd cat -startmode auto -pfile c:\orant\database\initdog.ora
5. then check at prompt net start you should see oracleservicedog running if not, then type "net start oracleservicedog"
6. set oracle_sid=dog
7. svrmgr23
8. svrmgr23> connect internal/cat
9. svrmgr23> startup nomount pfile=c:\orant\database\initdog.ora
10. svrmgr23> @\orant\database\your_database_creation_script
11. svrmgr23> shutdown normal
12. svrmgr23> startup mount
13. svrmgr23> @\orant\database\your_rollback_segment_creation_script
14. svrmgr23> shutdown normal
15. svrmgr23> startup open
16. svrmgr23> .... now you can create data dict, tables, rols, etc...

hope this help

>
> I am a newbie to Oracle 7.33 and I need help to create a database.
>
> I am trying to create a database 'DOG' by the following:
> Copy Initorcl.ora to Initdog.ora and changed db_name and Control_files
> lines.
> Use NT Instance Manager to create new instance with SID=DOG, enter path
> for Parameter
> Initialization file and under Advanced changed database name to
> DOG.
>
> New instances are created with no errors.
>
> When I launch Instance Manager and log in (INTERNAL) with service name of
> DOG, I got the error
> ORA-12154:TNS: could not resolve service name
> What am I doing wrong? Do I need a more descriptive name then DOG?
>
> Thanks in advance for any help. Please Email me directly as I don't have a
> reliable connection to this news group.
>
> Under NT services panel I have the following two services, both started:
> OracleStartDOG
> OracleServiceDOG
>
> Under Instance Manager I have the following:
>
> DOGS
> Services Started Automatic
> Instance Started Automatic
>
> ORCL
> Services Started Automatic
> Instance Started Automatic
Received on Thu Feb 19 1998 - 00:00:00 CST