newbie sysadmin causes ORA-00210

From: Allan Plesniarski <aplesnia_at_my-deja.com>
Date: Wed, 15 Nov 2000 23:10:37 GMT
Message-ID: <8uv557$24f$1@nnrp1.deja.com>

FYI: If all of a sudden you see the following errors in the alert log:

ORA-00600: internal error code, arguments: [kzckini: nzdsi_i], [28750], [], [],[], [], [], []

and select file_name from dba_data_files; gives:

ERROR at line 1:

ORA-00210: cannot open the specified controlfile
ORA-00202: controlfile: '/u01/oradata/dev/control01.ctl'
ORA-27041: unable to open file

Linux Error: 13: Permission denied
Additional information: 3

then the oracle user has no permissions on the datafiles.

Cause in this case was sysadmin changed oracle UID and group id in /etc/passwd, then did a chown -R oracle:dba on all the mount points, while the database was running.

Solution was to revert /etc/passwd to the way it was, then redo the chown -R. Fortunately database was consistent.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 15 2000 - 17:10:37 CST