TELDE – Installation Oracle 11g Database (Teil 9)

Anforderung

Benötigt wird eine Datenbank zum entwicklen von Oracle ADF und Oracle APEX Applikationen.

Lösung

1. Installation Oracle Database 11g

Komponenten

	Bereich	Komponente
	TELDE	Alle vorherigen Artikel der Serie
	Oracle Database 11g	Oracle® Database Software Download Oracle® Database Quick Installation Guide

Umsetzung

Bereich	Gegenstand
Download	Oracle® Database Software Download
Putty	Action: Start Putty
	Action: Open Save Session telde.local als Root
Shell	login as: root root@192.168.234.140's password: Last login: Thu Jul 30 23:45:02 2009 from 192.168.234.1
Benutzer Oracle anlegen	[root@telde ~]# groupadd dba [root@telde ~]# groupadd oinstall [root@telde ~]# useradd -g oinstall -G dba oracle [root@telde ~]# passwd oracle Changing password for user oracle. New UNIX password: welcome1 BAD PASSWORD: it is based on a dictionary word Retype new UNIX password: welcome1 passwd: all authentication tokens updated successfully. [root@telde ~]#
	[root@telde ~]# vi /etc/sysctl.conf # oracle kernel parameter fs.file-max = 6815744 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576
Erläuterung	Die oben aufgeführten Parameter müssen der entsprechenden Datei am Ende hinzugefügt werden.
Reboot	[root@telde ~]# shutdown -r now Broadcast message from root (pts/2) (Fri Jul 31 14:23:19 2009): The system is going down for reboot NOW! [root@telde ~]#
Putty	Action: Start Putty Action: Open Save Session telde.local als Root
	[root@telde ~]# vi /etc/security/limits.conf
	#oracle shell limits oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
	[root@telde ~]# vi /etc/pam.d/login
	# oracle pam session required pam_limits.so
	[root@telde ~]# vi /etc/profile
	#oracle user limits if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi
Oracle Base und Oracle Software Base	[root@telde ~]# mkdir -p /u01/app/oracle [root@telde ~]# chown -R oracle:oinstall /u01/app/oracle [root@telde ~]# chmod -R 775 /u01/app/oracle [root@telde ~]# mkdir -p /u01/product/oracle [root@telde ~]# chown -R oracle:oinstall /u01/product/oracle [root@telde ~]# chmod -R 775 /u01/product/oracle
	[root@telde ~]# su - oracle [oracle@telde ~]$ id uid=501(oracle) gid=502(oinstall) groups=501(dba),502(oinstall) [oracle@telde ~]$ pwd /home/oracle [oracle@telde ~]$ echo $SHELL /bin/bash [oracle@telde ~]$ echo $DISPLAY localhost:10.0 [oracle@telde ~]$ exit
Xming	Action: Xming starten
WinSCP	Kopieren des Downloads nach /u01/product/oracle/database/11.1 / software als Benutzer oracle
Putty	Action: Start Putty Action: Open Save Session telde.local als oracle
	login as: oracle oracle@192.168.234.140's password: /usr/bin/xauth: creating new authority file /home/oracle/.Xauthority [oracle@telde ~]$ cd /u01/app/oracle/ [oracle@telde oracle]$ ln -s /u01/product/oracle/ software
Unzip Software	[oracle@telde oracle]$ cd software/database/11.1/ software [oracle@telde 11.1]$ ls linux_11gR1_database.zip [oracle@telde 11.1]$ unzip linux_11gR1_database.zip : inflating: database/doc/server.111/b32009.pdf inflating: database/runInstaller
Install Database Software	[oracle@telde software]$ cd database/ [oracle@telde database]$ export DISPLAY=localhost:10.0 [oracle@telde database]$ ./runInstaller Starting Oracle Universal Installer... Checking Temp space: must be greater than 80 MB. Actual 10990 MB Passed Checking swap space: must be greater than 150 MB. Actual 2047 MB Passed Checking monitor: must be configured to display at least 256 colors. Actual 65536 Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-07-31_03-48-30PM. Please wait ...[oracle@telde database]$
	Select: Advance Installation Select: Next
Warning OUI Inventory	Choose: Ok
	Input: /u01/app/oracle/oraInventory Choose: Next
	Choose: Next
	Input Name: OraDb11g_db1 Choose: Next
	Choose: Next
Warning	Choose: Ok
	Choose: Next
	Choose: Next
	Input Global Database Name: orcl.telde.local Choose: Next
	Select: Character Set / Use Unicode
	Select: Sample Schemas / Create database with sample schema
	Choose: Next
	Choose: Next
	Select: Enable Automated Backup Input Password: welcome1
	Choose: Next
	Select: Use the same password for all accounts Input Password: welcome1 Choose: Next
	Choose: Next
	Choose: Next
Summary
	Choose: Install
	Choose: Ok
PUTTY	Action: Start Putty
	Action: Open Save Session telde.local als Root
	login as: root root@192.168.234.140's password: Last login: Thu Jul 30 23:45:02 2009 from 192.168.234.1
	[root@telde ~]$ /u01/app/oracle/oraInventory/orainstRoot.sh : [root@telde ~]$ /u01/app/oracle/product/11.1.0/db_1/root.sh : [root@telde ~]$ exit
OUI	Choose: Ok
	Choose: Exit Choose: Yes
Test	https://192.168.234.140:1158/em

Trouble Shooting

Fehler: X connection to localhost:10.0 broken (explicit kill or server shutdown).

Lösung:

• Xming ist nicht gestartet

oder

• DISPLAY Umgebungsvariable ist falsch

[oracle@telde database]$ echo $DISPLAY
localhost:10.0
[oracle@telde database]$ export DISPLAY=localhost:10.0

Anmerkung

Was jetzt noch fehlt für die Konfiguration der Datenbank ist der Autostart nach einem Reboot und entsprechende Skripte zum setzen des ORACLE_HOME. Das gibt es erst im nächsten Teil.