download software oracle Februari 20, 2009
Posted by setijoagus in Oracle Install, oracle.Tags: download
add a comment
Banyak yang nggak tahu cara download software oracle, lewat japri nanya ke saya misalnya :
1.
Mas…
Saya ……., saya mau bertanya…..
Dimana saya bisa mendapatkan atau free download software oracle 10g enterprise???
2.
Saya baru saja memulai belajar database oracle, tetapi saya tidak bisa mempraktekkannya karena tidak memiliki software oracle.
Dimana saya bisa mendapatkan atau free download software oracle 10g release 2 ????
Soalnya saya tidak bisa mendownload di www.oracle.com karena saya tidak memiliki account..
Mohon bantuan teman-teman sekalian..
Terima Kasih sebelumnya..
sebenarnya software2 tsb dapat di download dengan gratis (hanya untuk dipelajari, untuk production harus bayar) di www.oracle.com, account. juga dapat dicreate dengan gratis asal ngisinya benar. Tetapi ingat besarnya yang di download besar sekali loh.
install oracle 11g – 64 bit (3) Februari 16, 2009
Posted by setijoagus in Oracle Install, oracle.Tags: 11g, 64 bit, install Oracle
add a comment
Oracle Database 11g – 64 bit
install oracle 11g – 64 bit (2) Februari 16, 2009
Posted by setijoagus in Oracle Install, oracle.Tags: 11g, 64 bit, install
add a comment
install centos 5.2 64 bit
install oracle 11g – 64 bit (1) Februari 16, 2009
Posted by setijoagus in Oracle Install, oracle.Tags: 11g, 64 bit, install
2 comments
1. create user, password, profile
# groupadd oinstall
# groupadd dba
# groupadd oper
# groupadd asmadmin
# useradd -u 500 -g oinstall -G dba,oper,asmadmin oracle
# mkdir -p /u01/app/oracle/product/11.1.0/db_1
# chown -R oracle:oinstall /u01
# vi /home/oracle/.bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=test.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=test; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
# chown oracle.oinstall /home/oracle/.bash_profile
# passwd oracle
2. edit /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=262144
# sysctl -p
3. edit /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
4. edit /etc/pam.d/login
session required /lib/security/pam_limits.so
5. edit /etc/hosts
# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
172.20.33.33 test test.localdomain
6. install rpm
# rpm -Uvh elfutils-0.125-3.el5.i386.rpm
# rpm -Uvh elfutils-devel-0.125-3.el5.i386.rpm
# rpm -Uvh elfutils-devel-static-0.125-3.el5.i386.rpm
# rpm -Uvh elfutils-libelf-0.125-3.el5.i386.rpm
# rpm -Uvh elfutils-libelf-devel-0.125-3.el5.i386.rpm
# rpm -Uvh elfutils-libelf-devel-static-0.125-3.el5.i386.rpm
# rpm -Uvh elfutils-libs-0.125-3.el5.i386.rpm
# rpm -Uvh libaio-0.3.106-3.2.i386.rpm
# rpm -Uvh libaio-devel-0.3.106-3.2.i386.rpm
# rpm -Uvh libao-0.8.6-5.i386.rpm
# rpm -Uvh libao-devel-0.8.6-5.i386.rpm
# rpm -Uvh sysstat-7.0.0-3.el5.i386.rpm
# rpm -Uvh unixODBC-2.2.11-7.1.i386.rpm
# rpm -Uvh unixODBC-devel-2.2.11-7.1.i386.rpm
7. download & unzip
# unzip linux.x64_11gR1_database.zip
8. login oracle
$ ./runInstaller
# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory to 770.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete
# /u01/app/oracle/product/11.1.0/db_1/root.sh
Running Oracle 11g root.sh script…
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.1.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin …
Copying oraenv to /usr/local/bin …
Copying coraenv to /usr/local/bin …
Creating /etc/oratab file…
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
9. OEM
Enterprise Manager Database Control URL – (test) :
https://test.localdomain:1158/em
Remote Install Oracle (GUI Linux) Februari 16, 2009
Posted by setijoagus in Oracle Install, oracle.Tags: oracle, remote install
add a comment
1. download Xming-mesa-6-9-0-31-setup.exe
http://sourceforge.net/project/downloading.php? group_id=156984&filename=Xming-mesa-6-9-0-31-setup.exe
2. download putty.exe
http://the.earth.li/~sgtatham/putty/0.60/x86/putty.exe
3. In the PuTTY configuration window, select “Connection->SSH->X11″ and make sure the “Enable X11 forwarding box is checked
4. edit /etc/ssh/sshd_config
[root@bb ~]# vi /etc/ssh/sshd_config
# X11 tunneling options
X11Forwarding yes
X11DisplayOffset 10
X11UseLocalhost yes
5. reload SSH
[root@bb ~]# service sshd reload
Reloading sshd: [ OK ]
6. running xming
7. running putty
Install Oracle 11g RAC 64 bit Januari 2, 2009
Posted by setijoagus in Oracle Install, oracle.Tags: 64 bit, oracle 11g, RAC
2 comments
Oracle : database 11g 64 bit
clusterware 11g 64 bit
O/S : Linux Centos 5.2 64 bit
Desktop : intel pentium dual core x 4
SAN : Hitachi Tagma Store
SAN switch : Brocade 200E
HBA Card : Emulex Card
HUB : hub switch 16 port prolink
KVM : manual
download rpm : redhat-release-5-1.0.el5.centos.1.i386
http://www.idevelopment.info/data/Oracle/DBA_tips/Oracle11gRAC/Install11gR1RACOnCentOS51/RPMS/redhat-release-5-1.0.el5.centos.1.i386.rpm
New Install Oracle – Basic init.ora Januari 2, 2009
Posted by setijoagus in Oracle Install, oracle.Tags: init.ora, oracle
add a comment
Karena terlalu seringnya install oracle database server, maka juga sering juga (lho kok) lupa setting apa saja yang perlu diperhatikan agar oracle database dapat digunakan secara optimal menurut pengalaman saya, paling tidak adalah :
a. sessions
SQL> alter system set sessions = 335 scope=spfile;
b. open_cursors
SQL> alter system set open_cursors = 600 scope=spfile;
c. processes
SQL> alter system set processes = 300 scope=spfile;
d. archive
SQL> alter database archivelog;
SQL> alter system set log_archive_dest_1=’location=/u03′;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u03
Oldest online log sequence 1124
Next log sequence to archive 1125
Current log sequence 1125
e. memory
SQL> alter system set memory_max_target=3G scope=spfile;
SQL> alter system set memory_target=3G scope=spfile;
SQL> alter system set sga_max_size=3G scope=spfile;
SQL> alter system set sga_target=0 scope=spfile;
f. schedulle backup dmp
$ crontab -e
0 0 * * 1,3,5 /backup/script/back01b
30 0 * * 1,3,5 /backup/script/back01c
0 0 * * 2,4,6 /backup/script/back02b
30 0 * * 2,4,6 /backup/script/back02c
0 0 * * 7 /backup/script/back03b
30 0 * * 7 /backup/script/back03c
Instalasi Oracle XE pada Linux Centos 5.0 Desember 27, 2008
Posted by setijoagus in Oracle Install, oracle.Tags: oracle xe
add a comment
Setelah sukses melakukan download oracle-xe-10.2.0.1-1.0.i386.rpm, kita dapat segera melakukan proses instalasi.
a. lakukan instalasi menggunakan rpm
[root@oracle test]# rpm -ivh oracle-xe-10.2.0.1-1.0.i386.rpm
Preparing… ########################################### [100%]
1:oracle-xe ########################################### [100%]
Executing Post-install steps…
You must run ‘/etc/init.d/oracle-xe configure’ as the root user to
configure the database.
b. Menjalankan script /etc/init.d/oracle-xe configure
[root@oracle test]# /etc/init.d/oracle-xe configure
Oracle Database 10g Express Edition Configuration
————————————————-
This will configure on-boot properties of Oracle Database 10g Express
Edition. The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts. Press <Enter> to accept the defaults.
Ctrl-C will abort.
c. Mengisi port HTTP Oracle Application Express, pilih default 8080
Specify the HTTP port that will be used for Oracle Application Express [8080]:
d. Mengisi port Listener database, pilih default 1521
Specify a port that will be used for the database listener [1521]:
e. Mengisi password SYS dan SYSTEM
Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Confirm the password:
f. Mensetup apakah Oracle Database 10g Express Edition, selalu startup setiap boot, pilih y
Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:
Starting Oracle Net Listener…Done
Configuring Database…Done
Starting Oracle Database 10g Express Edition Instance…Done
Installation Completed Successfully.
To access the Database Home Page go to “http://127.0.0.1:8080/apex”
Instalasi Oracle XE pada Windows XP Desember 27, 2008
Posted by setijoagus in Oracle Install, oracle.Tags: oracle xe
2 comments
Setelah sukses melakukan download OracleXe
a. Double click pada file OracleXE.exe untuk memulai melakukan instalasi Oracle XE database
b. Klik ‘Next’
c. Menyetujui License Agreement. klik ‘Next’
d. Menentukan folder untuk install Oracle XE. klik ‘Next’
e. Menentukan password dari SYS & SYSTEM, misalkan dalam contoh ini menggunakan password xe, klik ‘Next’
f. Klik ‘Install’ untuk memulai instalasi.
g. Tunggu sampai proses instalasi selesai
h. Periksa dengan klik ‘Launch Database homepage’ dan klik ‘Finish’.
i. Logon ke database home page untuk memastikan apakah database telah diinstal dengan sukses. Enter username dengan ‘SYSTEM’ dan password dalam contoh ini xe, kemudian enter xe.
j. Jika tampilan seperti gambar di bawah ini, maka instalasi Oracle XE telah berhasil, klik ‘Logout’ untuk keluar.
Automatic Startup – Shutdown database ORACLE 11g Desember 9, 2008
Posted by setijoagus in Oracle Administration, Oracle Install, oracle.Tags: oracle 11g, startup shutdown
1 comment so far
1. create script start database
[oracle@mkt ~]$ cd $ORACLE_HOME/bin
[oracle@mkt bin]$ vi startora11g
#!/bin/sh
# Start the oracle database
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1
export ORACLE_SID=mkt
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_TERM=xterm
$ORACLE_HOME/bin/dbstart
exit 0
[oracle@mkt bin]$ chmod u+x startora11g
2. create script stop database
[oracle@mkt ~]$ cd $ORACLE_HOME/bin
[oracle@mkt bin]$ vi stopora11g
#!/bin/sh
# Stop the oracle database
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1
export ORACLE_SID=mkt
export ORACLE_TERM=xterm
$ORACLE_HOME/bin/dbshut
exit 0
[oracle@mkt bin]$ chmod u+x stopora11g
3. create script restart, start & stop
[oracle@mkt ~]$ cd $ORACLE_HOME/bin
[oracle@mkt bin]$ vi oracle11g
#!/bin/sh
#
# chkconfig: 345 51 49
# description: startup and shutdown the Oracle 8i database
#
echo “Oracle 11g database start/stop/restart”
ORA_OWNER=oracle
ORA_BASE=/u01/app/oracle
ORA_HOME=$ORA_BASE/product/11.1.0/db_1
case “$1″ in
’start’)
# Start the database
echo -n “Starting the database for 11g: “
su – $ORA_OWNER -c $ORA_HOME/bin/startora11g
echo
;;
’stop’)
# Stop the database
echo -n “Shutting down database for 11g: “
su – $ORA_OWNER -c $ORA_HOME/bin/stopora11g
echo
;;
‘restart’)
# Restart the Oracle databases:
echo -n “Restarting database for 11g: “
$0 stop
$0 start
echo
;;
*)
echo “Usage: oracle11g [ start | stop | restart }"
exit 1
esac
exit 0
[oracle@mkt bin]$ chmod u+x oracle11g
4. Login root & edit /etc/oratab.
[oracle@mkt bin]$ su – root
Password:
[root@mkt ~]# vi /etc/oratab
mkt:/u01/app/oracle/product/11.1.0/db_1:N
menjadi
mkt:/u01/app/oracle/product/11.1.0/db_1:Y
5. copy script oracle11g to /etc/rc.d/init.d/
[root@mkt ~]# cp /u01/app/oracle/product/11.1.0/db_1/bin/oracle11g /etc/rc.d/init.d/
[root@mkt ~]# chmod 700 /etc/rc.d/init.d/oracle11g
6. test script oracle11g start, stop, restart with login as root
[root@mkt ~]# cd /etc/rc.d/init.d
[root@mkt init.d]# ./oracle11g
Oracle 11g database start/stop/restart
Usage: oracle11g [ start | stop | restart }
[root@mkt init.d]# ./oracle11g start
Oracle 11g database start/stop/restart
Starting the database for 11g: ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/11.1.0/db_1/bin/dbstart ORACLE_HOME
Processing Database instance “mkt”: log file /u01/app/oracle/product/11.1.0/db_1/startup.log
[root@mkt init.d]# ./oracle11g stop
Oracle 11g database start/stop/restart
Shutting down database for 11g: ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener
Usage: /u01/app/oracle/product/11.1.0/db_1/bin/dbshut ORACLE_HOME
Processing Database instance “mkt”: log file /u01/app/oracle/product/11.1.0/db_1/shutdown.log
[root@mkt init.d]# ./oracle11g restart
Oracle 11g database start/stop/restart
Restarting database for 11g: Oracle 11g database start/stop/restart
Shutting down database for 11g: ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener
Usage: /u01/app/oracle/product/11.1.0/db_1/bin/dbshut ORACLE_HOME
Processing Database instance “mkt”: log file /u01/app/oracle/product/11.1.0/db_1/shutdown.log
Oracle 11g database start/stop/restart
Starting the database for 11g: ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/11.1.0/db_1/bin/dbstart ORACLE_HOME
Processing Database instance “mkt”: log file /u01/app/oracle/product/11.1.0/db_1/startup.log
7. chkconfig pada script oracle11g
[root@mkt init.d]# /sbin/chkconfig –add oracle11g
[root@mkt init.d]# /sbin/chkconfig –list oracle11g
oracle11g 0:off 1:off 2:off 3:on 4:on 5:on 6:off
[root@mkt init.d]# /sbin/chkconfig oracle11g on
