亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標(biāo)題: 【已解決】Failed to connect to database instance: ORA-12528 [打印本頁]
作者: fertiland    時間: 2007-05-17 10:41
標(biāo)題: 【已解決】Failed to connect to database instance: ORA-12528



listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = MYDATA)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME = MYDATA)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = zhang.sirius.com)(PORT = 1521))
    )
  )

-----------------------------------------------------------------------------
sqlnet.ora

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

-----------------------------------------------------------------------------
tnsnames.ora

MYDATA =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = zhang.sirius.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MyData)
      (UR=A)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

[ 本帖最后由 fertiland 于 2007-7-12 21:21 編輯 ]

ora-12528.JPG (37.75 KB, 下載次數(shù): 1338)

ora-12528

ora-12528
作者: rollingpig    時間: 2007-05-17 10:53
用命令行看看吧……

感覺上 instance可能是在mount 或者 nomount狀態(tài)
作者: fertiland    時間: 2007-05-17 11:03
首先謝謝rollingpig的回復(fù)

剛接觸oracle，以下是我知道的查看方法，還請詳細(xì)指教。

  2. [oracle@zhanglinux admin]$ tnsping Mydata

  4. TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 17-MAY-2007 11:01:28

  6. Copyright (c) 1997, 2005, Oracle.  All rights reserved.

  8. Used parameter files:
  9. /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


  12. Used TNSNAMES adapter to resolve the alias
  13. Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = zhang.sirius.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MyData) (UR=A)))
  14. OK (10 msec)
復(fù)制代碼

  1. [oracle@zhanglinux admin]$ lsnrctl status
  2. LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-MAY-2007 10:58:40

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

  6. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
  7. STATUS of the LISTENER
  8. ------------------------
  9. Alias                     LISTENER
  10. Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
  11. Start Date                17-MAY-2007 10:29:09
  12. Uptime                    0 days 0 hr. 29 min. 31 sec
  13. Trace Level               off
  14. Security                  ON: Local OS Authentication
  15. SNMP                      OFF
  16. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
  17. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
  18. Listening Endpoints Summary...
  19.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  20.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zhanglinux.org)(PORT=1521)))
  21. Services Summary...
  22. Service "MYDATA" has 2 instance(s).
  23.   Instance "MYDATA", status UNKNOWN, has 1 handler(s) for this service...
  24.   Instance "MyData", status READY, has 1 handler(s) for this service...
  25. Service "MyDataXDB" has 1 instance(s).
  26.   Instance "MyData", status READY, has 1 handler(s) for this service...
  27. Service "MyData_XPT" has 1 instance(s).
  28.   Instance "MyData", status READY, has 1 handler(s) for this service...
  29. Service "PLSExtProc" has 1 instance(s).
  30.   Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
  31. The command completed successfully

復(fù)制代碼


listener.log

WARNING: Subscription for node down event still pending

sqlnet.log
沒有報錯

[ 本帖最后由 fertiland 于 2007-5-17 11:09 編輯 ]
作者: numenhuang    時間: 2007-05-17 11:23
sqlplus '/ as sysdba'
select instance_name,status,shutdown_pending,database_status from v$Instance
作者: fertiland    時間: 2007-05-17 11:26
INSTANCE_NAME    STATUS       SHU DATABASE_STATUS
---------------- ------------ --- -----------------
MyData           OPEN         NO  ACTIVE

用lsnrctl status也可以看出來啊
作者: numenhuang    時間: 2007-05-17 13:16
把em重啟一下
作者: fertiland    時間: 2007-05-17 14:20
已經(jīng)重啟過多回了。癥狀變了，如圖

[ 本帖最后由 fertiland 于 2007-5-17 14:27 編輯 ]

ORA-01034.JPG (33.82 KB, 下載次數(shù): 57)

ORA-01034

ORA-01034
作者: fertiland    時間: 2007-07-12 21:20
# Set this to bring up Oracle Net Listener
#ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle
ORACLE_HOME_LISTNER=$ORACLE_HOME
-------------------------------------------------------
原來是系統(tǒng)這里沒有修改。修改之后，就可以正常工作了。
由于我用的是域名解析，那么主機名也要與域名一致
主機名修改 /etc/sysconfig/network 文件 把里面的HOSTNAME＝newhostname

我是通過域名訪問的，而http://hostname:1158/em則似乎是通過主機名獲取的。
修改上述兩個方面，問題解決了。至于第2個是否相關(guān)，我沒有測試。



歡迎光臨 Chinaunix (http://72891.cn/) Powered by Discuz! X3.2