Pythontr

husonet | Tarih: 17.04.2024

Debian Oracle 10g Enterprise kurulumu

10g lisansı Oracle Enterprise kurulumu.

indirmemiz gereken dosya 10201_database_linux32.zip


mkdir -p /home/boran/oracle10g
cd /home/boran/oracle10g
unzip -x 10201_database_linux32.zip


oracle kullanıcısı açma ve yapilandirma
groupadd oinstall
groupadd dba
useradd oracle -m -d /home/oracle -g oinstall -G dba -s /bin/bash
passwd oracle


xauth ekleme
xauth list
xauth add orclserver/unix:10 MIT-MAGIC-COOKIE-1 abcdef0123456789abcdef0123456789


Kurulacak paketler
aptitude install libXt6 libXp6 libXtst6


SSH ile kurulum yapalım
ssh -X oracle@boran
DISPLAY=192.168.2.161:0.0; export DISPLAY


Debian da kurulum için aşağıdaki parametreleriyle birlikte runInstallerı çalıştıralım...
# Bu desen 10 g için hazırlandı
./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


Kurulumdan sonra root olarak /u01/app/oracle/product/10.2.0/db_1/root.sh çalıştıralım.

oratab dosyası ayarları
vim /etc/oratab
orcl:/u01/app/oracle/product/10.2.0/db_1:N


Servis dosyasını oluşturalım
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


Çalıştırma izini
chmod u+x /etc/init.d/dbora



Profile Ayarlarını Yapalım
su - oracle
mkdir -p /home/oracle/scripts
chown oracle:oinstall /home/oracle/scripts


Startup file

vim /home/oracle/scripts/startup.sh
# Start Database
sqlplus / as sysdba << EOF
STARTUP;
EXIT;
EOF


Shutdown file

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


Genel Ayarlar
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


TNS Name dosyasını ayarlayalım
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)
)
)


Listener Ora dosyasını ayarlayalım
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 ile 1521 nolu portumuz dinleme yapıyormu bakalım
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;