開源互助社區>文檔>Linux

linux中oracle的安裝

←手機掃碼閱讀火星人 @ 2014-03-08 , reply:0

1：以root登錄,掛載linux iso文件

[root@localhost ~]# mkdir /mnt/cdrom

[root@localhost ~]# mount /dev/cdrom /mnt/cdrom/

mount: block device /dev/cdrom is write-protected, mounting read-only

2：檢查包是否安裝 (軟體包源碼位於iso下的server目錄下)如果沒有安裝則需要安裝:

需要安裝的包：Red Hat Enterprise Linux 4.0 and Asianux 2.0:

binutils-2.15.92.0.2-13.EL4

compat-db-4.1.25-9

compat-libstdc -296-2.96-132.7.2

control-center-2.8.0-12

gcc-3.4.3-22.1.EL4

gcc-c -3.4.3-22.1.EL44

glibc-2.3.4-2.9

glibc-common-2.3.4-2.9

gnome-libs-1.4.1.2.90-44.1

libstdc -3.4.3-22.1

libstdc -devel-3.4.3-22.1

make-3.80-5

pdksh-5.2.14-30

sysstat-5.0.5-1

xscreensaver-4.18-5.rhel4.2

setarch-1.6-1

[root@localhost ~]# rpm -q compat-db

package compat-db is not installed

[root@localhost ~]# rpm -qa |grep compat

compat-libgcc-296-2.96-138

avahi-compat-libdns_sd-0.6.16-6.el5

compat-libstdc -296-2.96-138

java-1.4.2-gcj-compat-1.4.2.0-40jpp.115

compat-libstdc -33-3.2.3-61

[root@localhost ~]# rpm -qa |grep binutils

binutils-2.17.50.0.6-12.el5

[root@localhost ~]# cd /mnt/cdrom/Server/

[root@localhost Server]# rpm -ivh compat-db-4.2.52-5.1.i386.rpm

warning: compat-db-4.2.52-5.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186

Preparing... ########################################### [100%]

1:compat-db ########################################### [100%]

[root@localhost Server]# rpm -qa |grep control

control-center-2.16.0-16.el5

[root@localhost Server]# rpm -qa |grep gcc

compat-libgcc-296-2.96-138

libgcc-4.1.2-46.el5

gcc-4.1.2-46.el5

gcc-gfortran-4.1.2-46.el5

gcc-c -4.1.2-46.el5

[root@localhost Server]# rpm -qa |grep glibc

glibc-headers-2.5-42

glibc-2.5-42

glibc-common-2.5-42

glibc-devel-2.5-42

[root@localhost Server]# rpm -qa |grep libstdc

libstdc -devel-4.1.2-46.el5

compat-libstdc -296-2.96-138

libstdc -4.1.2-46.el5

compat-libstdc -33-3.2.3-61

[root@localhost Server]# rpm -qa |grep make

automake16-1.6.3-8

automake15-1.5-16

automake17-1.7.9-7

make-3.81-3.el5

automake14-1.4p6-13

automake-1.9.6-2.1

imake-1.0.2-3

[root@localhost Server]# rpm -qa |grep pdksh

[root@localhost Server]# rpm -ivh pdksh-5.2.14-36.el5.i386.rpm

warning: pdksh-5.2.14-36.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186

Preparing... ########################################### [100%]

1:pdksh ########################################### [100%]

[root@localhost Server]# rpm -qa |grep sysstat

[root@localhost Server]# rpm -ivh sysstat-7.0.2-3.el5.i386.rpm

warning: sysstat-7.0.2-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186

Preparing... ########################################### [100%]

1:sysstat ########################################### [100%]

[root@localhost Server]# rpm -qa |grep setarch

setarch-2.0-1.1

3：vim /etc/hosts 編輯

[root@localhost Server]# vim /etc/hosts

192.168.101.200 myhost.us.mycompany.com myhost

127.0.0.1 localhost.localdomain localhost

::1 localhost6.localdomain6 localhost6

4：Creating Required Operating System Groups and Users

[root@localhost Server]# groupadd dba

[root@localhost Server]# groupadd oinstall

[root@localhost Server]# groupadd oper

5：Creating an Oracle Software Owner User

[root@localhost Server]# useradd -g oinstall -G dba,oper oracle

[root@localhost Server]# passwd oracle

Changing password for user oracle.

New UNIX password:

BAD PASSWORD: it is too simplistic/systematic

Retype new UNIX password:

passwd: all authentication tokens updated successfully.

6：vim /etc/sysctl.conf 添加以下內容：

[root@localhost Server]# vim /etc/sysctl.conf

kernel.shmall = 2097152

kernel.shmmax = 2147483648

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 = 1048576

net.core.rmem_max = 1048576

net.core.wmem_default = 262144

net.core.wmem_max = 262144

7：vim /etc/security/limits.conf 添加以下內容：

[root@localhost Server]# vim /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

8：vim /etc/pam.d/login 添加以下內容：

[root@localhost Server]# vim /etc/pam.d/login

session required /lib/security/pam_limits.so

session required pam_limits.so

9：vim /etc/profile 添加以下內容：

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

10：

[root@localhost Server]# mkdir /u01

[root@localhost Server]# mkdir -p /u01/app/oracle

[root@localhost Server]# chown -R oracle:oinstall /u01/app/oracle

You have mail in /var/spool/mail/root

[root@localhost Server]# chmod -R 755 /u01/app/oracle

[root@localhost Server]# mkdir /u01/flash_recovery_area

[root@localhost Server]# chown -R oracle:oinstall /u01/flash_recovery_area/

[root@localhost Server]# chmod -R 755 /u01/flash_recovery_area/

11：

[root@localhost Server]# su - oracle

[oracle@localhost ~]$ vim .bash_profile

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/10.2.0

export ORACLE_SID=teacher

12：env | grep ORA 若無生效,則需 . .bash_profile

[oracle@localhost ~]$ . .bash_profile

[oracle@localhost ~]$ env | grep ORA

ORACLE_SID=teacher

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/10.2.0

13：測試圖形界面($)

若不成功則：

exit

#xhost local:oracle（後到VM中測試）

[oracle@localhost ~]$ exit

logout

[root@localhost ~]# xclock

14：換光碟（ora102forlinux）

[root@myhost ~]# cd /mnt/cdrom/Server/

[root@myhost Server]# rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm

warning: libXp-1.0.0-8.1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186

Preparing... ########################################### [100%]

1:libXp ########################################### [100%]

[root@myhost ~]# umount /dev/cdrom

[root@myhost ~]# mount /dev/cdrom /mnt/cdrom/

mount: block device /dev/cdrom is write-protected, mounting read-only

15：安裝安裝時不選擇裝資料庫

[root@myhost ~]# xhost local:oracle

non-network local connections being added to access control list

[root@myhost ~]# xclock

[root@myhost ~]# su - oracle

[oracle@myhost ~]$ xclock

[oracle@myhost ~]$ /mnt/cdrom/database/runinstaller

16：創建JianTingQi

netca

無法使用時,先配置.bash_profile

17：建庫 dbca

密碼：dsl123

[oracle@myhost ~]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 14 22:02:42 2012

Enter user-name: sys as sysdba

Enter password: dsl123

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> select * from scott.emp;

EMPNO ENAME JOB MGR HIREDATE SAL COMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7369 SMITH CLERK 7902 17-DEC-80 800

7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300

7521 WARD SALESMAN 7698 22-FEB-81 1250 500

EMPNO ENAME JOB MGR HIREDATE SAL COMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7566 JONES MANAGER 7839 02-APR-81 2975

7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400

7698 BLAKE MANAGER 7839 01-MAY-81 2850

EMPNO ENAME JOB MGR HIREDATE SAL COMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7782 CLARK MANAGER 7839 09-JUN-81 2450

7788 SCOTT ANALYST 7566 19-APR-87 3000

7839 KING PRESIDENT 17-NOV-81 5000

EMPNO ENAME JOB MGR HIREDATE SAL COMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7844 TURNER SALESMAN 7698 08-SEP-81 1500 0

7876 ADAMS CLERK 7788 23-MAY-87 1100

7900 JAMES CLERK 7698 03-DEC-81 950

EMPNO ENAME JOB MGR HIREDATE SAL COMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7902 FORD ANALYST 7566 03-DEC-81 3000

7934 MILLER CLERK 7782 23-JAN-82 1300

14 rows selected.

SQL> conn scott

Enter password: tiger

ERROR:tiger

ORA-28001: the password has expired

Changing password for scott

New password:tiger

Retype new password: tiger

Password changed

Connected.

SQL> show user

USER is "SCOTT"

SQL> select * from scott.emp;

EMPNO ENAME JOB MGR HIREDATE SAL COMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7369 SMITH CLERK 7902 17-DEC-80 800

7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300

7521 WARD SALESMAN 7698 22-FEB-81 1250 500

EMPNO ENAME JOB MGR HIREDATE SAL COMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7566 JONES MANAGER 7839 02-APR-81 2975

7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400

7698 BLAKE MANAGER 7839 01-MAY-81 2850

EMPNO ENAME JOB MGR HIREDATE SAL COMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7782 CLARK MANAGER 7839 09-JUN-81 2450

7788 SCOTT ANALYST 7566 19-APR-87 3000

7839 KING PRESIDENT 17-NOV-81 5000

EMPNO ENAME JOB MGR HIREDATE SAL COMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7844 TURNER SALESMAN 7698 08-SEP-81 1500 0

7876 ADAMS CLERK 7788 23-MAY-87 1100

7900 JAMES CLERK 7698 03-DEC-81 950

EMPNO ENAME JOB MGR HIREDATE SAL COMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7902 FORD ANALYST 7566 03-DEC-81 3000

7934 MILLER CLERK 7782 23-JAN-82 1300

14 rows selected.

用oracle登陸：

[root@myhost ~]# su - oracle

[oracle@myhost ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-MAY-2012 13:43:08

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost.us.mycompany.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 14-MAY-2012 20:27:43

Uptime 0 days 17 hr. 15 min. 25 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/10.2.0/network/admin/listener.ora

Listener Log File /u01/app/oracle/product/10.2.0/network/log/listener.log

Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost.us.mycompany.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "teacher.com" has 1 instance(s).

Instance "teacher", status READY, has 1 handler(s) for this service...

Service "teacherXDB.com" has 1 instance(s).

Instance "teacher", status READY, has 1 handler(s) for this service...

Service "teacher_XPT.com" has 1 instance(s).

Instance "teacher", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@myhost ~]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 15 13:44:22 2012

Enter user-name: sys as sysdba

Enter password: dsl123

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> alter user scott account lock; 把用戶鎖住

User altered.

SQL> conn scott 用用戶scott登陸

Enter password: tiger

ERROR:

ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.

SQL> show user

USER is "" 用戶為空

SQL> conn sys as sysdba

Enter password: dsl123

Connected.

SQL> alter user scott account unlock; 把用戶解鎖

User altered.

SQL> conn scott

Enter password:

tiger

Connected.

管理員登陸頁面：

更改密碼：

SQL> conn sys as sysdba 要用sys登陸更改

Enter password: dsl123

Connected.

SQL> alter user hr identified by hr123;

User altered.

SQL> conn hr

Enter password: hr123

Connected.

SQL>

普通用戶登陸頁面：

[oracle@myhost ~]$ isqlplusctl start 啟動

iSQL*Plus 10.2.0.1.0

getnameinfo failed

Starting iSQL*Plus ...

iSQL*Plus started.

不用安裝ORACLE客戶端（不執行*.exe）安裝PL/SQL Developer的說明

具體過程：

下載程序包：instantclient-basic-win32-10.2.0.3-20061115並解壓到一個盤下

安裝ORACLE客戶端

客戶端的安裝很簡單,即將下載的Oracle Client Package程序包壓縮文件,解壓到指定的文件夾即可（例如：F:\實訓\資料庫\soft）

新建sqlnet.ora和tnsnames.ora文件

在ORACEL客戶端安裝文件夾下新建sqlnet.ora和tnsnames.ora,並配置相關內容

（F:\實訓\資料庫\soft\instantclient-basic-win32-10.2.0.3-20061115\instantclient_10_2）

sqlnet.ora文件內容一般為:

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

tnsnames.ora文件內容：

[oracle@myhost ~]$ cd /u01/app/oracle/

[oracle@myhost oracle]$ cd product

[oracle@myhost product]$ ls

10.2.0

[oracle@myhost product]$ cd 10.2.0/

[oracle@myhost 10.2.0]$ cd network

[oracle@myhost network]$ ls

admin doc install jlib lib log mesg tools trace

[oracle@myhost network]$ cd admin

[oracle@myhost admin]$ ls

listener.ora samples shrept.lst tnsnames.ora

[oracle@myhost admin]$ cat tnsnames.ora 查看這個文件並複製到tnsnames.ora文檔中

TEACHER =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.101.200)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = teacher.com)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

配置環境變數

主要設置系統兩個變數TNS_ADMIN和NLS_LANG

TNS_ADMIN =F:\實訓\資料庫\soft\instantclient-basic-win32-10.2.0.3-20061115\instantclient_10_2

NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK

安裝pl/sql軟體

把（ [PLSQL.Developer].PLSQL.Developer.7 ）這個文件解壓打開zwt.nfo (其中含有機器碼 KF466HV42UACYYEBR82Y6JB4JVNHWH)然後再安裝setup.exe需要用到：

配置pl/sql的Oracle連接參數:

選擇pl/sql的工具/首選項(tool/ preference/)里的連接,在右面設置Oracle主目錄名(即安裝目錄)和OCI庫.

Oracle主目錄名: F:\實訓\資料庫\soft\instantclient-basic-win32-10.2.0.3-20061115\instantclient_10_2
OCI庫: F:\實訓\資料庫\soft\instantclient-basic-win32-10.2.0.3-20061115\instantclient_10_2\oci.dll

Tags: linux system 系統

[火星人 ] linux中oracle的安裝已經有536次圍觀

本文地址：http://coctec.com/docs/linux/show-post-45957.html

linux中oracle的安裝

熱門文章

最新文章