初學安裝oracle全部過程圖文教程
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
)
)
B:sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
C:tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
SHZQ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = shzq)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
-----------------------------------------------------------------------------------------
5.如果安裝Oracle發(fā)現(xiàn)swap分區(qū)過小的情況，則可以手動去擴展swap分區(qū)的大小
//使用root用戶
#dd if=/dev/zero of=/home/swap bs=1024 count=1024000
//創(chuàng)建/home/swap分區(qū)文件。大小為1024000個block，一般情況下1個block為1K，所以這里空間是1024M（1G）;
//指定分區(qū)類型為swap
//使用mkswap命令把分區(qū)變成swap分區(qū)如下
#/sbin/mkswap /home/swap
//讓配置的swap生效
#/sbin/swapon /home/swap
//free -m 查看swap和內存大小
#free -m
//修改/etc/fstab文件讓其自動掛載
#/home/swap swap swap defaults 0 0
6.讓另一臺客戶端或者應用服務器連接本服務器的oracle數(shù)據(jù)庫
//前提:客戶端或者應用服務器必須至少安裝oracle客戶或者oracle數(shù)據(jù)庫
錯誤提示：
>sqlplus /nolog
SQL> conn '/as sysdba'
請輸入口令: ******
ERROR：
ORA-12560: TNS: 協(xié)議適配器錯誤
SQL> connect system/manager
ERROR：
ORA-12560: TNS: 協(xié)議適配器錯誤
//說明：從客戶端或者應用服務器（linux或WIN）
#tnsnping 192.168.1.11
#tnsping oracle10g //需要做好解析
//以Windows為例：
C:\Documents and Settings\Administrator>tnsping 192.168.1.11
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 15-2月 -
2012 14:16:18
Copyright (c) 1997, 2005, Oracle. All rights reserved.
已使用的參數(shù)文件:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 EZCONNECT 適配器來解析別名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=192.168.1.11))(AD
DRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(PORT=1521)))
OK (20 毫秒)
-----------------------------------------------------------------------------------------
7.客戶端連接oracle配置文件實例：（見附件）
A:listener.ora
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
)
)
B:sqlnet.ora
# sqlnet.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
C:tnsnames.ora
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
SHZQ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = shzq)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
-----------------------------------------------------------------------------------------
8.oracle安裝完成，系統(tǒng)自帶的用戶和密碼
//internal/oracle
// sys/change_on_install
//system/manager
//scott/tiger
//sysman/oem_temp
三、使用PLSQL Developer 管理linux Oracle服務器
1.登陸
2.使用
