ORA-01031: insufficient privileges after reorganisation of /etc

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 28 Mar 2003 14:47:08 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7037C79D5@lnewton.leeds.lfs.co.uk>

Oracle files in /etc will most likely be :

oratab : determines the SID : Oracle_home : Auto_start mode for each instance. Should look like this :

CMDB:/oracle/oracle817/product/8.1.7:Y
QA920:/oracle/oracle920/product/9.2.0:Y

and so on.

tnsnames.ora : has an entry for each database, extproc http server on this (and other) servers.

sqlnet.ora : has a few options for how sqlnet works.

listener.ora : determines how the listener operates.

dbca and associated utilities will help you get the tnsnames.ora and listener.ora back again - however, there are samples in $ORACLE_HOME/network/admin/samples for sqlnet.ora and tnsnames.ora if I'm not mistaken.

May I respectfully suggest that you (a) never login as root for general work and (b) set up some form of backup system for your OS files - just in case !

Good luck.

Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: raemanuel_at_aol.com (Ray) [mailto:raemanuel_at_aol.com] Posted At: Thursday, March 27, 2003 8:55 PM Posted To: server
Conversation: ORA-01031: insufficient privileges after reorganisation of /etc
Subject: ORA-01031: insufficient privileges after reorganisation of /etc

Hi,

I did a big fault and have deleted unfortunately all single files in my /etc directory on my Suse Linux 8.1 machine. But all subdirectories of /etc are still there.

<SNIP> Received on Fri Mar 28 2003 - 08:47:08 CST