"Oracle Installation 2"

12. Use the Hosts file to resolve the hostname:

# hostname

Node1.test.com

# vi/etc/hosts

192.168.0.1 node1.test.com Node1

Virtual Machines Host

# ping Node1 Ping: force echo Request data (used to detect network connections or test network connection speed)

# ping Node1.test.com

13. The directory where the installation package is located is shared to the virtual machine and then decompressed. The command is as follows:

# mkdir/installation

# mount-t vboxsf installation/installation/

# cd/installation/

# ls

P10404530_112030_linux-x86-64_1of7.zip P10404530_112030_linux-x86-64_2of7.zip

#unzip P10404530_112030_linux-x86-64_1of7.zip

#unzip P10404530_112030_linux-x86-64_2of7.zip

[[email protected] installation]# ls

Database P10404530_112030_linux-x86-64_2of7.zip

P10404530_112030_linux-x86-64_1of7.zip

14. Graphical Interface Installation:

# Xhost +

# su-oracle

$ cd/database/

$./runinstaller

Execute two scripts as root

15. Create a Listener and database:

Create monitoring under the graphical interface, Oracle executes:

$ netca

$ lsnrctl Status// View status

$ NETSTAT-TLNP | grep 1521// listening window information

Graphical interface Creation Db,oracle execution:

$ dbca

General-purpose or transactional processing:ORCL/ORCL

Sys: System Administrator

System: Operators of the Systems

DBSNMP: Network administrator

Sysman: System maintenance Staff

selected Sample schemas

Character types are used to create

Memory:1200MB

database Character Set: Unicode(UTF8)

16. 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:

Root Installation

under Windows , copy the rlwrap package to installation

Check the mounted directory

[Email protected] ~]# cd/installation/

[[email protected] installation]# ls

[email protected] 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;

Sql> Exi// exit

17. 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

# chmod 755/etc/rc.d/init.d/oracle

# chkconfig--add Oracle

# chkconfig--list Oracle

18. Delete Password expiration Date:

# su-oracle

$ sqlplus/as SYSDBA

sql> alter profile default limit Password_life_time unlimited;

"Oracle Installation 2"