How to use a specific database on a server with multiple oracle databases - 11g OEL (merged 5) [message #406910] |
Sun, 07 June 2009 09:49 |
v_zaitsev
Messages: 12 Registered: May 2009 Location: Manila
|
Junior Member |
|
|
I've have a problem guys since I'm a new DBA and with little experience. I successfully created a database server with and OEL5 OS and Oracle 11g installed. If I would create 10 more databases how would i set my SID so that it can be set dynamically and so that before I would run SQLPLUS it would point to the right database?
At my work we have a RHEL4 with 3 different Oracle databases installed 9i,10g,11g what would i normally do is just type the command sid <DATABASE SID> and it automatically sets the SID see example below:
#> sid MLA230DV
Oracle User, 9.x or 10.x Version
<info> You are now setup for Oracle 10203
ORACLE_SID=MLA230DV
ORACLE_HOME=/orasw/app/oracle/product/10203
oracle@hipposerver /orasw/app/oracle/product
So when i SQLPLUS it would point to the correct database see example below:
#> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Sun Jun 7 07:40:30 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning and Data Mining options
SYS on MLA230DV>
I'm asking this because I was asked to create a server with multiple databases on it but this time I will be only using 11g software since the DBA's before me left and nobody is guiding me how things work. How can I go about this? Do I have to create or set this manually or Oracle can automatically handle this kind of situations? Any help would be greatly appreciated.
|
|
|
|
|
|
|
|
Re: How to use a specific database on a server with multiple oracle databases - 11g OEL (merged 5) [message #406920 is a reply to message #406910] |
Sun, 07 June 2009 10:21 |
v_zaitsev
Messages: 12 Registered: May 2009 Location: Manila
|
Junior Member |
|
|
oracle@hippolinux /orasw/app/oracle/product #> env | sort
_AST_FEATURES=UNIVERSE - ucb
AWK=nawk
A__z="*OPTIND
_=/bin/env
COBMODE=64
CVS_RSH=ssh
DISPLAY=202.95.238.205:0.0
EDITOR=vi
FPATH=/spl/sysadm/userfuncs
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HNAME=202.95.238.205
HOME=/orasw
HOSTNAME=hippolinux
HOST=hippolinux
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LD_LIBRARY_NAME=/lib:
LD_LIBRARY_PATH=:/orasw/app/oracle/product/10203/lib:/orasw/app/oracle/product/10203/lib32
LESSOPEN=|/usr/bin/lesspipe.sh %s
LIBP=LD_LIBRARY_PATH
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
OPTIND=1
OPT_Q=N
ORACLE_BASE=/orasw/app/oracle
ORACLE_HOME=/orasw/app/oracle/product/10203
ORACLE_SID=MLA230DV
ORATAB=/etc/oratab
PATH=/orasw/app/oracle/product/10203/bin:/spl/sysadm:/usr/local/bin:/opt/Komodo-IDE-4.1/bin:/spl/sysadm:/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin::/orasw/app/oracle/product/10203/opmn/bin
PS1=$LOGNAME@$HOST $PWD
PWD=/orasw/app/oracle/product
SHELL=/usr/bin/ksh
SPLBCKLOGDIR=/tmp
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_CLIENT=202.95.238.205 1650 22
SSH_CONNECTION=202.95.238.205 1650 202.95.238.206 22
SSH_TTY=/dev/pts/1
TERM=xterm
TTY=0
USER=oracle
oracle@hippolinux /orasw/app/oracle/product
oracle@hippolinux /orasw/app/oracle/product #> alias
2d='set -f;_2d'
autoload='typeset -fu'
command='command '
fc=hist
float='typeset -lE'
functions='typeset -f'
hash='alias -t --'
history='hist -l'
integer='typeset -li'
je='. /spl/sysdev/je.sh'
l.='ls -d .* --color=tty'
ll='ls -l --color=tty'
ls='ls --color=tty'
nameref='typeset -n'
nohup='nohup '
o10202='. setoraversion.sh 10202'
o10203='. setoraversion.sh 10203'
o11106='. setoraversion.sh 11.1.0.6'
oagent10g='. setoraversion.sh agent10g'
oowb10201='. setoraversion.sh owb10201'
r='hist -s'
redirect='command exec'
source='command .'
stop='kill -s STOP'
suspend='kill -s STOP $$'
times='{ { time;} 2>&1;}'
type='whence -v'
which='alias | /usr/bin/which --tty-only --read-alias --show-dot --show-tilde'
oracle@hippolinux /orasw/app/oracle/product
I hope this can help. Thanks. Btw what are we looking for?
[Updated on: Sun, 07 June 2009 10:22] Report message to a moderator
|
|
|
|
|