免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › 操作系统 › Solaris › cluster资源oracle-server无法启动请教
12
最近访问板块 发新帖
楼主: overmas_11
打印 上一主题 下一主题

cluster资源oracle-server无法启动请教 [复制链接]

overmas_11

论坛徽章:
0
11楼
发表于 2013-04-12 19:01
本帖最后由 overmas_11 于 2013-04-12 19:03 编辑

回复 9# hjp1973

message_log.oracle-server

3月 27 11:48:07 SC[SUNWscor.oracle_server.stop]:oracle-rg:oracle-server: Server stopped successfully.
4月 12 00:14:08 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Starting Oracle server.
4月 12 00:14:08 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Using method 'run_setuid_prog' to execute start commands
Shutting down Oracle instance: ora10  : /export/home/oracle/product/10.

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 12 00:14:08 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> Disconnected
Executing command: /opt/SUNWscor/oracle_server/bin/oracle_server_manage shutdown abort

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 12 00:14:09 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size                    2144328 bytes
Variable Size                 2664384440 bytes
Database Buffers         1593835520 bytes
Redo Buffers                   34603008 bytes
????????
????????
SQL> ? Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options ??

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 12 00:14:35 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


???:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
?????

SQL>
?????

SQL>
?????

SQL>
?????

SQL> ? Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options ??
Executing command: /opt/SUNWscor/oracle_server/bin/oracle_server_manage startup FALSE
4月 12 00:14:35 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Server successfully started.
4月 12 00:14:36 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Checking the instance's status and role.
Checking status of instance ora10
DB_ROLE:PRIMARY
Role returned by instance is: PRIMARY
DB_STATUS:OPEN
Status returned by instance is: OPEN
Instance found to be in correct status of OPEN.
Executing command: /opt/SUNWscor/oracle_server/bin/oracle_server_manage check_db_open
Apr 12 00:14:37 monitor started for database online check
Apr 12 00:14:37 Starting monitor child process
Apr 12 00:14:37 Probe result: error type 1 Error number: 28000
Apr 12 00:14:42 Starting monitor child process
Apr 12 00:14:43 Probe result: error type 1 Error number: 28000
Apr 12 00:14:47 Starting monitor child process
Apr 12 00:14:47 Probe result: error type 1 Error number: 28000
Apr 12 00:14:52 Starting monitor child process
Apr 12 00:14:52 Probe result: error type 1 Error number: 28000
Apr 12 00:14:57 Starting monitor child process
Apr 12 00:14:57 Probe result: error type 1 Error number: 28000
Apr 12 00:15:02 Starting monitor child process
Apr 12 00:15:02 Probe result: error type 1 Error number: 28000
Apr 12 00:15:07 Starting monitor child process
Apr 12 00:15:08 Probe result: error type 1 Error number: 28000
Apr 12 00:15:12 Starting monitor child process
Apr 12 00:15:12 Probe result: error type 1 Error number: 28000
Apr 12 00:15:17 Starting monitor child process
Apr 12 00:15:17 Probe result: error type 1 Error number: 28000
Apr 12 00:15:22 Starting monitor child process
Apr 12 00:15:22 Probe result: error type 1 Error number: 28000
Apr 12 00:15:27 Starting monitor child process
Apr 12 00:15:28 Probe result: error type 1 Error number: 28000
Apr 12 00:15:32 Starting monitor child process
Apr 12 00:15:32 Probe result: error type 1 Error number: 28000
Apr 12 00:15:37 Starting monitor child process
Apr 12 00:15:37 Probe result: error type 1 Error number: 28000
Apr 12 00:15:42 Starting monitor child process
Apr 12 00:15:42 Probe result: error type 1 Error number: 28000
Apr 12 00:15:47 Starting monitor child process
Apr 12 00:15:48 Probe result: error type 1 Error number: 28000
Apr 12 00:15:52 Starting monitor child process
Apr 12 00:15:52 Probe result: error type 1 Error number: 28000
Apr 12 00:15:57 Starting monitor child process
Apr 12 00:15:57 Probe result: error type 1 Error number: 28000
Apr 12 00:16:02 Starting monitor child process
Apr 12 00:16:02 Probe result: error type 1 Error number: 28000
Apr 12 00:16:07 Starting monitor child process
Apr 12 00:16:08 Probe result: error type 1 Error number: 28000
Apr 12 00:16:12 Starting monitor child process
Apr 12 00:16:12 Probe result: error type 1 Error number: 28000
Apr 12 00:16:17 Starting monitor child process
Apr 12 00:16:17 Probe result: error type 1 Error number: 28000
Apr 12 00:16:22 Starting monitor child process
Apr 12 00:16:22 Probe result: error type 1 Error number: 28000
Apr 12 00:16:27 Starting monitor child process
Apr 12 00:16:27 Probe result: error type 1 Error number: 28000
Apr 12 00:16:32 Starting monitor child process
Apr 12 00:16:33 Probe result: error type 1 Error number: 28000
Apr 12 00:16:37 Starting monitor child process
Apr 12 00:16:37 Probe result: error type 1 Error number: 28000
Apr 12 00:16:42 Starting monitor child process
Apr 12 00:16:42 Probe result: error type 1 Error number: 28000
Apr 12 00:16:47 Starting monitor child process
Apr 12 00:16:47 Probe result: error type 1 Error number: 28000
Apr 12 00:16:52 Starting monitor child process
Apr 12 00:16:53 Probe result: error type 1 Error number: 28000
Apr 12 00:16:57 Starting monitor child process
Apr 12 00:16:57 Probe result: error type 1 Error number: 28000
Apr 12 00:17:02 Starting monitor child process
Apr 12 00:17:02 Probe result: error type 1 Error number: 28000
Apr 12 00:17:07 Starting monitor child process
Apr 12 00:17:07 Probe result: error type 1 Error number: 28000
Apr 12 00:17:12 Starting monitor child process
Apr 12 00:17:13 Probe result: error type 1 Error number: 28000
Apr 12 00:17:17 Starting monitor child process
Apr 12 00:17:17 Probe result: error type 1 Error number: 28000
Apr 12 00:17:22 Starting monitor child process
Apr 12 00:17:22 Probe result: error type 1 Error number: 28000
Apr 12 00:17:27 Starting monitor child process
Apr 12 00:17:27 Probe result: error type 1 Error number: 28000
Apr 12 00:17:32 Starting monitor child process
Apr 12 00:17:33 Probe result: error type 1 Error number: 28000
Apr 12 00:17:37 Starting monitor child process
Apr 12 00:17:37 Probe result: error type 1 Error number: 28000
Apr 12 00:17:42 Starting monitor child process
Apr 12 00:17:42 Probe result: error type 1 Error number: 28000
Apr 12 00:17:47 Starting monitor child process
Apr 12 00:17:47 Probe result: error type 1 Error number: 28000
Apr 12 00:17:52 Starting monitor child process
Apr 12 00:17:52 Probe result: error type 1 Error number: 28000
Apr 12 00:17:57 Starting monitor child process
Apr 12 00:17:58 Probe result: error type 1 Error number: 28000
Apr 12 00:18:02 Starting monitor child process
Apr 12 00:18:02 Probe result: error type 1 Error number: 28000
Apr 12 00:18:07 Starting monitor child process
Apr 12 00:18:07 Probe result: error type 1 Error number: 28000
Apr 12 00:18:12 Starting monitor child process
Apr 12 00:18:12 Probe result: error type 1 Error number: 28000
Apr 12 00:18:17 Starting monitor child process
Apr 12 00:18:18 Probe result: error type 1 Error number: 28000
Apr 12 00:18:22 Starting monitor child process
Apr 12 00:18:22 Probe result: error type 1 Error number: 28000
Apr 12 00:18:27 Starting monitor child process
Apr 12 00:18:27 Probe result: error type 1 Error number: 28000
Apr 12 00:18:32 Starting monitor child process
Apr 12 00:18:32 Probe result: error type 1 Error number: 28000
Apr 12 00:18:37 Starting monitor child process
Apr 12 00:18:38 Probe result: error type 1 Error number: 28000
Apr 12 00:18:42 Starting monitor child process
Apr 12 00:18:42 Probe result: error type 1 Error number: 28000
Apr 12 00:18:47 Starting monitor child process
Apr 12 00:18:47 Probe result: error type 1 Error number: 28000
Apr 12 00:18:52 Starting monitor child process
Apr 12 00:18:52 Probe result: error type 1 Error number: 28000
Apr 12 00:18:57 Starting monitor child process
Apr 12 00:18:57 Probe result: error type 1 Error number: 28000
Apr 12 00:19:03 Starting monitor child process
Apr 12 00:19:03 Probe result: error type 1 Error number: 28000
Apr 12 00:19:08 Starting monitor child process
Apr 12 00:19:08 Probe result: error type 1 Error number: 28000
Apr 12 00:19:13 Starting monitor child process
Apr 12 00:19:13 Probe result: error type 1 Error number: 28000
Apr 12 00:19:18 Starting monitor child process
Apr 12 00:19:18 Probe result: error type 1 Error number: 28000
Apr 12 00:19:23 Starting monitor child process
Apr 12 00:19:24 Probe result: error type 1 Error number: 28000
Apr 12 00:19:28 Starting monitor child process
Apr 12 00:19:28 Probe result: error type 1 Error number: 28000
Apr 12 00:19:33 Starting monitor child process
Apr 12 00:19:33 Probe result: error type 1 Error number: 28000
Apr 12 00:19:38 Starting monitor child process
Apr 12 00:19:38 Probe result: error type 1 Error number: 28000
Apr 12 00:19:43 Starting monitor child process
Apr 12 00:19:44 Probe result: error type 1 Error number: 28000
Apr 12 00:19:48 Starting monitor child process
Apr 12 00:19:48 Probe result: error type 1 Error number: 28000
Apr 12 00:19:53 Starting monitor child process
Apr 12 00:23:53 Starting monitor child process
Apr 12 00:23:53 Probe result: error type 1 Error number: 28000
Apr 12 00:23:58 Starting monitor child process
Apr 12 00:23:58 Probe result: error type 1 Error number: 28000
Apr 12 00:24:03 Starting monitor child process
Apr 12 00:24:04 Probe result: error type 1 Error number: 28000
4月 12 00:24:10 SC[SUNWscor.oracle_server.stop]:oracle-rg:oracle-server: Using method 'run_setuid_prog' to execute shutdown commands
4月 12 00:24:10 SC[SUNWscor.oracle_server.stop]:oracle-rg:oracle-server: Stopping oracle server using shutdown immediate
Shutting down Oracle instance: ora10  : /export/home/oracle/product/10.

   
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
overmas_11

论坛徽章:
0
12楼 [报告]
发表于 2013-04-12 19:02 |只看该作者
本帖最后由 overmas_11 于 2013-04-12 19:03 编辑

回复 11# overmas_11

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 12 00:24:11 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


???:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> ????????
????????
ORACLE ???????
SQL> ? Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options ??
Executing command: /opt/SUNWscor/oracle_server/bin/oracle_server_manage shutdown immediate
4月 12 00:24:26 SC[SUNWscor.oracle_server.stop]:oracle-rg:oracle-server: Server stopped successfully.
4月 12 00:24:34 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Starting Oracle server.
4月 12 00:24:34 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Using method 'run_setuid_prog' to execute start commands
Shutting down Oracle instance: ora10  : /export/home/oracle/product/10.

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 12 00:24:35 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> Disconnected
Executing command: /opt/SUNWscor/oracle_server/bin/oracle_server_manage shutdown abort

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 12 00:24:35 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size                    2144328 bytes
Variable Size                 2664384440 bytes
Database Buffers         1593835520 bytes
Redo Buffers                   34603008 bytes
????????
????????
SQL> ? Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options ??

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 12 00:24:57 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


???:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
?????

SQL>
?????

SQL>
?????

SQL>
?????

SQL> ? Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options ??
Executing command: /opt/SUNWscor/oracle_server/bin/oracle_server_manage startup FALSE
4月 12 00:24:58 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Server successfully started.
4月 12 00:24:58 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Checking the instance's status and role.
Checking status of instance ora10
DB_ROLE:PRIMARY
Role returned by instance is: PRIMARY
DB_STATUS:OPEN
Status returned by instance is: OPEN
Instance found to be in correct status of OPEN.
Executing command: /opt/SUNWscor/oracle_server/bin/oracle_server_manage check_db_open
Apr 12 00:24:59 monitor started for database online check
Apr 12 00:24:59 Starting monitor child process
Apr 12 00:24:59 Probe result: error type 1 Error number: 28000
Apr 12 00:25:04 Starting monitor child process
Apr 12 00:25:05 Probe result: error type 1 Error number: 28000
Apr 12 00:25:09 Starting monitor child process
Apr 12 00:25:09 Probe result: error type 1 Error number: 28000
Apr 12 00:25:14 Starting monitor child process
Apr 12 00:25:14 Probe result: error type 1 Error number: 28000
Apr 12 00:25:19 Starting monitor child process
Apr 12 00:25:19 Probe result: error type 1 Error number: 28000
Apr 12 00:25:24 Starting monitor child process
Apr 12 00:25:25 Probe result: error type 1 Error number: 28000
Apr 12 00:25:29 Starting monitor child process
Apr 12 00:25:29 Probe result: error type 1 Error number: 28000
Apr 12 00:25:34 Starting monitor child process
Apr 12 00:25:34 Probe result: error type 1 Error number: 28000
Apr 12 00:25:39 Starting monitor child process
Apr 12 00:25:39 Probe result: error type 1 Error number: 28000
Apr 12 00:25:44 Starting monitor child process
Apr 12 00:25:44 Probe result: error type 1 Error number: 28000
Apr 12 00:25:49 Starting monitor child process
Apr 12 00:25:50 Probe result: error type 1 Error number: 28000
Apr 12 00:25:54 Starting monitor child process
Apr 12 00:25:54 Probe result: error type 1 Error number: 28000
Apr 12 00:25:59 Starting monitor child process
Apr 12 00:25:59 Probe result: error type 1 Error number: 28000
Apr 12 00:26:04 Starting monitor child process
Apr 12 00:26:04 Probe result: error type 1 Error number: 28000
Apr 12 00:26:09 Starting monitor child process
Apr 12 00:26:10 Probe result: error type 1 Error number: 28000
Apr 12 00:26:14 Starting monitor child process
Apr 12 00:26:14 Probe result: error type 1 Error number: 28000
Apr 12 00:26:19 Starting monitor child process
Apr 12 00:26:19 Probe result: error type 1 Error number: 28000
Apr 12 00:26:24 Starting monitor child process
Apr 12 00:26:24 Probe result: error type 1 Error number: 28000
Apr 12 00:26:29 Starting monitor child process
Apr 12 00:26:30 Probe result: error type 1 Error number: 28000
Apr 12 00:26:34 Starting monitor child process
Apr 12 00:26:34 Probe result: error type 1 Error number: 28000
Apr 12 00:26:39 Starting monitor child process
Apr 12 00:26:39 Probe result: error type 1 Error number: 28000
Apr 12 00:26:44 Starting monitor child process
Apr 12 00:26:44 Probe result: error type 1 Error number: 28000
Apr 12 00:26:49 Starting monitor child process
Apr 12 00:26:49 Probe result: error type 1 Error number: 28000
Apr 12 00:26:54 Starting monitor child process
Apr 12 00:26:55 Probe result: error type 1 Error number: 1034
Apr 12 00:26:55 SC[SUNWscor.oracle_server.online_check]:oracle-rg:oracle-server: Online check Error DBMS_ERROR: 1034: Oracle is not available
4月 12 00:26:55 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Cannot bring server online on this node.
4月 12 00:26:59 SC[SUNWscor.oracle_server.stop]:oracle-rg:oracle-server: Using method 'run_setuid_prog' to execute shutdown commands
4月 12 00:26:59 SC[SUNWscor.oracle_server.stop]:oracle-rg:oracle-server: Server is not running. Calling shutdown abort to clear shared memory (if any)
Shutting down Oracle instance: ora10  : /export/home/oracle/product/10.

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 12 00:26:59 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> Disconnected
Executing command: /opt/SUNWscor/oracle_server/bin/oracle_server_manage shutdown abort
4月 12 00:32:30 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Starting Oracle server.
4月 12 00:32:30 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Using method 'run_setuid_prog' to execute start commands
Shutting down Oracle instance: ora10  : /export/home/oracle/product/10.

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 12 00:32:31 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> Disconnected

   
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
overmas_11

论坛徽章:
0
13楼 [报告]
发表于 2013-04-12 19:02 |只看该作者
本帖最后由 overmas_11 于 2013-04-12 19:04 编辑

回复 12# overmas_11


   Executing command: /opt/SUNWscor/oracle_server/bin/oracle_server_manage shutdown abort

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 12 00:32:31 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size                    2144328 bytes
Variable Size                 2664384440 bytes
Database Buffers         1593835520 bytes
Redo Buffers                   34603008 bytes
????????
????????
SQL> ? Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options ??

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 12 00:32:57 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


???:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
?????

SQL>
?????

SQL>
?????

SQL>
?????

SQL> ? Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options ??
Executing command: /opt/SUNWscor/oracle_server/bin/oracle_server_manage startup FALSE
4月 12 00:32:58 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Server successfully started.
4月 12 00:32:58 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Checking the instance's status and role.
Checking status of instance ora10
DB_ROLE:PRIMARY
Role returned by instance is: PRIMARY
DB_STATUS:OPEN
Status returned by instance is: OPEN
Instance found to be in correct status of OPEN.
Executing command: /opt/SUNWscor/oracle_server/bin/oracle_server_manage check_db_open
Apr 12 00:32:59 monitor started for database online check
Apr 12 00:32:59 Starting monitor child process
Apr 12 00:32:59 Probe result: error type 1 Error number: 28000
Apr 12 00:33:04 Starting monitor child process
Apr 12 00:33:04 Probe result: error type 1 Error number: 28000
Apr 12 00:33:09 Starting monitor child process
Apr 12 00:33:09 Probe result: error type 1 Error number: 28000
Apr 12 00:33:14 Starting monitor child process
Apr 12 00:33:15 Probe result: error type 1 Error number: 28000
Apr 12 00:33:19 Starting monitor child process
Apr 12 00:33:19 Probe result: error type 1 Error number: 28000
Apr 12 00:33:24 Starting monitor child process
Apr 12 00:33:24 Probe result: error type 1 Error number: 28000
Apr 12 00:33:29 Starting monitor child process
Apr 12 00:33:29 Probe result: error type 1 Error number: 28000
Apr 12 00:33:34 Starting monitor child process
Apr 12 00:33:34 Probe result: error type 1 Error number: 28000
Apr 12 00:33:39 Starting monitor child process
Apr 12 00:33:40 Probe result: error type 1 Error number: 28000
Apr 12 00:33:44 Starting monitor child process
Apr 12 00:33:44 Probe result: error type 1 Error number: 28000
Apr 12 00:33:49 Starting monitor child process
Apr 12 00:33:49 Probe result: error type 1 Error number: 28000
Apr 12 00:33:54 Starting monitor child process
Apr 12 00:33:54 Probe result: error type 1 Error number: 28000
Apr 12 00:33:59 Starting monitor child process
Apr 12 00:34:00 Probe result: error type 1 Error number: 28000
Apr 12 00:34:04 Starting monitor child process
Apr 12 00:34:04 Probe result: error type 1 Error number: 28000
Apr 12 00:34:09 Starting monitor child process
Apr 12 00:34:09 Probe result: error type 1 Error number: 28000
Apr 12 00:34:14 Starting monitor child process
Apr 12 00:34:14 Probe result: error type 1 Error number: 28000
Apr 12 00:34:19 Starting monitor child process
Apr 12 00:34:20 Probe result: error type 1 Error number: 28000
Apr 12 00:34:24 Starting monitor child process
Apr 12 00:34:24 Probe result: error type 1 Error number: 28000
Apr 12 00:34:29 Starting monitor child process
Apr 12 00:34:29 Probe result: error type 1 Error number: 28000
Apr 12 00:34:34 Starting monitor child process
Apr 12 00:34:34 Probe result: error type 1 Error number: 28000
Apr 12 00:34:39 Starting monitor child process
Apr 12 00:34:40 Probe result: error type 1 Error number: 28000
Apr 12 00:34:44 Starting monitor child process
Apr 12 00:34:44 Probe result: error type 1 Error number: 28000
Apr 12 00:34:49 Starting monitor child process
Apr 12 00:34:49 Probe result: error type 1 Error number: 28000
Apr 12 00:34:54 Starting monitor child process
Apr 12 00:34:54 Probe result: error type 1 Error number: 28000
Apr 12 00:34:59 Starting monitor child process
Apr 12 00:35:00 Probe result: error type 1 Error number: 28000
Apr 12 00:35:04 Starting monitor child process
Apr 12 00:35:04 Probe result: error type 1 Error number: 28000
Apr 12 00:35:09 Starting monitor child process
Apr 12 00:35:09 Probe result: error type 1 Error number: 28000
Apr 12 00:35:14 Starting monitor child process
Apr 12 00:35:14 Probe result: error type 1 Error number: 28000
Apr 12 00:35:19 Starting monitor child process
Apr 12 00:35:20 Probe result: error type 1 Error number: 28000
Apr 12 00:35:24 Starting monitor child process
Apr 12 00:35:24 Probe result: error type 1 Error number: 28000
Apr 12 00:35:29 Starting monitor child process
Apr 12 00:35:29 Probe result: error type 1 Error number: 28000
Apr 12 00:35:34 Starting monitor child process
Apr 12 00:35:34 Probe result: error type 1 Error number: 28000
Apr 12 00:35:39 Starting monitor child process
Apr 12 00:35:39 Probe result: error type 1 Error number: 28000
Apr 12 00:35:44 Starting monitor child process
Apr 12 00:35:45 Probe result: error type 1 Error number: 28000
Apr 12 00:35:49 Starting monitor child process
Apr 12 00:35:49 Probe result: error type 1 Error number: 28000
Apr 12 00:35:54 Starting monitor child process
Apr 12 00:35:54 Probe result: error type 1 Error number: 28000
Apr 12 00:35:59 Starting monitor child process
Apr 12 00:35:59 Probe result: error type 1 Error number: 28000
Apr 12 00:36:04 Starting monitor child process
Apr 12 00:36:05 Probe result: error type 1 Error number: 28000
Apr 12 00:36:09 Starting monitor child process
Apr 12 00:36:09 Probe result: error type 1 Error number: 28000
Apr 12 00:36:14 Starting monitor child process
Apr 12 00:36:14 Probe result: error type 1 Error number: 28000
Apr 12 00:36:19 Starting monitor child process
Apr 12 00:36:19 Probe result: error type 1 Error number: 28000
Apr 12 00:36:24 Starting monitor child process
Apr 12 00:36:25 Probe result: error type 1 Error number: 28000
Apr 12 00:36:29 Starting monitor child process
Apr 12 00:36:29 Probe result: error type 1 Error number: 28000
Apr 12 00:36:34 Starting monitor child process
Apr 12 00:36:34 Probe result: error type 1 Error number: 28000
Apr 12 00:36:39 Starting monitor child process
Apr 12 00:36:39 Probe result: error type 1 Error number: 28000
Apr 12 00:36:44 Starting monitor child process
Apr 12 00:36:45 Probe result: error type 1 Error number: 28000
Apr 12 00:36:49 Starting monitor child process
Apr 12 00:36:49 Probe result: error type 1 Error number: 28000
Apr 12 00:36:54 Starting monitor child process
Apr 12 00:36:54 Probe result: error type 1 Error number: 28000
Apr 12 00:36:59 Starting monitor child process
Apr 12 00:36:59 Probe result: error type 1 Error number: 28000
Apr 12 00:37:04 Starting monitor child process
Apr 12 00:37:04 Probe result: error type 1 Error number: 28000
Apr 12 00:37:09 Starting monitor child process
Apr 12 00:37:10 Probe result: error type 1 Error number: 28000
Apr 12 00:37:14 Starting monitor child process
Apr 12 00:37:14 Probe result: error type 1 Error number: 28000
Apr 12 00:37:19 Starting monitor child process
Apr 12 00:37:19 Probe result: error type 1 Error number: 28000
Apr 12 00:37:24 Starting monitor child process
Apr 12 00:37:24 Probe result: error type 1 Error number: 28000
Apr 12 00:37:29 Starting monitor child process
Apr 12 00:37:30 Probe result: error type 1 Error number: 28000
Apr 12 00:37:34 Starting monitor child process
Apr 12 00:37:34 Probe result: error type 1 Error number: 28000
Apr 12 00:37:39 Starting monitor child process
Apr 12 00:37:39 Probe result: error type 1 Error number: 28000
Apr 12 00:37:44 Starting monitor child process
Apr 12 00:37:44 Probe result: error type 1 Error number: 28000
Apr 12 00:37:49 Starting monitor child process
Apr 12 00:37:50 Probe result: error type 1 Error number: 1034
Apr 12 00:37:50 SC[SUNWscor.oracle_server.online_check]:oracle-rg:oracle-server: Online check Error DBMS_ERROR: 1034: Oracle is not available
4月 12 00:37:50 SC[SUNWscor.oracle_server.start]:oracle-rg:oracle-server: Cannot bring server online on this node.
4月 12 00:37:54 SC[SUNWscor.oracle_server.stop]:oracle-rg:oracle-server: Using method 'run_setuid_prog' to execute shutdown commands
4月 12 00:37:54 SC[SUNWscor.oracle_server.stop]:oracle-rg:oracle-server: Server is not running. Calling shutdown abort to clear shared memory (if any)
Shutting down Oracle instance: ora10  : /export/home/oracle/product/10.

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 12 00:37:54 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> Disconnected
Executing command: /opt/SUNWscor/oracle_server/bin/oracle_server_manage shutdown abort
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
hjp1973

论坛徽章:
0
14楼 [报告]
发表于 2013-04-13 12:33 |只看该作者
1、手工将两个节点上oracle的server和listener进程停掉
2、在cluster下清资源oracle_server和oracle_listener的状态
3、在cluster下重启资源组oracle-rg
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
byuq

论坛徽章:
1
狮子座 日期:2013-09-02 12:10:41
15楼 [报告]
发表于 2013-04-16 18:48 |只看该作者
本帖最后由 byuq 于 2013-04-16 18:50 编辑

手工启动数据库后,使用sqlplus命令用户名ora_monitor/ORA_MONITOR登陆oracle，然后检查oracle状态，看看是不是能正常查询到oracle的运行状态。
根据报错信息看，是cluster启动oracle数据库以后，使用ora_monitor/ORA_MONITOR登录oracle去检查oracle运行状态的时候返回值不对，导致cluster认为oracle没有启动，所以进行下一步的自动切换。


也可以自己查看一下oracle_server.online_check的脚本，查看cluster是怎么去检查oracle的状态的，然后根据脚本手工去检查，看看是否可以正确得到信息。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
overmas_11

论坛徽章:
0
16楼 [报告]
发表于 2013-04-17 11:45 |只看该作者
回复 15# byuq

谢谢你提供的方法,当时通过日志28000然后去检查了oracle 用户的一些权限,看到ORA_MONITOR                    LOCKED,估计是
这用户被锁导致检测不到数据库的运行是否正常,而进行资源的切换,我找机会看能否去操作再说,谢谢你的提醒.
SQL> select username,account_status from dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
MDDATA                         EXPIRED & LOCKED
TSMSYS                         EXPIRED & LOCKED
DIP                            EXPIRED & LOCKED
ORACLE_OCM                     EXPIRED & LOCKED
SCOTT                          EXPIRED & LOCKED
DBSNMP                         OPEN
SYSMAN                         LOCKED
WMSYS                          EXPIRED & LOCKED
ORDSYS                         EXPIRED & LOCKED
EXFSYS                         EXPIRED & LOCKED
XDB                            EXPIRED & LOCKED

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
DMSYS                          EXPIRED & LOCKED
OLAPSYS                        EXPIRED & LOCKED
SI_INFORMTN_SCHEMA             EXPIRED & LOCKED
ORDPLUGINS                     EXPIRED & LOCKED
MDSYS                          EXPIRED & LOCKED
CTXSYS                         EXPIRED & LOCKED
ANONYMOUS                      EXPIRED & LOCKED
SYS                            OPEN
SYSTEM                         OPEN
ORA_MONITOR                    LOCKED

   
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
DC_楚楚

论坛徽章:
1
2015年辞旧岁徽章 日期:2015-03-03 16:54:15
17楼 [报告]
发表于 2013-10-13 00:28 |只看该作者
回复 16# overmas_11


    LZ，你最后怎么解决的？我好像也遇到 了相同的问题。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
fly3ds

论坛徽章:
1
综合交流区版块每日发帖之星 日期:2015-10-14 06:20:00
18楼 [报告]
发表于 2013-10-13 11:57 |只看该作者
OMG，吓死个人咯！  
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
byuq

论坛徽章:
1
狮子座 日期:2013-09-02 12:10:41
19楼 [报告]
发表于 2013-10-15 13:52 |只看该作者
http://wenku.baidu.com/view/70865e8ea0116c175f0e4865.html
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
12
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP