Really simple shell script to create oracle database

Linux and Unix-Like UNIX and Linux Applications
1

Hello ,

I am new in this forum and need your help as I am totally confused :confused:

I read a lot of threads and tried to search a lot but did not get the exact answer to my question.

I just want a simple (content wise may be long) shell script to create oracle database.

In detail:
1 - I want to create a script named create_oracle_db.sh
2 - I want to run it with "root" user and command should be
./create_oracle_db.sh <DB_NAME>
3 - If the db already exists then the script should check the next argument if it is "yes" then the old db should be deleted and new should be created. If it is "no" then it should give output as "DB Already exists.....blah blah do this and that"
4 - my oracle installation is on /home/data/oracle/ora11gR2/network/admin
5 - my oradata is /home/data/oracle/oradata

Please let me know where can I get an exact answer. Already :confused:

Regards,
rahoolm

2

Why invente what already exist?
Look at how oracle installs itself, yes, it uses a script...

So get the install script, and start learning, then once you are clear, try to customize the script to your needs!

Good luck

3

Could you please let me know where I can find those scripts?

I am not an expert :frowning:

4

normally on oracle first CD (install...)

5

If you can find an old oracle 7 or 8 you will be fine, what follows after starts to use, then mainly use JAVA as a GUI...

6

you can find that info on oracle metalink