2005-12-19 20:45
giftxiao
求助啊~~,AIX5.2装ORACLE的问题,急.......
初学AIX~,ORACLE也不是很熟,这几天给客户装ORACLE9.2.0.1,操作系是AIX5.2,碰到一些问题~,忘高手能帮忙看一下:
1.参考了网上的一些安装文档,ORACLE安装基本是没问题了,只是安装完成后,自动配置时的最后一步,配置enterprise manager configuration assistant时,不知道如何配,记得要填写username ,password,service这几项
2.SID定义的是ora9,在安装时选的是自定义安装,不建数据库.装好后进sqlplus 用startup启,先是报错initora9.ora文件找不到,由于把oracle_home\dbs下的init.ora改为initora9.ora,启动时报error in identifying .controlfile,check alert log for more info.找了oracle_home\rdbms\log\alert_ora9.log日志,查看错误,部分日志如下:
Sun Dec 18 01:45:25 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 4194304
control_files = ora_control1, ora_control2
db_block_buffers = 100
log_buffer = 32768
log_checkpoint_interval = 10000
db_files = 80
db_file_multiblock_read_count= 8
global_names = TRUE
parallel_max_servers = 5
max_dump_file_size = 10240
db_name = DEFAULT
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Sun Dec 18 01:45:25 2005
ALTER DATABASE MOUNT
Sun Dec 18 01:45:25 2005
ORA-00202: controlfile: 'ora_control1'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
意思是报controlfile找不到.有个疑问,是不是要先建个数据库才会有controlfile文件?
3.由于用dbca建数据库,选的是new database,只是改了一下字符集,其它的参数没变,建库过程中到adding oracle xml db时报insufficient privilieges to execute the operation(s)错,选了忽略错误,继续建库,能够完成.建完后启startup还是报上面第二问题一样的错误.不知道是不是建库时要选或是设什么参数?还是initora9.ora文件要修改一些东西才行?
望高手指导,感激不尽,先谢谢了~~~~~~``