LINUX中ORACLE文件相关配置路径

oracle11g中alter_sid.log的路径：

11g中增加了diag目录，里边存放各种跟踪文件 。eg：/opt/oracle/diag/rdbms/yangdb/yangdb/trace>cat alert_yangdb.log

 

ORA-00205:error in identifying control file, check alert log for more info的问题如何解决？

 

查看alter_sid.log文件

Tue Jul 03 13:37:49 CST 2012

Starting ORACLE instance (normal)

Tue Jul 03 13:37:49 CST 2012

System parameter db_block_buffers enabled without VLM on.

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as /oradb/oracle/102/dbs/arch

Autotune of undo retention is turned off. 

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.5.0.

System parameters with non-default values:

  processes                = 50  www.2cto.com  

  shared_pool_size         = 117440512

  control_files            = /oradb/oracle/102/dbs/control1, /oradb/oracle/102/dbs/control2

  db_block_buffers         = 1024

  log_buffer               = 2032640

  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                  = TEST

PMON started with pid=2, OS id=1406

PSP0 started with pid=3, OS id=1408

MMAN started with pid=4, OS id=1410

DBW0 started with pid=5, OS id=1412

LGWR started with pid=6, OS id=1414

CKPT started with pid=7, OS id=1416

SMON started with pid=8, OS id=1418

RECO started with pid=9, OS id=1420

MMON started with pid=10, OS id=1422

MMNL started with pid=11, OS id=1424
 

Tue Jul 03 13:37:52 CST 2012

ALTER DATABASE   MOUNT

Tue Jul 03 13:37:52 CST 2012 ORA-00210: cannot open the specified control file

ORA-00202: control file: '/oradb/oracle/102/dbs/control1'

ORA-27037: unable to obtain file status

Solaris-AMD64 Error: 2: No such file or directory

Additional information: 3

Tue Jul 03 13:37:55 CST 2012

ORA-205 signalled during: ALTER DATABASE   MOUNT...

 

原因是因为启动数据库时未找到spfile则调用了数据库默认的init.ora，但是其默认值与现有数据库信息不匹配导致数据库不能启动。

解决方案：

 

1）：在报错的路径下面新建一个文件即可（简单）。

2）：

 1 bash#vi /oradb/oracle/102/dbs/initTEST.ora

 2 *.audit_file_dest='/oradb/oracle/admin/TEST/adump'

 3 *.background_dump_dest='/oradb/oracle/admin/TEST/bdump'

 4 *.compatible='10.2.0.5.0'  www.2cto.com  

 5 *.control_files='/oradb/oracle/oradata/TEST/control01.ctl','/oradb/oracle/oradata/TEST/control02.ctl','/oradb/oracle/oradata/TEST/control03.ctl'

 6 *.core_dump_dest='/oradb/oracle/admin/TEST/cdump'

 7 *.db_block_buffers=100# SMALL  

 8 *.db_block_size=8192

 9 *.db_file_multiblock_read_count=16

10 *.db_files=80# SMALL  

11 *.db_name='TEST'

12 *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

13 *.global_names=TRUE

14 *.log_archive_dest_1='location=/oradb/oracle/arch'

15 *.log_archive_dest_state_2='DEFER'

16 *.log_buffer=32768# SMALL

17 *.log_checkpoint_interval=10000

18 *.max_dump_file_size='10240'# limit trace file size to 5 Meg each

19 *.open_cursors=300

20 *.parallel_max_servers=5# SMALL 

21 *.pga_aggregate_target=81788928

22 *.processes=150

23 *.shared_pool_size=113500000# SMALL

24 

25 :wq

26 bash#sqlplus / as sysdba

 

 1 SQL> create spfile from pfile;

 2   www.2cto.com  

 3 File created.

 4 

 5 SQL> startup

 6 ORACLE instance started.

 7 

 8 Total System Global Area  155189248 bytes

 9 Fixed Size                  2094672 bytes

10 Variable Size             142608816 bytes

11 Database Buffers            8388608 bytes

12 Redo Buffers                2097152 bytes

13 Database mounted.

14 Database opened.

 

注：再做数据库应用pfile启动数据库时要注意是否已经通过spfile生成pfile。