| Manually creating a 10g database [message #239941] |
Wed, 23 May 2007 12:53  |
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
|
Member |
|
|
Dear Team -
I have scripts used to create a database and I would like to create another database by personalizing the scripts I already have however, I need to know if I must create the directory along with its subdirectories prior to starting the instance using the pfile or will the pfile automaticly create the directory along with the subdirectories for me. If I do, then can someone please list the all the necessary parameters e.g controlfile, datafile, redo log, audit log paths, dumpfile destinations ETC
Also I need to know where to establish $ORACLE_BASE AND $ORACLE_HOME. Is it in the .profile file?
Obviously, I am very new at this so the help I can get will be highly appreciated.
Thanks
|
|
|
|
|
|
| Re: Manually creating a 10g database [message #239953 is a reply to message #239951] |
Wed, 23 May 2007 13:37  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
yes must create the directory structure if you want to create the database manually.
. If I do, then can someone please list the all the necessary parameters e.g controlfile, datafile, redo log, audit log paths, dumpfile destinations ETC
you only need the controlfile parameter in pfile to start the instance.
and if your are using solaris then set the variables like this
.profile_mydb
set -o emacs
TERM=vt100
alias list='ls -laF'
alias ps_me='ps -e -u oracle -o pid, ppid, command'
alias ddir='ls -l | grep ^d'
. /export/home/oracle/mydb/script/mydb_setup.sh
#!/bin/ksh
#
HOME=/export/home/oracle;
HOST="`hostname`";
export HOME
export HOST
#
#
# ORACLE environment variables
#
export ORACLE_HOME=/u01/opt/oracle/10.2.0
export ORACLE_BASE=/u01/opt/oracle/10.2.0
export ORACLE_SID=mydb
export LD_LIBRARY_PATH=/opt/app/ba/weblogic/lib/solaris/oci815_8
PATH=$ORACLE_HOME/bin:/jdk1.1.5/bin:/opt/SUNWspro/bin:/opt/SUNWvxva/bin:/usr/local/bin:/usr/bin:/usr/ccs/bin:$PATH
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Manually creating a 10g database [message #241454 is a reply to message #239941] |
Tue, 29 May 2007 12:04 |
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
|
Member |
|
|
|
My ORACLE_HOME has been established as /u01/app/oracle/product in .profile however I would like it to be /u01/app/oracle/product/10.2.0. Do I simply make adjustment in .profile or do I have to uninstall software and then re-declare?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
