亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

啟動ASM 數據庫的步驟

系統 1864 0
1,啟動ASM 數據庫的步驟
由于啟動ASM 數據庫必須要先啟動ASM 實例,所以基本上啟動步驟如下。
1. 以oracle 用戶進入操作系統
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.
需要重新啟動2遍
8.啟動監聽器:[oracle@Rm-DevDB ~]$ lsnrctl start

9,啟動em控制器:[oracle@Rm-DevDB ~]$ emctl start dbconsole


2,配置listener.ora

正常的監聽器為
[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 這個文件的配置

監聽器的操作命令
$ORACLE_HOME/bin/lsnrctl start,其他諸如stop,status等。具體敲完一個lsnrctl后看幫助。
服務器端配置
[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的作用
當你輸入sqlplus sys/oracle@orcl的時候
1. 查詢sqlnet.ora看看名稱的解析方式,發現是TNSNAME
2. 則查詢tnsnames.ora文件,從里邊找orcl的記錄,并且找到主機名,端口和service_name
3. 如果listener進程沒有問題的話,建立與listener進程的連接。
4. 根據不同的服務器模式如專用服務器模式或者共享服務器模式,listener采取接下去的動作。默認是專用服務器模式,沒有問題的話客戶端就連接上了數據 庫的server process。
5. 這時候網絡連接已經建立,listener進程的歷史使命也就完成了。

啟動ASM 數據庫的步驟


更多文章、技術交流、商務合作、聯系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯系: 360901061

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對您有幫助就好】

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會非常 感謝您的哦!!!

發表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 午夜影视在线 | 日本中文在线三级在线播放 | 欧美一区二区三区网站 | 久久久久久久久a免费 | 麻豆国产在线观看一区二区 | 国产精欧美一区二区三区 | 精品久久久久久久久中文字幕 | 国产亚洲午夜精品a一区二区 | 亚洲日韩成人 | 热e国产| 在线播放 亚洲 | 狠狠婷| 日本一级做人免费视频 | 国产精品欧美亚洲韩国日本 | 精品久久久久久久一区二区伦理 | 人人揉人人爽五月天视频 | 最新中文字幕一区二区乱码 | 男人av的天堂 | 在线看片a| 狠狠色丁香婷婷综合小时婷婷 | 99久国产| 久久精品国产亚洲aa | 久青草国产在线视频亚瑟影视 | 中文字幕一区二区三区在线观看 | 久久亚洲国产欧洲精品一 | 日本综合视频 | 国产一级特黄aa级特黄裸毛片 | 亚洲视频精品在线观看 | 久久se精品一区二区影院 | 亚洲精品影视 | 一级毛片看真人在线视频 | 97狠狠干| 久草5| 日日摸日日碰日日狠狠 | 亚洲视频免费在线播放 | 日本xxxwww在线观看免费 | www.色人阁.com| 久久久久久久99久久久毒国产 | 欧美日韩免费 | 国产91系列| 毛片在线高清免费观看 |