OraFAQ Forum: Linux » database creation via scripts

Home » Infrastructure » Linux » database creation via scripts

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database creation via scripts [message #152289]

Thu, 22 December 2005 05:11

bongout
Messages: 6
Registered: December 2005

Junior Member

Hi Forum,

still new to Oracle and Linux I used the GUI to create new databases on a 10g DB Server with Debian Sarge.

Now I would like to learn how to get this done via a script as I would like to ssh to my machine without GUI and create a new database.

I looked for some examples but could not figure out the right track... Sad

PLease let me know what to do in order to create a new DB with ssh and import a dump file automatically.

And just to get an overview: how to delete a db via ssh?

thanx in advance

Report message to a moderator

Re: database creation via scripts [message #152317 is a reply to message #152289]

Thu, 22 December 2005 08:27

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

You can use the DBCA utility (DB Configuration Assistant) to generate a DB creation script.

Best regards.

Frank

Report message to a moderator

Re: database creation via scripts [message #152329 is a reply to message #152317]

Thu, 22 December 2005 09:35

bongout
Messages: 6
Registered: December 2005

Junior Member

Hi Frank,

thanx for reply - but I went step by step through the dbca wizzard but could not find an option to create a script that I can execute via ssh...

Did I miss your point or was it a misunderstanding?

I need a script to create a new database without using the dbca wizzard...

thanx

Report message to a moderator

Re: database creation via scripts [message #152439 is a reply to message #152329]

Fri, 23 December 2005 03:25

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

After going through all the screens DBCA should ask you if you want to create the db, or write out scripts to do so.

Report message to a moderator

Re: database creation via scripts [message #153781 is a reply to message #152439]

Wed, 04 January 2006 02:46

bongout
Messages: 6
Registered: December 2005

Junior Member

Hi Frank,
hi Board...

after some days off I tried what you advised and found the option to create a script.

Unfortunatly it's not what I need. Maybe I'm quite close that I can't see the solution... but the function you mention will create exactly the same database (=same SID) as done with the GUI.

I need a script, to create (and delete) databases with a new SID for each. So what I search is something kind of:

"ssh create $database user@server"

any idea?

Report message to a moderator

Re: database creation via scripts [message #155498 is a reply to message #153781]

Mon, 16 January 2006 09:43

nor8575
Messages: 10
Registered: December 2005

Junior Member

Hi,
I am also looking for a shell script to create oracle 10g databases and came across this script on the internet...

http://www.injunea.demon.co.uk/pages/page2gdb.htm#top

Maybe it might help..??

Report message to a moderator

Previous Topic:	very urgent, please advice...oracle netca, dbca hangs during install
Next Topic:	Will The Ssh Security Affects Oracle Users? Correct me if iam wrong

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 12:24:37 CST 2024