Home » RDBMS Server » Server Administration » Manually creating a 10g database
Manually creating a 10g database [message #239941] Wed, 23 May 2007 12:53 Go to next message
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 #239951 is a reply to message #239941] Wed, 23 May 2007 13:28 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Also I need to know where to establish $ORACLE_BASE AND $ORACLE_HOME. Is it in the .profile file?
Yes, if you want but no need to $ORACLE_BASE just set PATH or ORACLE_HOME.

database creation
windows
http://dbataj.blogspot.com/search/label/Database%20Creation

linux
http://dbataj.blogspot.com/2007/02/manually-database-creation-on-linux.html
Re: Manually creating a 10g database [message #239953 is a reply to message #239951] Wed, 23 May 2007 13:37 Go to previous messageGo to next message
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 #239962 is a reply to message #239951] Wed, 23 May 2007 14:19 Go to previous messageGo to next message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
Oh thanks for your input this is really helpful!
Re: Manually creating a 10g database [message #239963 is a reply to message #239941] Wed, 23 May 2007 14:20 Go to previous messageGo to next message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
Thank you so much Taq. I couldn't wrap my brain around all the different subdirectories that needed to be created. Thanks again!
Re: Manually creating a 10g database [message #240092 is a reply to message #239941] Thu, 24 May 2007 02:14 Go to previous messageGo to next message
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
Member

can u provide the script for installing 9i or 10g database in redhat linux enterprise 3.
Re: Manually creating a 10g database [message #240098 is a reply to message #240092] Thu, 24 May 2007 02:28 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Oracle 10g
http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/toc.htm

http://dbataj.blogspot.com/2007/02/install-oracle-10gr2-on-linux.html


Oracle 9i
http://download-uk.oracle.com/docs/html/A96167_01/toc.htm
Re: Manually creating a 10g database [message #241454 is a reply to message #239941] Tue, 29 May 2007 12:04 Go to previous messageGo to next message
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?
Re: Manually creating a 10g database [message #241465 is a reply to message #241454] Tue, 29 May 2007 13:43 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
step by step installtion of oracle 9i

http://www.oracle-base.com/articles/9i/Articles9i.php#Installation

step by step installation of oracle 10g

http://www.oracle-base.com/articles/10g/Articles10g.php#DB10gInstallations
Previous Topic: Does Oracle Express Edition support Microstrategy Metadata?
Next Topic: Cannot startup db
Goto Forum:
  


Current Time: Fri Dec 09 09:59:56 CST 2016

Total time taken to generate the page: 0.06558 seconds