linux安装oracle监听无法正常启动问题
《PS:留下小赞赞,比心比心》
问题:创建实例异常,无法连接实例.
解决方案:
1. cd /data/oracle/cfgtoollogs/dbca/orcl 复制OraDb11g_home1_orcl_creation_checkpoint.xml 到别的实例下。然后修改xml里面文件实例名称
2. vim /data/oracle/product/11.2.0/db_1/network/admin/listener.ora
把监听粘贴进去
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /data/oracle/product/11.2.0/db_1)
(SID_NAME = orcl)
)
(SID_DESC =
(GLOBAL_DBNAME = shitan)
(ORACLE_HOME = /data/oracle/product/11.2.0/db_1)
(SID_NAME = shitan)
)
)
3.如果是多个实例需要配置tnsnames.ora
SHITAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = shitan)
)
)
4. oracle用户下重启数据库监听
以oracle身份登录数据库: su -oracle
进入 sqlplus 控制台:sqlplus /nolog
以系统管理员登录:connect/ as sysdba
关闭数据库:shutdown immediate
退出sqlplus控制台:exit
关闭监听器:lsnrctl stop
启动监听器:lsnrctl start
退出监听控制台:exit
进入 sqlplus 控制台:sqlplus /nolog
以系统管理员登录:connect/ as sysdba
启动数据库:startup
退出sqlplus控制台:exit