ITPub博客

首页 > 数据库 > Oracle > Oracle Grid 503 Service Unavailable

Oracle Grid 503 Service Unavailable

原创 Oracle 作者:kuqlan 时间:2012-12-08 12:51:55 0 删除 编辑

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]$

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/18841027/viewspace-1059877/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle技术爱好者,Oracle10g OCM,网名 KUQLAN ,具有7的年Oracle数据库管理实践,曾经参加过BOSS、ERP、云计算(OpenStack+kvm)等项目的一线工作。以前写博客是为了自己,而现在是为了自己和别人。因为领会了帮助别人和分享、沉淀和积累会创造快乐和价值...

注册时间:2009-01-26

  • 博文量
    183
  • 访问量
    1681004