Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to create database instance in Oracle 10g in Unix
"MSK" <mannaikarthik_at_yahoo.com> wrote in news:1153607308.605906.81320@
75g2000cwc.googlegroups.com:
> Hi all,
>
> We have a database instance in Oracle 10g/UNIX, I want to create two
> more instance to simulate test environment but currently we dont have
> DBA, I need to perform this task,
> I have enough experience in Oracle 8x. It would be nice if any one give
> me all the steps for 10g or any useful links.
>
> 1. Can we create via GUI or command line only ?
> 2. Login into the existing instance and Can we create via SQL
>
> Many Thanks
>
> MSK.
>
>
Login as the "oracle" user.
Make sure xclock can run.
Invoke "dbca" # data base creation assistant
Fill in the blanks when prompted
Lather, rinse, repeat.
Enjoy
Received on Sat Jul 22 2006 - 17:43:10 CDT