首页
登录 | 注册

多Oracle实例服务器管理

今天:同事报无法连接Oracle,出错信息为:
ORA-00257 archiver error. Connect internal only, until freed

Oracle文档上讲,是因归档日志写满了磁盘,登录到服务器上一看,确实满了,简单地删除归档,修改为非归档模式,OK!

改完后,重启服务器,又出现了情况:

情况如下:
SQL> conn sys/sys@gis3 as sysdba
ERROR:
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

登录到服务器查看:
SQL> select name from v$database;

NAME
---------
OEMREP

以前的配置是:

GIS3 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = gtis)
    )
  )

在一次归档日志满后,重起服务器后,就不能登录了,把SERVICE_NAME改成oemrep就行了,真是奇怪!

同事报:表没了,无法以以前的用户登录,赶紧查!

看到在服务列表中有两个Oracle实例服务:
OracleServiceOEMREP
OracleServiceGTIS
是个多实例服务器

C:\Documents and Settings\Administrator>set ORACLE_SID=GTIS

SQL> conn / as sysdba
已连接。

SQL> startup

C:\Documents and Settings\Administrator>set ORACLE_SID=OEMREP

C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on 星期一 5月 26 11:31:38 2008
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn / as sysdba
已连接。
SQL> archive log list;
数据库日志模式             非存档模式
自动存档             禁用
存档终点            D:\oracle\ora92\RDBMS
最早的概要日志序列     100
当前日志序列           102
SQL> desc v$database
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------

 DBID                                               NUMBER
 NAME                                               VARCHAR2(9)
 CREATED                                            DATE
 RESETLOGS_CHANGE#                                  NUMBER
 RESETLOGS_TIME                                     DATE
 PRIOR_RESETLOGS_CHANGE#                            NUMBER
 PRIOR_RESETLOGS_TIME                               DATE
 LOG_MODE                                           VARCHAR2(12)
 CHECKPOINT_CHANGE#                                 NUMBER
 ARCHIVE_CHANGE#                                    NUMBER
 CONTROLFILE_TYPE                                   VARCHAR2(7)
 CONTROLFILE_CREATED                                DATE
 CONTROLFILE_SEQUENCE#                              NUMBER
 CONTROLFILE_CHANGE#                                NUMBER
 CONTROLFILE_TIME                                   DATE
 OPEN_RESETLOGS                                     VARCHAR2(11)
 VERSION_TIME                                       DATE
 OPEN_MODE                                          VARCHAR2(10)
 PROTECTION_MODE                                    VARCHAR2(20)
 PROTECTION_LEVEL                                   VARCHAR2(20)
 REMOTE_ARCHIVE                                     VARCHAR2(8)
 ACTIVATION#                                        NUMBER
 DATABASE_ROLE                                      VARCHAR2(16)
 ARCHIVELOG_CHANGE#                                 NUMBER
 SWITCHOVER_STATUS                                  VARCHAR2(18)
 DATAGUARD_BROKER                                   VARCHAR2(8)
 GUARD_STATUS                                       VARCHAR2(7)
 SUPPLEMENTAL_LOG_DATA_MIN                          VARCHAR2(3)
 SUPPLEMENTAL_LOG_DATA_PK                           VARCHAR2(3)
 SUPPLEMENTAL_LOG_DATA_UI                           VARCHAR2(3)
 FORCE_LOGGING                                      VARCHAR2(3)

SQL> select name from v$database;

NAME
---------
OEMREP

SQL>

注:
当没有设置ORACLE_SID环境变量时,打开指定实例:
SQL> startup open GTIS

相关文章


2020 unjeep.com webmaster#unjeep.com
12 q. 0.012 s.
京ICP备10005923号