Home » RDBMS Server » Server Administration » 10g DB creation
10g DB creation [message #207620] Wed, 06 December 2006 04:57 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Hello ,
i want to create a 10g database same like an 8i database i have in another server.can someone please tell me things to be taken care.
note:its a fresh database,without any user objects or schemas
Re: 10g DB creation [message #207621 is a reply to message #207620] Wed, 06 December 2006 04:59 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If it's a fresh database without any user objects or schemas then why don't you just use DBCA to create the 10g database?
Re: 10g DB creation [message #207623 is a reply to message #207620] Wed, 06 December 2006 05:02 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
i never used DBCA before.i was planing to create from command line using create database command.what would you suggest?DBCA a better option ?if so i hav to get some documents .
Re: 10g DB creation [message #207625 is a reply to message #207623] Wed, 06 December 2006 05:07 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you've never done it before, by all means you'll want to use DBCA. You can have DBCA create the scripts for you so that you can look at the scripts to see what steps the DBCA is actually doing to create the database. But to be on the safe side, I would recommend using DBCA.
Re: 10g DB creation [message #207626 is a reply to message #207620] Wed, 06 December 2006 05:12 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thanks .i will do some R&D .
Do you have any documents on DBCA for 10g .mine is unix AIX .
Re: 10g DB creation [message #207628 is a reply to message #207626] Wed, 06 December 2006 05:15 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
This should walk you right thru it Using DBCA to Create and Configure a Database.
Re: 10g DB creation [message #207813 is a reply to message #207620] Thu, 07 December 2006 02:22 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
For some reason,DBCA is not working in my machine.you can find my other post here.
now i have to try manual db creation .
Re: 10g DB creation [message #207826 is a reply to message #207813] Thu, 07 December 2006 02:56 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

through DBCA you can create script or run and create ur database.
but if you have problem with DBCA then.
you have to create everything manullay.

1. set oracle sid.
2. create password file
3. create oracle services.
4. create pfile and startup ur database ( idle instance)
5. create database statement .
all structure of ur database
control files, datafiles, redo log files, character set,



hope this helps
Taj
Re: 10g DB creation [message #207828 is a reply to message #207620] Thu, 07 December 2006 02:58 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
mine is Unix AIX.so what all steps change here ?
Re: 10g DB creation [message #207833 is a reply to message #207828] Thu, 07 December 2006 03:00 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

as far as i know some.

regards
Taj

Re: 10g DB creation [message #207845 is a reply to message #207620] Thu, 07 December 2006 03:28 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
can you please tell me what are they ?anything specific for unix env ?
Previous Topic: Where can I download Oracle 8.0.6?
Next Topic: 10g and 8i Pfile
Goto Forum:
  


Current Time: Sat Dec 10 07:05:56 CST 2016

Total time taken to generate the page: 0.04451 seconds