我安装Oracle时遇到的问题及处理办法,现在比较乱，有空整理一下子。
error: You do not have sufficient privileges to write 没有办法
解决方法： 原因是没有权限，主要是安装程序以oracle用户身份试图新建一个目录/oradata失败，解决办法，以root用户建立该目录，然后把它属主改变oracle用户:
su root
mkdir /oradata
chown -R oracle.dba /oradata
error while loading shared libraries: libdb.so.2 创建到libdb2.so.3 的链接。
Paramater "orahome" = /opt/ora9/product/9.2"
Paramater "nodeinfo" = NO_VALUE
Agent Service Failed。 没有办法。
# cd /usr/bin
# mv gcc gcc323
# mv g++ g++323
# ln -s gcc296 gcc
# ln -s g++296 g++
error opening password file '/data/oracle/920/dbs/orapw'
QL> startup
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
ORA-01990: error opening password file '/data/oracle/920/dbs/orapw'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
将dbs/目录下的一个密码文件orapworcl（orapw+SID名称）链接为orapw即可。
使用enterprise manager console连接必须有SYSDBA的权限
起动时以参数的形式指定pfile文件
startup open pfile=/u01/app/oracle/admin/oracle3/pfile/initoracle3.ora
oracle client windows 精简版本。
功能没有减少哦
客户机安装后还要配置tnsnames.ora文件,在oracle客户端安装目录的network的admin目录下
内容类似下面:
ORADB =
(DEs criptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = www.xdowns.com )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oradb)
)
)
不过都是要配置tnsnames.ora文件的,最好在安装完驱动后重启一下电脑,有时这样才能生效
运行平台 Windows Server 2003 Windows 2000 Windows XP Windows CE Windows 9*/ME Windows NT
[oracle@orabox 3238244]$ opatch apply
PERL5LIB=/data/oracle/920/Apache/perl/lib/5.00503:/tmp/OPatch/perl_modules; export PERL5LIB
/data/oracle/920/Apache/perl/bin/perl /tmp/OPatch/opatch.pl apply
OPatch Version 1.0.0.0.46
Perl Version 5.00503
Oracle Home = /data/oracle/920
Location of Oracle Inventory = /data/oracle/oraInventory
Oracle Universal Installer shared library = /data/oracle/oui/bin/linux/liboraInstaller.so
Path to Java = /data/oracle/jre/1.3.1/bin/java
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Universal Installer components = /data/oracle/oui
Required Jar File under Oracle Universal Installer = lib/OraInstaller.jar
Exception in thread "main" java.lang.NoClassDefFoundError: O2O
/tmp/OPatch/opatch.pl version: 1.0.0.0.46
Copyright (c) 2001,2002,2003 Oracle Corporation. All Rights Reserved.
Cannot set up OUI inventory session
ERROR: OPatch failed because of Inventory problem.
Cannot set up OUI inventory session
使用下面的带参数的命令即可： opatch apply -no_inventory
|
