Home » RDBMS Server » Server Administration » Prob:creating database
Prob:creating database [message #62644] Wed, 04 August 2004 23:20 Go to next message
BhavinShah
Messages: 105
Registered: February 2004
Senior Member
Hi.. friends,

I have installed only oracle software 8.0.3 on windows NT.Now i want to create a database ..
so,kindly tell what are the step for creating database after installing a only oracle software.

Bhavin
Re: Prob:creating database [message #62645 is a reply to message #62644] Wed, 04 August 2004 23:40 Go to previous messageGo to next message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Bhavin,

first you need to set up the init<SID>.ora for your database. You should have a demo copy in $ORACLE_HOME/dbs and copy this one to init<SID>.ora.
where SID is the Database-Name of your Instance.
You set this before Installing as ORACLE_SID.
Then you need to set up a file called listener.ora which resides in $ORACLE_HOME/network/admin
Next step will be to create a systems account for that Instance with orapwd. pls get the complete syntax with the help function.
next is a startup mount and than you can call the sqlplus /nolog, connect internal and start with the create database.
Re: Prob:creating database [message #62647 is a reply to message #62644] Thu, 05 August 2004 07:55 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Since you are in WinNT environment, use the wizard to create the database. Very simple and easy.

Good luck.
--
Sanjay
Previous Topic: TNS-12638 Credential retrieval failed
Next Topic: apache & asp
Goto Forum:
  


Current Time: Fri Sep 27 10:27:21 CDT 2024