Linux class notes-day Nineth

Alternative

cd/media/ol6.4\ x86_64\ disc\ 1\ 20130225/packages/

Yuminstall oracle-rdbms-server-11gr2-preinstall-1.0-7.el6.x86_64.rpm

To resolve the hostname using the Hosts file:

# hostname

Node1.test.com

# vi/etc/hosts

Unzip the 2 installation packages in the physical host and share them with the virtual machine, with the following command:

# mkdir/installation

# mount-t vboxsf installation/installation

# cd/installation

# Unzip P10404530_112030_linux-x86-64_1of7.zip

# Unzip P10404530_112030_linux-x86-64_2of7.zip

Graphical Interface Installation:

# Xhost +

# su-oracle

$ cd/database/

$./runinstaller

Execute two scripts as root

Create monitoring under the graphical interface, Oracle executes:

$ netca

$ LSNRCTL Status

$ NETSTAT-TLNP | grep 1521

Graphical interface Creation Db,oracle execution:

$ dbca

General purpose or transaction processing

ORCL ORCL

Select a template resource Memory 1200

Database Character Level

Test:

Sqlplus test:

$ sqlplus sys/[email protected] as Sysdba

$ sqlplus/as SYSDBA

Sql> Show User

Sql> Select COUNT (*) from hr.employees;

Sql> exit

Browser testing:

Https://192.168.0.1:1158/em

Sys/password SYSDBA

Install Rlwrap:

Under Windows , move the rlwrap installation package to installation

Root Installation

# yum Install rlwrap-0.42-1.el6.x86_64.rpm

# VI ~ORACLE/.BASHRC

Alias sqlplus= ' Rlwrap sqlplus '

Alias rman= ' Rlwrap Rman '

# su-oracle

$ sqlplus/as SYSDBA

Sql>select * from Hr.employees;

To add a startup script:

# Vi/etc/oratab Change N to Y

Orcl:/u01/app/oracle/product/11.2.0/db_1:y

# vi/etc/rc.d/init.d/oracle

#!/bin/bash

#chkconfig: 35 99 01

Case "$" in

Start

Echo-n "Starting Oracle Database & Listener:"

Su-oracle-c ' Dbstart $ORACLE _home ' >/dev/null

echo "[OK]"

Echo-n "Starting Oracle EM dbconsole:"

Su-oracle-c "emctl start Dbconsole" >/dev/null

echo "[OK]"

Touch/var/lock/subsys/oracle

;;

Stop

Echo-n "shutting down Oracle EM dbconsole:"

Su-oracle-c "Emctl Stop Dbconsole" >/dev/null

echo "[OK]"

Echo-n "shutting down Oracle Database & Listener:"

Su-oracle-c ' Dbshut $ORACLE _home ' >/dev/null

echo "[OK]"

Rm-f/var/lock/subsys/oracle

;; *)

echo "Usage:oracle {start|stop}"

Exit 1

Esac

k# chkconfig--add Oracle

# chkconfig--list Oracle

Delete Password validity period:

# su-oracle

$ sqlplus/as SYSDBA

sql> alter profile default limit Password_life_time unlimited;

Normal close exit after rushing into new $ sqlplus/as sysdba Check

Database User:

SYS Administrator

SYSTEM operator

DBSNMP Simple Network Management protocol information

Sysman Automated Task Maintenance account

Unicode Unified Encoding UTF8 storage mode

Linux class notes-day Nineth