安装oracle完后遇到的问题

问题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_SID
orcl
[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 2011

Copyright (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成功后启动数据库！