Redhat Enterprise Edition 5安装Oracle 11g (二)
root用户 su - oracle(使用su oracle无法调用为该用户设置的参数)编辑.bash_profile文件:
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$ORACLE_HOME/bin
unset USERNAME
export ORACLE_SID=orcl
export ORACLE_BASE=/u01
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2
export PATH
-----------------------
source .bash_profile(使生效)
cd $ORACLE_HOME
$ ./sqlplus "/ as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 25 10:29:10 2011
Copyright (c) 1982, 2009, Oracle.All rights reserved.
Connected to an idle instance.
SQL>
发现Connected to an idle instance.
只要
SQL>startup
此地报错,
解决方法:cp /u01/app/oracle/admin/cache/pfile/init.ora.2242011165643 /u01/app/oracle/product/11.2.0/dbhome_2/dbs/initorcl.ora
就ok。显示如下:
SQL> startup
ORACLE instance started.
Total System Global Area297119744 bytes
Fixed Size 1336120 bytes
Variable Size 100666568 bytes
Database Buffers 188743680 bytes
Redo Buffers 6373376 bytes
Database mounted.
Database opened.
SQL>
1,修改DBSNMP密码:
重新配置DBCONSOLE,需要输入DBSNMP密码,但任何密码都会显示错误,需要预先修改。
sql>alter user dbsnmp identified by bobo365;
2,删除早期DBCONSOLE创建的用户:
sql>drop role MGMT_USER;
sql>drop user MGMT_VIEW cascade;
sql>drop user sysman cascade;
3,删除早期DBCONSOLE创建的对象:
sql>drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
sql>drop public synonym SETEMVIEWUSERCONTEXT;
4,重新创建DBCONSOLE:(如果是在windows下,要先到注册表删除DBCONSOLE的服务,重启电脑)
$emca -config dbcontrol db -repos create
根据提示,先输入SID,
报错:
log4j:ERROR No appenders could be found for category (emSDK.config).
log4j:ERROR Please initialize the log4j system properly.
解决:未解决。
再输入Y继续;
输入端口1521,输入SYS密码,输入DBSNMP密码,输入SYSMAN 密码,输入Y继续
报错:
严重:参数HOST 的值 null无效
解决:
# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.0.114 MDS
192.168.0.114 192.168.0.114
报错:
严重:创建资料档案库时失败
解决:
未解决。
完成。
以下未完成。
5,检查状态 emctl status dbconsole。
另:
./netmr命令报错,可转换成root用户xhost +命令即可调出配置窗口,但测试连接1521端口时仍旧失败。
附图,可部分出现web界面,但仍未达到windows下状态。
仍存在的问题:
同(一)
页:
[1]