Hello ,
I am new in this forum and need your help as I am totally 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
Regards,
rahoolm