Oracle,ORA-01034,ORA-27101,ORA-28000,ORA-00119,ORA-00130
一.ORA-01034: ORACLE not available,ORA-27101: shared memory realm does not exist
翻译是:ORA-01034:数据库无法使用,ORA-27101:共享领域不存在
解决方法:1.打开命令提示符(快捷键[win] + R),输入cmd即可进入;
2.输入sqlplus / as sysdba
3.输入startup
说明已成功
二.ORA-00119, invalid specification for system parameter LOCAL_LISTENER;ORA-00130: invalid listener address ‘(ADDRESS=(PROTOCOL=TCP)(HOST=FL)(PORT=1521))’
翻译:系统参数LOCAL_LISTENER规范无效;无效监听地址
可能是监听文件内设置的地址不对,找到数据库安装的地址下的listener.ora文件,如下图
listener.ora文件
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\app\orcl\product\12.1.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = “EXTPROC_DLLS=ONLY:F:\app\orcl\product\12.1.0\dbhome_1\bin\oraclr12.dll”)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-359HIQV)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
tnsnames.ora文件
LISTENER_XSCJ =
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-359HIQV)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
XSCJ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-359HIQV)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XSCJ)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
请注意加粗部分,是主机名或者管理员名。
三.ORA-28000: 帐户已被锁定
1.在命令提示符内输入sqlplus 可直接到达sqlplus登录界面
2.这时用system或者sys账户登录(在安装是设置过)
3.输入alter user SCOTT account unlock;
4.输入exit可以退出数据库
说明
(根据网上百度,加上自己操作总结的,是为了分享一下办法,也是为了留着以后自己再次遇到忘记步骤而翻翻看)