{"id":3650,"date":"2014-10-28T21:26:41","date_gmt":"2014-10-28T13:26:41","guid":{"rendered":"http:\/\/rmohan.com\/?p=3650"},"modified":"2014-10-31T22:59:54","modified_gmt":"2014-10-31T14:59:54","slug":"centos-6-5_x64-install-oracle-11g-r2","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=3650","title":{"rendered":"CentOS 6.5_x64 install Oracle 11g R2"},"content":{"rendered":"

[root@oracledb ~]# hostname
\noracledb
\n[root@oracledb ~]#<\/p>\n

[root@oracledb ~]# vi \/etc\/hosts
\n[root@oracledb ~]# ifconfig -a
\neth0\u00a0\u00a0\u00a0\u00a0\u00a0 Link encap:Ethernet\u00a0 HWaddr 00:0C:29:E7:97:A3
\ninet addr:192.168.1.8\u00a0 Bcast:192.168.1.255\u00a0 Mask:255.255.255.0
\ninet6 addr: fe80::20c:29ff:fee7:97a3\/64 Scope:Link
\nUP BROADCAST RUNNING MULTICAST\u00a0 MTU:1500\u00a0 Metric:1
\nRX packets:306 errors:0 dropped:0 overruns:0 frame:0
\nTX packets:202 errors:0 dropped:0 overruns:0 carrier:0
\ncollisions:0 txqueuelen:1000
\nRX bytes:32272 (31.5 KiB)\u00a0 TX bytes:24144 (23.5 KiB)<\/p>\n

lo\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Link encap:Local Loopback
\ninet addr:127.0.0.1\u00a0 Mask:255.0.0.0
\ninet6 addr: ::1\/128 Scope:Host
\nUP LOOPBACK RUNNING\u00a0 MTU:16436\u00a0 Metric:1
\nRX packets:12 errors:0 dropped:0 overruns:0 frame:0
\nTX packets:12 errors:0 dropped:0 overruns:0 carrier:0
\ncollisions:0 txqueuelen:0
\nRX bytes:720 (720.0 b)\u00a0 TX bytes:720 (720.0 b)<\/p>\n

[root@oracledb ~]# vi \/etc\/hosts
\n[root@oracledb ~]# hostname
\noracledb
\n[root@oracledb ~]# hostname
\noracledb
\n[root@oracledb ~]# sed -i “s\/SELINUX=enforcing\/SELINUX=disabled\/” \/etc\/selinux\/config
\n[root@oracledb ~]#\u00a0 setenforce 0
\n[root@oracledb ~]#\u00a0 yum -y install\u00a0 gcc gcc-c++ make binutilscompat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-commonglibc-devel libaio libaio-devel libgcclibstdc++ libstdc++-devel unixODBC unixODBC-devel<\/p>\n

[root@oracledb ~]# sysctl -p
\n[root@oracledb ~]# groupadd -g 200 oinstall
\n[root@oracledb ~]# groupadd -g 201 dba
\n[root@oracledb ~]# useradd -u 440 -g oinstall -G dba oracle
\n[root@oracledb ~]# passwd oracle
\n[root@oracledb ~]# vi \/etc\/sysctl.conf
\nnet.ipv4.ip_local_port_range= 9000 65500
\nfs.file-max = 6815744
\nkernel.shmall = 10523004
\nkernel.shmmax = 6465333657
\nkernel.shmmni = 4096
\nkernel.sem = 250 32000 100128
\nnet.core.rmem_default=262144
\nnet.core.wmem_default=262144
\nnet.core.rmem_max=4194304
\nnet.core.wmem_max=1048576
\nfs.aio-max-nr = 1048576<\/p>\n

[root@oracledb ~]# vi \/etc\/pam.d\/login
\nsession\u00a0\u00a0\u00a0 required\u00a0\u00a0\u00a0 pam_namespace.so
\nsession\u00a0\u00a0\u00a0 required\u00a0\u00a0\u00a0 pam_limits.so
\nvi \/etc\/profile<\/p>\n

if [ $USER =”oracle” ]; then
\nif [ $SHELL = “\/bin\/ksh” ];then
\nulimit -p 16384
\nulimit -n 65536
\nelse
\nulimit -u 16384 -n 65536
\nfi
\nfi
\n[root@oracledb ~]# mkdir \/opt\/oracle\/app\/
\n[root@oracledb ~]# mkdir \/opt\/oracle\/oradata\/
\n[root@oracledb ~]# chmod 755 \/opt\/oracle\/
\n[root@oracledb ~]# chmod 775 \/opt\/oracle\/app\/
\n[root@oracledb ~]# chown oracle.oinstall -R \/opt\/oracle\/
\n[oracle@oracledb ~]$ vi ~\/.bash_profile
\nexport ORACLE_BASE=\/opt\/oracle\/app
\nexport ORACLE_HOME=$ORACLE_BASE\/product\/11.2.0\/dbhome_1
\nexport PATH=$PATH:$ORACLE_HOME\/bin
\nexport ORACLE_PID=orcl<\/p>\n

working one <\/strong><\/p>\n

ORACLE_BASE=\/opt\/oracle\/app\/oracle;
\nORACLE_HOME=$ORACLE_BASE\/product\/11.2.0\/dbhome_1;
\nORACLE_SID=orcl;
\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib;
\nPATH=$PATH:$ORACLE_HOME\/bin:$HOME\/bin;
\nexport ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH;<\/p>\n

[oracle@oracledb ~]$ source .bash_profile
\n# vi \/etc\/rc.d\/init.d\/oracle<\/p>\n

Oracle<\/p>\n

#! \/bin\/bash
\n# chkconfig: 234 61 61
\n# description: Oracle 11g AutoRun Service
\n# \/etc\/rc.d\/init.d\/oracle<\/p>\n

case “$1” in
\nstart)
\n# starts oracle listener and instance
\necho “Starting Oracle Database:”
\nsu – oracle -lc “lsnrctl start”
\nsu – oracle -lc dbstartup
\n;;
\nstop)
\n# shutdown oracle listner and instance
\necho “Shuting down Oracle Database:”
\nsu – oracle -lc “lsnrctl stop”
\nsu – oracle -lc dbshutdown
\n;;
\nreload|restart)
\n$0 stop
\n$0 start
\n;;
\n*)
\necho “Usage: {start|stop|reload|restart}”
\nexit 1
\nesac
\nexit 0
\ndbstart dbshut<\/p>\n

2?dbstartup dbshutdown<\/p>\n

$ vi $ORACLE_HOME\/bin\/dbstartup<\/p>\n

#dbstartup
\n#\/opt\/oracle\/102\/bin
\nsqlplus \/ as sysdba <<EOF
\nstartup
\nexit
\nEOF
\nvi$ORACLE_HOME\/bin\/dbshutdown<\/p>\n

#dbshutdown
\n#\/home\/oracle\/102\/bin
\nsqlplus \/ as sysdba <<EOF
\nshutdown immediate
\nexit
\nEOF<\/p>\n

3?<\/p>\n

# cd \/etc\/rc.d\/init.d
\n# .\/oracle start
\n# .\/oracle stop<\/p>\n

4?oracle<\/p>\n

# chmod 750 \/etc\/rc.d\/init.d\/oracle
\n# chkconfig –level 234 oracle on
\n# chkconfig –add oracle
\n[root@oracledb software]# unzip linuxamd64_12102_database_1of2.zip
\n[root@oracledb software]# unzip linuxamd64_12102_database_2of2.zip<\/p>\n

[root@oracledb~]# xhost +
\n[root@oracledb~]# su \u2013 oracle
\n[root@oracledb~]# .\/software\/database\/runinstaller<\/p>\n

\"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a> \"db<\/a><\/p>\n

 <\/p>\n

[root@oracledb CVU_11.2.0.1.0_oracle]# sh runfixup.sh
\nResponse file being used is :.\/fixup.response
\nEnable file being used is :.\/fixup.enable
\nLog file location: .\/orarun.log
\nSetting Kernel Parameters…
\nThe value for semopm in response file is not greater than value for semopm in \/etc\/sysctl.conf file. Hence not changing it.
\nkernel.sem = 250 32000 100 128
\nfs.file-max = 6815744
\nThe value for file-max in response file is not greater than value for file-max in \/etc\/sysctl.conf file. Hence not changing it.
\nfs.file-max = 6815744
\nThe upper limit of ip_local_port range in reponse file is not greater than value in \/etc\/sysctl.conf, hence not changing it.
\nnet.ipv4.ip_local_port_range = 9000 65500
\nnet.core.rmem_default=262144
\nThe value for rmem_default in response file is not greater than value for rmem_default in \/etc\/sysctl.conf file. Hence not changing it.
\nnet.core.rmem_default = 262144
\nnet.core.wmem_default=262144
\nThe value for wmem_default in response file is not greater than value for wmem_default in \/etc\/sysctl.conf file. Hence not changing it.
\nnet.core.wmem_default = 262144
\nnet.core.rmem_max=4194304
\nThe value for rmem_max in response file is not greater than value for rmem_max in \/etc\/sysctl.conf file. Hence not changing it.
\nnet.core.rmem_max = 4194304
\nnet.core.wmem_max=1048576
\nThe value for wmem_max in response file is not greater than value for wmem_max in \/etc\/sysctl.conf file. Hence not changing it.
\nnet.core.wmem_max = 1048576
\nfs.aio-max-nr = 1048576
\nThe value for aio-max-nr in response file is not greater than value for aio-max-nr in \/etc\/sysctl.conf file. Hence not changing it.
\nfs.aio-max-nr = 1048576
\n[root@oracledb CVU_11.2.0.1.0_oracle]#yum install libaio* glibc* compat-libstdc* libaio-devel* libgcc* libstc++* unixoDBC* pdksh*<\/p>\n

download the url from<\/p>\n

http:\/\/mirror.centos.org\/centos\/6.5\/os\/i386\/Packages\/
\nhttp:\/\/mirror.centos.org\/centos\/6.5\/os\/i386\/Packages\/<\/p>\n

wget http:\/\/mirror.centos.org\/centos\/6.5\/os\/i386\/Packages\/libaio-0.3.107-10.el6.i686.rpm
\nwget http:\/\/mirror.centos.org\/centos\/6.5\/os\/i386\/Packages\/libaio-devel-0.3.107-10.el6.i686.rpm
\nwget http:\/\/mirror.centos.org\/centos\/6.5\/os\/i386\/Packages\/compat-libstdc++-33-3.2.3-69.el6.i686.rpm
\nwget http:\/\/mirror.centos.org\/centos\/6.5\/os\/i386\/Packages\/libgcc-4.4.7-4.el6.i686.rpm
\nwget http:\/\/mirror.centos.org\/centos\/6.5\/os\/i386\/Packages\/libstdc++-4.4.7-4.el6.i686.rpm
\nwget http:\/\/mirror.centos.org\/centos\/6.5\/os\/i386\/Packages\/unixODBC-2.2.14-12.el6_3.i686.rpm
\nwget http:\/\/mirror.centos.org\/centos\/6.5\/os\/i386\/Packages\/unixODBC-devel-2.2.14-12.el6_3.i686.rpm<\/p>\n

yum install libaio*
\nyum install libaio* glibc* compat-libstdc*
\nyum install libaio* glibc* compat-libstdc* libaio-devel* libgcc* libstc++* unixoDBC* pdksh*
\nyum install libgcc* libstc++* unixoDBC* pdksh*
\nyum search unixODBC
\nyum install libgcc* libstc++* unixODBC* pdksh*
\nyum install libgcc++*
\nyum search PDF
\nyum search pdksh
\nyum install mksh
\nyum search unixODBC*
\nyum search unixODBC
\nyum install unixODBC-devel.i686 unixODBC-devel.x86_64 unixODBC.i686 unixODBC.x86_64<\/p>\n

rpm -ivh compat-libstdc++-33-3.2.3-69.el6.i686.rpm
\nrpm -ivh libaio-0.3.107-10.el6.i686.rpm
\nrpm -ivh libaio-devel-0.3.107-10.el6.i686.rpm
\nrpm -ivh libstdc++-4.4.7-4.el6.i686.rpm
\n 80 yum remove libstdc++
\n 81 rpm -ivh libstdc++-4.4.7-4.el6.i686.rpm
\n 82 ls
\n 83 yum remove unixODBC
\n 84 ls
\n 85 rpm -ivh unixODBC-2.2.14-12.el6_3.i686.rpm unixODBC-devel-2.2.14-12.el6_3.i686.rpm<\/p>\n

Oracle common commands
\n[root @ oracledb ~] # su -oracle
\n[oracle @ oracledb ~] # sqlplus \/ as sysdba
\nSQL> startup # Start the database instance
\nSQL> shutdown immediate # close the database instance
\nSQL> select * from tab; # View all the tables
\nSQL> select name from v$datafile; # view database storage directory
\nSQL> show parameter service # View service name
\nSQL> select * from v$instance; # View instance name
\nSQL> select name from v$database; # Check the database name
\nSQL> select * from dba_users; # view all user information
\nSQL> select username, password from dba_users; # only query the user and password
\nSQL> select * from v$pwfile_users; # View user with sysdba privileges
\nSQL> select * from dba_ustats; # view the current user information
\nSQL> select * fromuser_sys_privs # view the permissions of the current user’s system
\nSQL> select * fromuser_role_privs # view the current user role
\nSQL> select * fromdba_sys_privs # View system permissions for the specified user has
\nSQL> select * from v$version; # View oracle version
\nSQL> select * fromuser_views # View View Information
\nSQL> show user
\nUSER is “SYS”<\/p>\n

SQL> select banner from v$version;<\/p>\n

BANNER
\n——————————————————————————–
\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
\nPL\/SQL Release 11.2.0.1.0 – Production
\nCORE 11.2.0.1.0 Production
\nTNS for Linux: Version 11.2.0.1.0 – Production
\nNLSRTL Version 11.2.0.1.0 – Production<\/p>\n

[root @ oracledb ~] # lsnrctl start # turn on the remote listening port
\n### Remote connection information<\/p>\n

oracle user
\n#sys and system users difference
\nDifferent 1> the importance of storing data
\nsys to store the data dictionary base tables and views, maintained by the database itself, any user can manually change, sys user owns dba, sysdba, sysoper other roles or privileges, is the highest authority oracle user.
\nThe system users only store some level of internal data, such as management information oracle of some features or tools. For database management, System users have ordinary dba role permissions.
\n2> Different permissions
\nsysoper sys user with sysdba or system privileges, log em can only use these two identities, can not use normal.
\nsystem user can log on em with normal identity, unless you have it granted sysdba system privileges or syspoer system privileges.
\n#sysdba and sysoper difference between the two systems permissions
\nnormal ordinary users
\nsysdba has the highest system privileges, log is sys
\nsysoper mainly used to start, shut down the database login user is public after sysoper
\nThe difference #dba and sysdba
\nFirst understand the process of creating the next oracle service: Create an instance -> Start Instance -> Create Database
\nStartup process: Example start -> Load Database -> Open Database
\nsysdba is to manage the oracle instance, its existence does not depend on the entire database is fully activated, as long as the instance starts up, it already exists as sysdba login, load the database, open the database. Only the database is open, or the entire database completely after starting, dba role only exists foundation.<\/p>\n","protected":false},"excerpt":{"rendered":"

[root@oracledb ~]# hostname oracledb [root@oracledb ~]#<\/p>\n

[root@oracledb ~]# vi \/etc\/hosts [root@oracledb ~]# ifconfig -a eth0 Link encap:Ethernet HWaddr 00:0C:29:E7:97:A3 inet addr:192.168.1.8 Bcast:192.168.1.255 Mask:255.255.255.0 inet6 addr: fe80::20c:29ff:fee7:97a3\/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:306 errors:0 dropped:0 overruns:0 frame:0 TX packets:202 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:32272 (31.5 KiB) TX bytes:24144 (23.5 KiB)<\/p>\n

[…]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/3650"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3650"}],"version-history":[{"count":4,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/3650\/revisions"}],"predecessor-version":[{"id":3677,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/3650\/revisions\/3677"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}