Oracle Grid 503 Service Unavailable

Oracle 10g grid control 登入時報如下錯誤,從錯誤解釋可以看出這是資料庫連線問題。

Service Unavailable

Servlet error: Service is not initialized correctly. Verify that the repository connection information provided is correct.

一般安裝Grid Control的計算機重啟後資料庫沒有自動啟動原因會導致以上錯誤。處理辦法很簡單那，即啟動監聽和repository資料庫。

[@more@]

[oracle@ocm2 OracleHome]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 8 17:21:58 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 448790528 bytes

Fixed Size 1219904 bytes

Variable Size 276824768 bytes

Database Buffers 163577856 bytes

Redo Buffers 7168000 bytes

Database mounted.

Database opened.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

[oracle@ocm2 OracleHome]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-DEC-2012 17:29:08

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

Starting /u01/app/oracle/OracleHome/db10g/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

System parameter file is /u01/app/oracle/OracleHome/db10g/network/admin/listener.ora

Log messages written to /u01/app/oracle/OracleHome/db10g/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm2)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 08-DEC-2012 17:29:08

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/OracleHome/db10g/network/admin/listener.ora

Listener Log File /u01/app/oracle/OracleHome/db10g/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm2)(PORT=1521)))

The listener supports no services

The command completed successfully

[oracle@ocm2 OracleHome]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 8 17:29:21 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> alter system register

2 ;

System altered.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

[oracle@ocm2 OracleHome]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-DEC-2012 17:29:55

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 08-DEC-2012 17:29:08

Uptime 0 days 0 hr. 0 min. 47 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/OracleHome/db10g/network/admin/listener.ora

Listener Log File /u01/app/oracle/OracleHome/db10g/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm2)(PORT=1521)))

Services Summary...

Service "emrep" has 1 instance(s).

Instance "emrep", status READY, has 1 handler(s) for this service...

Service "emrep_XPT" has 1 instance(s).

Instance "emrep", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@ocm2 OracleHome]$