![](https://netmarket.oss-cn-hangzhou.aliyuncs.com/product/d265eadad4434180a5cc67cd9d940a23jpg.jpg)
1、修改监听IP地址
当使用本镜像安装系统后,监听程序由于绑定了旧主机名所以无法正常启动,需要修改$ORACLE_HOME/network/admin下的listener.ora文件,检查/etc/hosts的主机记录或windows的hosts文件,确保正确的对应关系,也可参考下面命令获的主机名:
PS C:\Users\Administrator> hostname
WIN-Q7HKEHJMCPV
然后修改listener.ora文件,修改红色部分,用上面主机名替换:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-Q7HKEHJMCPV)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = C:\app\Administrator
2、修改LOCAL_LISTENER参数
需重新设置以下LOCAL_LISTENER 参数,调整方法:
sqlplus / as sysdba登陆执行:
ALTER SYSTEM SET LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST= WIN-Q7HKEHJMCPV)(PORT=1521))';
最后重启监听程序即可连接数据库!
lsnrctl stop&lsnrctl start
3、修改TNSNAMES.ORA
当监听程序启动正常后,若服务器内部需要引用TNSNAMES.ORA文件连接数据库,还需要将此文件里的HOST改成新主机名。
4、数据库登陆方式
本镜像还预安装了Oracle EM数据库管理后台(地址:https://你的IP:1158/em)和PLSQL Developer软件(已激活,主要针对windows server环境),数据库登陆信息文件保存在桌面或Linux环境的/home/oracle/Orapwd.txt;
5、11G数据库常见维护
常见维护:
(1)登陆数据库并新建sqlplus / as sysdba
创建普通用户:
create user user1 identified by user1;
grant connect,resource to user1;
(2)客户端(PLSQL或navicat等)的TNS配置:
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-Q7HKEHJMCPV)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
(3)连接示例:
sqlplus user1/user1@orcl
(4)监听
lsnrctl start 启动监听
lsnrctl status 查看监听状态
lsnrctl stop 关闭监听
(5)数据库 sqlplus / as sysdba
startup 启动数据库
shutdown immediate 关闭数据库
select name,open_mode from v$database;查看数据库
(6)数据库监控
emctl start dbconsole 启动
emctl status dbconsole 查看
emctl stop dbconsole 关闭
![](https://netmarket.oss-cn-hangzhou.aliyuncs.com/product/fa32ebcc8e814788bc5b84c98c029cbajpg.jpg)