1，啟動(dòng)ASM 數(shù)據(jù)庫(kù)的步驟
由于啟動(dòng)ASM 數(shù)據(jù)庫(kù)必須要先啟動(dòng)ASM 實(shí)例，所以基本上啟動(dòng)步驟如下。
1． 以oracle 用戶進(jìn)入操作系統(tǒng)
2． $ export ORACLE_SID=+ASM
3,
[oracle@Rm-DevDB ~]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 16 16:55:02 2010

Copyright (c) 1982, 2005, Oracle.? All rights reserved.

Enter user-name: /as sysdba
Connected to an idle instance.

SQL>
4． SQL> startup
SQL> startup
ASM instance started

Total System Global Area? 130023424 bytes
Fixed Size????????????????? 2019032 bytes
Variable Size???????????? 102838568 bytes
ASM Cache????????????????? 25165824 bytes
ASM diskgroups mounted
SQL> exit
5． SQL> exit

6． $ export ORACLE_SID=<your_real_db_sid>
7． SQL> sqlplus / as sysdba
8． SQL> startup

SQL> startup
ORACLE instance started.

Total System Global Area 1224736768 bytes
Fixed Size????????????????? 2020384 bytes
Variable Size???????????? 318770144 bytes
Database Buffers????????? 889192448 bytes
Redo Buffers?????????????? 14753792 bytes
Database mounted.
Database opened.
需要重新啟動(dòng)2遍
8.啟動(dòng)監(jiān)聽器：[oracle@Rm-DevDB ~]$ lsnrctl start

9,啟動(dòng)em控制器：[oracle@Rm-DevDB ~]$ emctl start dbconsole


2，配置listener.ora

正常的監(jiān)聽器為
[oracle@Rm-DevDB admin]$ lsnrctl status


LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 16-MAY-2010 16:36:20

Copyright (c) 1991, 2005, Oracle.? All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Rm-DevDB)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias???????????????????? LISTENER
Version?????????????????? TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date??????????????? 16-MAY-2010 14:54:58
Uptime??????????????????? 0 days 1 hr. 41 min. 22 sec
Trace Level?????????????? off
Security????????????????? ON: Local OS Authentication
SNMP????????????????????? OFF
Listener Parameter File?? /opt/app/oracle/product/10.2.0.1/db_1/network/admin/listener.ora
Listener Log File???????? /opt/app/oracle/product/10.2.0.1/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Rm-DevDB)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "rmsdata1" has 1 instance(s).
Instance "rmsdata1", status READY, has 1 handler(s) for this service...
Service "rmsdata1XDB" has 1 instance(s).
Instance "rmsdata1", status READY, has 1 handler(s) for this service...
Service "rmsdata1_XPT" has 1 instance(s).
Instance "rmsdata1", status READY, has 1 handler(s) for this service...
The command completed successfully
-------------------------------------------------------------------------
listener.ora 這個(gè)文件的配置

監(jiān)聽器的操作命令
$ORACLE_HOME/bin/lsnrctl start,其他諸如stop,status等。具體敲完一個(gè)lsnrctl后看幫助。
服務(wù)器端配置
[oracle@rs2600-2 admin]$ vi listener.ora

# listener.ora Network Configuration File: /opt/app/oracle/product/10.2.0/server/network/admin/listener.ora
# Generated by Oracle configuration tools.

LSNRASM =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rs2600-2)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = +ASM)
(ORACLE_HOME = /opt/app/oracle/product/10.2.0/server)
(SID_NAME = +ASM)
)
(SID_DESC =
(GLOBAL_DBNAME = danghj)
(ORACLE_HOME = /opt/app/oracle/product/10.2.0/server)
(SID_NAME = danghj)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rs2600-2)(PORT = 1521))
)
)

客戶端的配置
ASM_172.22.11.124 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.11.124)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = danghj)
)
)

3，tnsnames.ora和tnsnames.ora的作用
當(dāng)你輸入sqlplus sys/oracle@orcl的時(shí)候
1． 查詢sqlnet.ora看看名稱的解析方式，發(fā)現(xiàn)是TNSNAME
2． 則查詢tnsnames.ora文件，從里邊找orcl的記錄，并且找到主機(jī)名，端口和service_name
3． 如果listener進(jìn)程沒(méi)有問(wèn)題的話，建立與listener進(jìn)程的連接。
4． 根據(jù)不同的服務(wù)器模式如專用服務(wù)器模式或者共享服務(wù)器模式，listener采取接下去的動(dòng)作。默認(rèn)是專用服務(wù)器模式，沒(méi)有問(wèn)題的話客戶端就連接上了數(shù)據(jù) 庫(kù)的server process。
5． 這時(shí)候網(wǎng)絡(luò)連接已經(jīng)建立，listener進(jìn)程的歷史使命也就完成了。

啟動(dòng)ASM 數(shù)據(jù)庫(kù)的步驟