I have 8.1.5 client installed on my machine & use it to connect to a remote database.
I would like to create a small database on my machine for test purposes. Can someone advise on how I go about it?
I don't have the Database Config Asst on my machine. It is only installed on the server. I looked for it on the CD but couldn't find it.
2.5 Create the following subdirectories in d:\PROD
2.5.3 Copy RDBMS directory from Oracle home D:\orant\rdbms80 to
2.6 Copy the parameter file from Oracle Home\database to D:\PROD\DATABASE\INITPROD.ORA
2.7 Edit the parameter file and make the following changes:
2.7.1 Change DB_NAME to whatever required. Though this does not need to match the instance SID, this is preferable.
2.7.2 Change CONTROL_FILES parameters to d:\PROD\DATABASE\ctl1prod.ora
2.7.3 Set GLOBAL_NAMES to TRUE
2.7.4 Set DB_FILES to same number as MAXDATAFILES option in the CREATE DATABASE command.
2.8 Create a new Windows NT Service.
D:\PROD> ORADIM80 –NEW –SID PROD –INTPWD PASSWORD -STARTMODE AUTO –PFILE D:\PROD\DATABASE\INITPROD.ORA
2.9 Prepare the CREATE DATABASE script.
Open d:\PROD\rdbms80\admin\build_db.sql, rename it to d:\PROD\rdbms80\admin\build_prod.sql and make the following changes:
2.9.1 Set PFILE to d:\PROD\database\initprod.ora
2.9.2 Change to – CREATE DATABASE PROD
2.9.3 Modify all logfiles and datafiles names and location.
2.9.4 Remove the STARTUP command in the file.
2.10 Check if NT Service has been created and running
2.10.1 D:\PROD> NET START
2.11 Set Oracle SID to the new database PROD.
2.11.1 D:\ PROD > SET ORACLE_SID=PROD
2.12 Start Server manager and connect as internal using password as the same one used to create the service: