Re: install problem,8.1.7 on solaris8

From: mark a thomas <marktuid4att_at_att.net>
Date: Mon, 11 Feb 2002 21:20:50 GMT
Message-ID: <3C684593.66B0E6A8@att.net>

Thanks for the help. I cleaned up the /etc/system file and the db sorta started.

$ dbstart

Oracle Server Manager Release 3.1.7.0.0 - Production

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SVRMGR> Connected.
SVRMGR> ORACLE instance started.

Total System Global Area                         81342624 bytes
Fixed Size                                          73888 bytes
Variable Size                                    55906304 bytes
Database Buffers                                 25190400 bytes
Redo Buffers                                       172032 bytes

ORA-00205: error in identifying controlfile, check alert log for more info SVRMGR>
Server Manager complete.

Database "ora1sid" warm started.

so I looked at the alert log.

$ pwd

/opt/oracle/admin/ora1gdbn/bdump
$
$ tail alert_ora1sid.log

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Mon Feb 11 14:08:00 2002
alter database mount
Mon Feb 11 14:08:00 2002
ORA-00202: controlfile: '/usr/ora1_db_files/oradata/ora1gdbn/control01.ctl' ORA-27037: unable to obtain file status
Intel SVR4 UNIX Error: 2: No such file or directory Additional information: 3
Mon Feb 11 14:08:03 2002
ORA-205 signalled during: alter database mount...
$
$ ls /usr/ora1_db_files/oradata/ora1gdbn/
drsys01.dbf indx01.dbf rbs01.dbf system01.dbf temp01.dbf tools01.dbf users01.dbf

the control01.ctl file is not there. Is this file supposed to be created wen the "starter" db was created?
Is this why the db was "warm started" ?

I see these control files referenced it the parameter file, /opt/oracle/admin/ora1gdbn/pfile/initora1sid.ora

control_files = ("/usr/ora1_db_files/oradata/ora1gdbn/control01.ctl", "/usr/ora1_db_files/oradata/or
a1gdbn/control02.ctl", "/usr/ora1_db_files/oradata/ora1gdbn/control03.ctl")

How are they created and what should they contain?

Thanks for any help.

/markt Received on Mon Feb 11 2002 - 15:20:50 CST

Re: install problem,8.1.7 on solaris8_x86