Re: Database creation problem

"Archer Software" <info_at_archer-soft.com> wrote in message news:<ae20jt$1ufm$1_at_pandora.alkar.net>...
> Hi!
>
> When I try to create new Oracle database from Database Configuration
> Assistant utility, I get an error
> ORA-12560: "TNS: protocol adapter error", at the stage of the database
> initializing, about 90% work
> is complete.
>
> Any ideas why??
>
> Thanx for any help,
>
> Alexey

Creating a 7.3.x version database on WinNT/2000 is easy if you do it from instance manager (oradim73.exe I believe). However, if you like to do it purely from the scripts then follow these steps,

1. Create your directory structure where your database will reside. <DB PATH>
2. Create your parameter file init<SID>.ora and place it in <ORACLE_HOME>\database folder. You can look at sample init.ora file initorcl.73 to see which parameters you can use.
3. from command line run this, C:\> <ORACLE_HOME>\bin\oradim73 -new -sid <SID> -intpwd <manager> -startmode <manual> -pfile <ORACLE_HOME>\database\init<SID>.ora
   • This command will create two services and a password file
4. From command line set oracle_sid variable to sid and log into server manager, C:\> set oracle_sid=<SID> C:\> <ORACLE_HOME>\bin\svrmgr23 SVRMGR> connect internal/<manager> SVRMGR> STARTUP NOMOUNT PFILE=<ORACLE_HOME>\database\init<SID>.ora CREATE DATABASE <SID> LOGFILE '<DB PATH>\Redolog01.ora' SIZE <400>K, '<DB PATH>\Redolog02.ora' SIZE <400>K MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXLOGHISTORY 1 DATAFILE '<DB PATH>\System01.ora' SIZE <250>M MAXDATAFILES 254 MAXINSTANCES 1 CHARACTER SET WE8ISO8859P1 NATIONAL CHARACTER SET WE8ISO8859P1; SVRMGR> -- Run catalog files SVRMGR> @<ORACLE_HOME>\rdbms73\admin\catalog.sql; SVRMGR> @<ORACLE_HOME>\rdbms73\admin\catexp6.sql; SVRMGR> @<ORACLE_HOME>\rdbms73\admin\catproc.sql; SVRMGR> ALTER USER SYS IDENTIFIED BY <manager>; SVRMGR> ALTER USER SYSTEM IDENTIFIED BY <manager>; SVRMGR> -- Deploy user product profile as system SVRMGR> connect system/<manager> SVRMGR> @<ORACLE_HOME>\dbs\pupbld.sql; SVRMGR> shutdown immediate SVRMGR> startup SVRMGR> exit
5. Update listener.ora file at <ORACLE_HOME>\network\admin\listener.ora with new sid
6. Reload listener from command line, C:\> <ORACLE_HOME>\bin\lsnrctl reload
7. Update (Optional) tnsnames.ora file at <ORACLE_HOME>\network\admin\tnsnames.ora with new sid.

Now you can create additional tablespaces, rollback segments and users. Received on Mon Jun 10 2002 - 13:48:48 CDT