欧美三区_成人在线免费观看视频_欧美极品少妇xxxxⅹ免费视频_a级毛片免费播放_鲁一鲁中文字幕久久_亚洲一级特黄

啟動ASM 數據庫的步驟

系統 1929 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條評論
主站蜘蛛池模板: 亚洲欧美视频一区 | 久久成人一区二区 | 成人1234| 亚洲一区二区三区久久久 | 91青青青青青爽在线 | xvideos korean | 日本不良网站 | 在线观看国产 | 久久精品视在线看1 | 全免费午夜一级毛片一级毛 | 亚洲午夜精品aaa级久久久久 | 中文字幕一区二区视频 | 国产精品综合亚洲AV久久久小说 | 久草视频精品 | 九色九色久综色鬼在线 | 欧美在线观看视频一区 | 黄色免费观看 | 欧美影院 | 天堂在线v| 香蕉18xxoo欧美夜视频 | 91短视频免费在线观看 | www91 | 99影视在线视频免费观看 | 亚洲国产成a人v在线观看 | 亚洲精品中文字幕 | 黄色大片在线播放 | 91精品国产高清久久久久久91 | 精品一区二区三区在线观看l | 人人澡人人澡人人看添欧美 | 欧美激情精品久久久久 | 天堂资源 | 成年网站免费观看 | 国产无圣光高清一区二区 | 蜜桃视频一区 | 91精品久久久久久综合五月天 | 天天高清 | 成人黄色一级视频 | 美女一区| 欧美浮力影院 | 国产高清在线精品 | 亚洲欧美中文日韩在线v日本 |