欧美三区_成人在线免费观看视频_欧美极品少妇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條評論
主站蜘蛛池模板: 色综合久久88中文字幕 | 午夜精品一区二区三区免费视频 | 久草老司机 | 成人免费视频观看视频 | 亚洲视频在线观看免费视频 | 欧美午夜视频 | 日本熟妇毛茸茸xxxxx | 免费午夜影片在线观看影院 | 欧美在线观看一区 | 黄网在线| 黄视频免费在线观看 | 日韩欧美精品在线 | 亚洲另类天天更新影院在线观看 | 日韩精品一区二区在线观看 | 国产aaaaa一级毛片 | 日韩三级一区 | 国产成人高清视频免费播放 | 亚色中文| 女人裸体让男人桶全过程 | 欧美一区二区三区在线视频 | 99爱在线观看 | 一区二区三区精品视频 | 无码观看AAAAAAAA片 | 91视频一区 | 久久亚洲国产成人亚 | 欧美性xxxx交| 在线成人免费 | 亚欧视频在线观看 | 九九热观看视频 | 亚洲国产精久久久久久久 | 久久蜜桃av一区二区天堂 | 久久一二区 | 亚洲综合精品香蕉久久网97 | 久久国产精品一区二区 | 激情五月色播 | 视频一区二区在线观看 | 天天插天天操 | 国产日韩一区在线精品欧美玲 | 国产成人免费 | 999精品免费视频观看 | 九九精品视频在线播放 |