pythontr.com
mkdir -p /home/boran/oracle10g cd /home/boran/oracle10g unzip -x 10201_database_linux32.zip
groupadd oinstall groupadd dba useradd oracle -m -d /home/oracle -g oinstall -G dba -s /bin/bash passwd oracle
xauth list xauth add orclserver/unix:10 MIT-MAGIC-COOKIE-1 abcdef0123456789abcdef0123456789
aptitude install libXt6 libXp6 libXtst6
ssh -X oracle@boran DISPLAY=192.168.2.161:0.0; export DISPLAY
./runInstaller -IgnoreSysPreReqs -silent -responseFile /home/oracle/database/response/enterprise.rsp ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 ORACLE_HOME_NAME=ORADB102_Home10 n_configurationOption=3
vim /etc/oratab
orcl:/u01/app/oracle/product/10.2.0/db_1:N
su -
vim /etc/init.d/dbora
#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_HOME_LISTNER=$ORACLE_HOME
export ORACLE_OWNR=oracle
export ORACLE_OWNER=oracle
export ORACLE_SID=orcl
export ORACLE_UNQNAME=orcl
#export ORACLE_UNQNAME=DEFAULT
#export ORACLE_HOSTNAME=localhost.localdomain
export ORACLE_HOSTNAME=127.0.0.1
export PATH=$PATH:$ORACLE_HOME/bin
if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]
then
echo "Oracle startup: cannot start"
exit 1
fi
case "$1" in
start)
# Oracle listener and instance startup
echo -n "Starting Oracle: "
#su $ORACLE_OWNR -c "$ORACLE_HOME/bin/emctl start dbconsole"
su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl start"
#su $ORACLE_OWNR -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"
su - $ORACLE_OWNER -c "/home/oracle/scripts/startup.sh >> /home/oracle/scripts/startup_shutdown.log 2>&1"
touch /var/lock/subsys/dbora
echo "OK"
;;
stop)
# Oracle listener and instance shutdown
echo -n "Shutdown Oracle: "
su - $ORACLE_OWNER -c "/home/oracle/scripts/shutdown.sh >> /home/oracle/scripts/startup_shutdown.log 2>&1"
su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl stop"
#su $ORACLE_OWNR -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"
#su $ORACLE_OWNR -c "$ORACLE_HOME/bin/emctl stop dbconsole"
rm -f /var/lock/subsys/dbora
echo "OK"
;;
reload|restart)
$0 stop
$0 start
;;
*)
echo "Usage: `basename $0` start|stop|restart|reload"
exit 1
esac
exit 0
chmod u+x /etc/init.d/dbora
su - oracle mkdir -p /home/oracle/scripts chown oracle:oinstall /home/oracle/scripts
vim /home/oracle/scripts/startup.sh
# Start Database
sqlplus / as sysdba << EOF
STARTUP;
EXIT;
EOF
vim /home/oracle/scripts/shutdown.sh
# Stop Database
sqlplus / as sysdba << EOF
SHUTDOWN IMMEDIATE;
EXIT;
EOF
chmod u+x /home/oracle/scripts/startup.sh /home/oracle/scripts/shutdown.sh
vim .profile
. /home/oracle/scripts/oracle_env.sh
vim /home/oracle/scripts/oracle_env.sh
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
vim /u01/app/oracle/product/10.2.0/db_1/bin/dbstart
#ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle
ORACLE_HOME_LISTNER=$ORACLE_HOME
vim /u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora
*.compatible=10.2.0.1.0
*.control_files='ora_control1','ora_control2'
*.db_block_buffers=100# SMALL
*.db_file_multiblock_read_count=8# SMALL
*.db_files=80# SMALL
*.db_name='orcl'
*.global_names=TRUE
*.log_buffer=32768# SMALL
*.log_checkpoint_interval=10000
*.max_dump_file_size='10240'# limit trace file size to 5 Meg each
*.parallel_max_servers=5# SMALL
*.processes=50# SMALL
*.shared_pool_size=62198988# SMALL
mkdir /u01/app/oracle/product/10.2.0/db_1/dbs/orcl
vim /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
orcl=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=127.0.0.1)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=orcl)
)
)
vim /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
netstat -taunp Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 1041/portmap tcp 0 0 0.0.0.0:38640 0.0.0.0:* LISTEN 1053/rpc.statd tcp 0 0 127.0.0.1:1521 0.0.0.0:* LISTEN 2462/tnslsnr tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1551/sshd tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 1545/exim4 tcp 0 0 127.0.0.1:1521 127.0.0.1:46614 TIME_WAIT - tcp 0 0 127.0.0.1:1521 127.0.0.1:46610 TIME_WAIT - tcp 0 0 127.0.0.1:1521 127.0.0.1:46616 TIME_WAIT - tcp 0 0 127.0.0.1:1521 127.0.0.1:46615 TIME_WAIT - tcp 0 48 192.168.2.162:22 176.33.145.115:57474 ESTABLISHED 1668/sshd: boran [p tcp6 0 0 :::22 :::* LISTEN 1551/sshd tcp6 0 0 ::1:25 :::* LISTEN 1545/exim4 udp 0 0 0.0.0.0:45013 0.0.0.0:* 1053/rpc.statd udp 0 0 0.0.0.0:5353 0.0.0.0:* 1524/avahi-daemon: udp 0 0 0.0.0.0:111 0.0.0.0:* 1041/portmap udp 0 0 0.0.0.0:46618 0.0.0.0:* 1524/avahi-daemon: udp 0 0 0.0.0.0:805 0.0.0.0:* 1053/rpc.statd udp6 0 0 :::5353 :::* 1524/avahi-daemon: udp6 0 0 :::38269 :::* 1524/avahi-daemon:
sqlplus sys as sysdba SQL>show parameter db_name SQL> alter system set db_name=ORCL scope=spfile;
Yorumlar