欧美三区_成人在线免费观看视频_欧美极品少妇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條評論
主站蜘蛛池模板: 国内精品久久毛片一区二区 | 色午夜在线 | 97超级碰碰碰视频在线视频观看 | 国产麻豆一区二区三区 | 99国产精品 | 青青草国产精品欧美成人 | 国产福利不卡一区二区三区 | 精久久 | 91精品久久久久久久久久入口 | 欧美操人视频 | 久久国产高清视频 | 亚洲色婷婷久久精品AV蜜桃久久 | 性色在线 | 亚洲天堂一区二区三区 | 欧美久久久网站 | 日本黄 色 成 年 人免费观看 | 人成免费a级毛片 | 久草热线视频 | 无码免费一区二区三区免费播放 | 午夜影院小视频 | 91久久老司机福利精品网 | 欧美成人一区二区三区 | 久操伊人 | 免费黄色日韩电影 | 9色在线| 国产一区二区三区免费观看 | 欧美激情一区二区三级高清视频 | 午夜影院福利社 | 成年男女男免费视频网站不卡 | 日本看片一区二区三区高清 | 添人人躁日日躁夜夜躁夜夜揉 | 午夜性电影 | 日韩免费福利视频 | 欧美亚洲日本 | 国产激爽大片高清在线观看 | 国产毛片视频 | 国产精品一区二区三区免费 | 日韩城人网站 | 亚洲免费一区 | 久久精品一区二区三区四区 | 噜噜噜噜精品视频在线观看 |