Search This Blog

Tuesday, February 13, 2007

Manually database creation on linux

[oracle@alwarid-taj /]$ cd /home/oracle/oracle/product/10.2.0/db_1/bin
[oracle@alwarid-taj bin]$ ./dbca









































#$#$#$##$$####################################$#$#$#$#$#$#$##########$$$$$$$$$$$$$$$$$$$$$$$$$$$





[oracle@alwarid-taj /]$ cd /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/scripts
[oracle@alwarid-taj scripts]$ ls
cloneDBCreation.sql initorclTemp.ora postDBCreation.sql
CloneRmanRestore.sql orcl.sh postScripts.sql
init.ora orcl.sql rmanRestoreDatafiles.sql
[oracle@alwarid-taj scripts]$



[oracle@alwarid-taj scripts]$ pwd
/home/oracle/oracle/product/10.2.0/db_1/admin/orcl/scripts

[oracle@alwarid-taj scripts]$ cat orcl.sh
#!/bin/sh

mkdir -p /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/adump
mkdir -p /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/bdump
mkdir -p /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/cdump
mkdir -p /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/dpdump
mkdir -p /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/pfile
mkdir -p /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/udump
mkdir -p /home/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/orcl
mkdir -p /home/oracle/oracle/product/10.2.0/db_1/dbs
mkdir -p /home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area
mkdir -p /home/oracle/oracle/product/10.2.0/db_1/oradata/orcl
ORACLE_SID=orcl; export ORACLE_SID
echo You should Add this entry in the /etc/oratab: orcl:/home/oracle/oracle/product/10.2.0/db_1:Y/home/oracle/oracle/product/10.2.0/db_1/bin/sqlplus /nolog @/home/oracle/oracle/product/10.2.0/db_1/admin/orcl/scripts/orcl.sql




[oracle@alwarid-taj scripts]$ ./orcl.sh
You should Add this entry in the /etc/oratab: orcl:/home/oracle/oracle/product/10.2.0/db_1:Y
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
[oracle@alwarid-taj scripts]$ export ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1














18 comments:

Anonymous said...

great blog If you are the type to update your blog regulary, then you have gained one daily reader in me today. keep up the super work.

Anonymous said...

Can I clone your article to my blog? Thank you…

Anonymous said...

thank you for sharing with us, I believe this website truly stands out : D.

Anonymous said...

Hi !!! Good job!
Wuzzap?

Anonymous said...

Very amusing post. Thanks )

Anonymous said...

Thanks. I retwit it on my Twiiter
Bob Peters, CA

Anonymous said...

Good Article

Anonymous said...

Good Article

Anonymous said...

I have tried many custom writing services before, but yours turned to be the best. Thanks a lot.

Anonymous said...

Good Article

Anonymous said...

that is definitely what I was searching for, You have saved me alot of time

Anonymous said...

I am pleased that I noticed this website , precisely the right info that I was looking for! .

Anonymous said...

That was an excellently written essay, thank you so much.

Anonymous said...

I think, that you are mistaken. Write to me in PM, we will discuss.|

Jyoti said...

Excellent post...

Anonymous said...

Its working now.
Awesome post,Thanks a lot.

Anonymous said...

Thank you so much

Anonymous said...

Your site is really good and the posts are just wonderful. Thank you and keep doing your great work.