| creation of new database in already running server [message #63285] |
Fri, 24 September 2004 01:44  |
Harikishan
Messages: 12
Registered: August 2003
|
Junior Member |
|
|
Hi We have a database running on oracle 8.1.7 for a location. Now the requirement is I need to create a new database in same server which is totally independent of existing database. How can so this. and whats the procedure? also let me know how its diffrent from creating a new instance.
Thx in advance
Hari
|
|
|
|
|
|
|
|
| Re: creation of new database in already running server [message #63291 is a reply to message #63285] |
Fri, 24 September 2004 04:49  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
Hi
Genarally you can create multiple databases on single server irrespective of O/S.
And you can create a database in to different ways
1)Manual method(where everything you have do from the scratch i.e defining the filing locations to creating database and running admin scripts..which is bit labourious job)
2)you can use GUI tool where oracle will automatically creates the database along the file and locations and all.
The following is the second method
1)go to programs and select Oracle-OraHome 8i option
2)select configuration and migration tools
3)select database configuration assistant option
then it will open a dialogue box with following options
>create a database
>modify a database
>delete a database
4)select create database option
5)then it will start asking to enter some minimum parameters
6)enter Name(8 characters)for your database which you want to create(it will also ask for instance name and service name if you want you give the same name as a database name the you give or you can give different name also)
7)enter the passwords for superuser accounts if needed otherwise by default database will assign password.
note:- here no need to worry about name,size and location of your datafiles by default oracle will assign that for you if you want to change you can do that also
8)after entering all the necessary options then it will
ask do you want to create then type yes.
9)it will take some time to create a database(when database is creating you can see that process on that dialogue box
10)once it finishes this process it will show you that database creation is completed then exit from the option.
11)once you have created the database then you can log on to the database as dba by typing username/password
as
sys/change_on_install@service_name as sysdba
then it will connect to the database
Regards
D.Dilip
|
|
|
|
| Re: creation of new database in already running server [message #63564 is a reply to message #63285] |
Fri, 15 October 2004 20:20 |
Balaji
Messages: 102
Registered: October 2000
|
Senior Member |
|
|
hi
log on as oracle user if unix based system
and type this at the dollar prompt
$ oemapp dbassist
this will start a GUI tool and select crete new database
and go ahead with the creation process.
if ur database is on windows then go frm programs /oracle.... menu
but take care to add the names of the newly created databases to the listner.ora and tnsnames.ora .otherwise users cannot connect to them
with best wishes
balaji
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
