问题1:
打开终端用sqlplus连不了,报:
[root@localhost ~]# su - oracle[oracle@localhost ~]$ sqlplus /nolog
sqlplus: error while loading shared libraries: /opt/oracle/product/OraHome/lib/libsqlplus.so: cannot restore segment prot after reloc: Permission denied
解决办法:
原来这是SELinux搞的鬼,解决办法有两个
1. 使用chcon 命令
示例: chcon -t texrel_shlib_t /usr/local/rsi/idl_6.1/bin/bin.linux.x86/*.so(当再次执行sqlplus /nolog时又报错,只是libsqlplus.so变为其他时替换*再执行)
2. 禁止掉SELinux
更改/etc/sysconfig/selinux 文件的内容为 SELINUX=disabled
接下来:
查看参数:
[oracle@localhost ~]$ echo $ORACLE_SIDorcl
[oracle@localhost ~]$ echo $ORACLE_HOME
/opt/oracle/product/OraHome
若为空的话:
[oracle@localhost ~]$ export $ORACLE_SID=orcl
[oracle@localhost ~]$ export $ORACLE_HOME=/opt/oracle/product/OraHome
连接数据库:
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Jul 8 19:44:53 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> conn sys/sys as sysdba
启动监听:
[oracle@localhost ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 08-JUL-2011 18:36:22
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /opt/oracle/product/OraHome/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /opt/oracle/product/OraHome/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 08-JUL-2011 18:36:24
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/OraHome/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@localhost ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://localhost.localdomain:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control .............. started.
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/product/OraHome/localhost.localdomain_orcl/sysman/log
问题2:https://localhost.localdomain:1158/em连接后登录界面报用户名或密码失效
解决:
sql>alter user sys identified by sys;
连接em成功后启动数据库!