I am just a beginner who is aiming for DBA. I have Windows NT and Oracle 8 on it. I have been trying to start an Oracle instance but am stuck on the very 2nd line of command. The command "Oradim80_new_sid sam _intpwd tom" gives out error - "Oradim80_new_sid" has not been recognised as internal or external command. Can anybody tell what am I doing wrong...SOS. Thanks in advance...
Oradim utility is used to create,delete , edit an instance.
For starting up an instance u donot need the help of Oradim.
For starting up an instance.
Another way of starting up the instance
Go to command prompt
C:\>SVRMGRL30 (I GUESS FOR ORACLE8)
IF IT ASKS FOR PASSWORD THEN GIVE IT AS ORACLE WHICH IS THE DEFAULT.
THE ABOVE COMMAND IS SUFFICIENT ENOUGH TO START THE INSTANCE AS WELL AS THE DB.
Or else u could also start it from Services dialog under control panel.
From the original post, it looks like you are trying to run the .bat file from the "Create Database" utility. Under NT, the first line sets the environment variable for the SID. The second line creates the new instance ....
If you are trying to CREATE the instance and database, ORADIM80 is correct ... your syntax for it is wrong.... ORADIM80 ? will show you the proper syntax .....
If you ALREADY have created the instance .... Then you should find it as a Service that can be started or stop ....
Pls tell what is preferable to make database while installation ? If I do and do not create database on installation, how do I go about making one i.e what should be steps after installing oracle ? I have Oracle 8 on NT.
I don't remember whether or not Oracle 8.0 had a "Database Configuration Assistant" ... If so, use it ...
If not, you need to build scripts to build the database ...
Create the INSTANCE first by using ORADIM80...
Build script to create the database and system tablespace.
Build script to create additional tablespaces, rollback segments that you need and to run the CATALOG and CATPROC scripts.
Build your INITxxx.ORA parameter file
Run SVRMGRL30(?) connecting as internal
startup nomount pfile=....\initxxx.ora -- start database with nomount
Run the first script to create the database
Run the second script to create tablespaces and Oracle objects
Once complete, stop/start database, CHANGE passwords for
SYS and SYSTEM and others ....
Ensure that in the REGISTRY you have AUTOSTART=TRUE for so that
the database will start when the SERVICE starts. Ensure the SERVICE is set to AUTOMATIC (if that's what you want) ....
I believe that Oracle 8.0 has the Configuration Assistance through ...