p; 4.升级
解包:
unzip p3095277_9204_LINUX.zip
cpio -icvd < 9204_lnx32_release.cpio 这个地方最好还以root身份解包，否则可能还会提示你权限不够。
现在可以再次运行runInstaller,要先升级oui(最后一个选项)否则不让升级到9.2.0.4.而且,升级完oui以后,要退出oui然后再重新运行oui, 再升级到9.2.0.4.不退出继续升级会报告错误.升级过程中,仍然会出现ins_oemagent.mk错误,点 Ignore 忽略(可以通过下面的补丁解决)。然后还会提示你用root身份来执行一个/opt中的一个脚本，你同样开一个终端，用root身份来执行就可以了。
5.打补丁
[quote:db788a2c24]su - oracle
$ unzip p3119415_9204_LINUX.zip
$ cd 3119415
$ export PATH=$PATH:/tmp/OPatch
$ export PATH=$PATH:/sbin # the patch needs "fuser" which is located in /sbin
$ which opatch
/tmp/OPatch/opatch
$ opatch apply
[/quote:db788a2c24]
这个地方有一个问题需要注意，直接用oracle身份解压可能提示权限不够，用root身份解压，然后用oracle身份来执行还会提示你权限不够，你用root解压然后执行chmod 777 3119415，然后su - oracle;/tmp/Opatch/opatch apply就ok了。
好了，大功告成了! 运行dbca命令来创建数据库，还有文档上说这个时候可能会出错，要修改dbca文件来解决，我没有遇到这个问题，如果你遇到了可以上google上找相关文档，来解决这个问题。
三、清扫战场及实验
1.删除临时文件(这些临时文件将近3G，不用我再说删除的意义了吧？)
[quote:db788a2c24]cd /tmp
rm -rf *[/quote:db788a2c24]
2.改回gcc,g++的版本，否则在以后编译安装其他软件时可能会有问题
[quote:db788a2c24]# mv /usr/bin/gcc323 /usr/bin/gcc
# mv /usr/bin/g++323 /usr/bin/g++[/quote:db788a2c24]
3.连接一下数据库，检查一下自己的劳动成果吧！
[quote:db788a2c24]su - oracle
oracle$ sqlplus /nolog
SQL> connect / as sysdba
SQL> startup
附:
sqlplus /nolog
connect / as sysdba
startup nomount
1.
CREATE DATABASE ivps
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 7
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE ''''/home/oracle/oradata/ivps/system01.dbf'''' SIZE 500M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE ''''/home/oracle/oradata/ivps/temp01.dbf'''' SIZE 512M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS" DATAFILE ''''/home/oracle/oradata/ivps/undotbs01.dbf'''' SIZE 1024M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 (''''/home/oracle/oradata/ivps/redo01.log'''') SIZE 20480K,
GROUP 2 (''''/home/oracle/oradata/ivps/redo02.log'''') SIZE 20480K,
GROUP 3 (''''/home/oracle/oradata/ivps/redo03.log'''') SIZE 20480K,
GROUP 4 (''''/home/oracle/oradata/ivps/redo04.log'''') SIZE 20480K,
GROUP 5 (''''/home/oracle/oradata/ivps/redo05.log'''') SIZE 20480K,
GROUP 6 (''''/home/oracle/oradata/ivps/redo06.log'''') SIZE 20480K;
2.
CREATE TABLESPACE "INDX" LOGGING DATAFILE ''''/home/oracle/oradata/ivps/indx01.dbf'''' SIZE 1024M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE TABLESPACE "USERS" LOGGING DATAFILE ''''/home/oracle/oradata/ivps/users01.dbf'''' SIZE 250M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE TABLESPACE "TOOLS" LOGGING DATAFILE ''''/home/oracle/oradata/ivps/tools01.dbf'''' SIZE 50M REUSE AUTOEXTEND ON NEXT 320K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
3.
connect SYS/change_on_install as SYSDBA
@/home/oracle/product/92/rdbms/admin/catalog.sql;
@/home/oracle/product/92/rdbms/admin/catproc.sql;
connect SYSTEM/manager
@/home/oracle/product/92/sqlplus/admin/pupbld.sql;
上一页 [1] [2] [3] |
