oerr problem in oracle 12c.

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 4 Feb 2014 15:38:39 +0000 (UTC)
Message-ID: <pan.2014.02.04.15.38.39_at_gmail.com>

I tried to do oerr from a non-oracle account, with the following result:

oerr ora 257
Can't locate English.pm in _at_INC (@INC contains: /oracle/product/12.1.0.1/

dbhome1/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /oracle/
product/12.1.0.1/dbhome1/perl/lib/site_perl/5.14.1 /oracle/
product/12.1.0.1/dbhome1/perl/lib/5.14.1/x86_64-linux-thread-multi /

oracle/product/12.1.0.1/dbhome1/perl/lib/5.14.1 .)

The solution is very simple, as expected:

chmod -R 750 /oracle/product/12.1.0.1/dbhome1/perl

The user that I was using is a member of the oinstall group:

mgogala_at_medo ~]$ id
uid=1000(mgogala) gid=1000(mgogala) groups=1000(mgogala),10(wheel),39 (video),987(vboxusers),1001(oinstall)

The original protections for the package files (.pm) and libraries is 700, which means that only owner can see them. As soon as the group was added, the utility started working as expected:

[mgogala_at_medo ~]$ oerr ora 257
00257, 00000, "archiver error. Connect internal only, until freed."

// *Cause:  The archiver process received an error while trying to archive


//	 a redo log.  If the problem is not resolved soon, the database

//	 will stop executing transactions. The most likely cause of this

//	 message is the destination device is out of space to store the


//	 redo log file.


// *Action:  Check archiver trace file for a detailed description


//	  of the problem. Also verify that the

//	 device specified in the initialization parameter


//	 ARCHIVE_LOG_DEST is set up properly for archiving.


[mgogala_at_medo ~]$ 

This doesn't compromise security since the perl modules are only usable 
by the members of the oinstall group, which is not given to just anyone.
This looks just like a stupid testing mistake, I will report it on MOS
community forums.

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com

Received on Tue Feb 04 2014 - 16:38:39 CET