今天装了oracle11g 结果 监听里面配置的是localhost,服务里面 主机名也是 localhost,这就造成其他机器无法访问。所以经过一番折腾,操作步骤如下
1.更改监听和服务主机名localhost为本机机器名称,如AlvinPC,测试后发现报如下错误
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务,解决办法如下
2.在监听文件 listener.ora 中加入如下 红色语句
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = orcl01)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = orcl01)
)
)
3.重启服务,重启之后测试发现 提示
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 1月 13 14:30:34 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
请输入用户名: sysdba
输入口令:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
进程 ID: 0
会话 ID: 0 序列号: 0
请输入用户名: sys as sysdba
输入口令:
已连接到空闲例程。
SQL> exit
已断开连接
C:\Documents and Settings\Administrator>set ORACLE_SID=ORCL01
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 1月 13 14:44:22 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn / as sysdba
已连接到空闲例程。
SQL> startuuup
SP2-0042: 未知命令 "startuuup" - 其余行忽略。
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL01'
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL01'
LISTENER_ORCL01 =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 327156176 bytes
Database Buffers 201326592 bytes
Redo Buffers 5804032 bytes
数据库装载完毕。
数据库已经打开。
SQL>