10g 在rh elas3下手工建库失败，请大家帮手排错！

显示全部楼层 · 2014-2-19 11:55:14

错误信息如下：
SMON: enabling tx recovery
Fri Jul 30 19:06:56 2004
Errors in file /ftp/dbfiles/oracle/10g/webdb/udump/webdb_ora_1357.trc:
ORA-01501: CREATE DATABASE failed
ORA-01990: error opening password file '/ftp/program_files/db/oracle10g/product/10.1.0/db_1/dbs/orapw'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Jul 30 19:06:56 2004
Error 1990 happened during db open, shutting down database
USER: terminating instance due to error 1990
Instance terminated by USER, pid = 1357
ORA-1092 signalled during: CREATE DATABASE webdb
MAXINSTANCES 1
MAXLOGHISTORY...

initwebdb.ora文件如下：
db_block_size=8192#@
open_cursors=300#@
db_domain=org.3322.oyzjin #@
background_dump_dest='/ftp/dbfiles/oracle/10g/webdb/bdump'
core_dump_dest='/ftp/dbfiles/oracle/10g/webdb/cdump'
user_dump_dest='/ftp/dbfiles/oracle/10g/webdb/udump'
db_recovery_file_dest='/ftp/dbfiles/oracle/10g/webdb/flash_recovery_area'
db_recovery_file_dest_size=2147483648
job_queue_processes=10
nls_language="SIMPLIFIED CHINESE"
db_name=webdb
processes=200
sessions=225
sga_target=241871530
remote_login_passwordfile=EXCLUSIVE
dispatchers="(PROTOCOL=TCP) (SERVICE=testXDB)"
pga_aggregate_target=25165824
sort_area_size=65536
undo_management=AUTO
undo_tablespace=UNDOTBS1
instance_name=webdb
#db_cache_size=33554432
#db_files = 80
db_file_multiblock_read_count = 16
# MEDIUM
# db_block_buffers = 550
# MEDIUM
# shared_pool_size = 5000000
# MEDIUM
#log_checkpoint_interval = 10000
#parallel_max_servers = 5
# SMALL
log_buffer = 32768
# SMALL
#max_dump_file_size = 10240# limit trace file size to 5 Meg each
#global_names = TRUE
control_files = ("/ftp/dbfiles/oracle/10g/webdb/control/control02.ctl", "/ftp/dbfiles/oracle/10g/webdb/control/control01.ctl&quot

compatible = 10.1.0.2.0

数据库创建语句如下：
get /ftp/dbfiles/oracle/10g/webdb/createdb/createdb.sql
1CREATE DATABASE webdb
2MAXINSTANCES 1
3MAXLOGHISTORY 1
4MAXLOGFILES 5
5MAXLOGMEMBERS 5
6MAXDATAFILES 100
7SYSAUX DATAFILE '/ftp/dbfiles/oracle/10g/webdb/datafiles/sysaux01.dbf'
8SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE 500M
9DATAFILE '/ftp/dbfiles/oracle/10g/webdb/datafiles/system01.dbf' SIZE 500M REUSE
10AUTOEXTEND ON NEXT 1024K MAXSIZE 5120M
11EXTENT MANAGEMENT LOCAL
12DEFAULT TEMPORARY TABLESPACE TEMP
13TEMPFILE '/ftp/dbfiles/oracle/10g/webdb/datafiles/temp01.dbf' SIZE 40M REUSE
14AUTOEXTEND ON NEXT 640K MAXSIZE 2560M
15UNDO TABLESPACE "UNDOTBS1"
16DATAFILE '/ftp/dbfiles/oracle/10g/webdb/datafiles/undotbs01.dbf' SIZE 200M REUSE
17AUTOEXTEND ON NEXT 5120K MAXSIZE 2560M
18CHARACTER SET ZHS16CGB231280
19NATIONAL CHARACTER SET AL16UTF16
20LOGFILE GROUP 1 ('/ftp/dbfiles/oracle/10g/webdb/datafiles/redo01.log') size 10M,
21 GROUP 2 ('/ftp/dbfiles/oracle/10g/webdb/datafiles/redo02.log') size 10M,
22 GROUP 3 ('/ftp/dbfiles/oracle/10g/webdb/datafiles/redo03.log') size 10M
23* USER SYS IDENTIFIED BY "JinJan" USER SYSTEM IDENTIFIED BY "JinJan";

千问 · 2014-2-19 11:55:14

终于成功了，只要把remote_login_passwordfile=EXCLUSIVE改成NONE就可以了，不过建好后在DBCA里不知道为什么看不到的呢？
如果一定要设置成remote_login_passwordfile=EXCLUSIVE，哪INIT《SID》。ORA应该怎样改呢？

千问 · 2014-2-19 11:55:14

设置为EXCLUSIVE也是没问题的,在建库前用orapwd创建密码文件即可.

千问 · 2014-2-19 11:55:14

最初由 husthxd 发布
[B]设置为EXCLUSIVE也是没问题的,在建库前用orapwd创建密码文件即可. [/B]

其实我已经建好了密码文件，但不是放在默认目录，不知道*.ora应该怎样设置才能读取不在默认位置的密码文件