使用命令行登陆数据库配置文件修改 解决ora12528

下面是问题解决: 
ORA-12528: TNS:listener: all appropriate instances are blocking new connections 
1:修改listener.ora的参数 
SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = C:\oracle\product\10.1.0\db_1) 
      (PROGRAM = extproc) 
    ) 
    (SID_DESC = 
      (GLOBAL_DBNAME = ammicly) 
      (ORACLE_HOME = c:\oracle\product\10.1.0\db_1) 
      (SID_NAME = ammicly) 
    ) 
  ) 
LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = TCP)(HOST = lypch )(PORT = 1521)) 
      ) 
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) 
      ) 
    ) 
  )

2:修改tnsnames.ora的参数

AMMICLY = 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = lypch )(PORT = 1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = ammicly) 
     (UR=A) 
    ) 
  ) 
EXTPROC_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) 
    ) 
    (CONNECT_DATA = 
      (SID = PLSExtProc) 
      (PRESENTATION = RO) 
    ) 
  ) 
3 启动数据库 
SQL> conn /as sysdba 
SQL> alter database mount; 
SQL> alter database open;

4 关闭数据库 
SQL> shutdown immediate;

上一篇:Eclipse搭建Android开发环境(安装ADT,Android4.4.2)


下一篇:windows server core 设置shell 及切换