Re: ORA-01031 Hell...

From: B14 <b14speedfreak_at_gmail.com>
Date: 11 Jan 2007 04:42:12 -0800
Message-ID: <1168519332.501453.110240@i56g2000hsf.googlegroups.com>

sybrandb wrote:
> On Jan 11, 12:44 pm, "B14" <b14speedfr..._at_gmail.com> wrote:
> > Hi all,
> >
> > My thanks in advance for any subsequent posts.
> >
> > I am doing a database clone of one of our old legacy systems
> > (8.1.7.0.0). I have copied over the ORACLE_HOME and the databfiles
> > (including control files etc..) (using an RCP). I am using a user that
> > we previously used for a 10g clone (which worked). I have changed the
> > ownership and group of the ORACLE_HOME and datafiles, as well as the
> > .profile for the OS user and the .env files and init.ora files. I have
> > altered the TNSNAMES and LISTENER files and can start the listener:
> >
> > OraTEST >lsnrctl status TEST
> >
> > LSNRCTL for Solaris: Version 8.1.7.3.0 - Production on 11-JAN-2007
> > 01:36:01
> >
> > (c) Copyright 1998 Oracle Corporation. All rights reserved.
> >
> > Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCTEST))
> > STATUS of the LISTENER
> > ------------------------
> > Alias TEST
> > Version TNSLSNR for Solaris: Version 8.1.7.3.0 -
> > Production
> > Start Date 10-JAN-2007 08:40:59
> > Uptime 0 days 16 hr. 55 min. 2 sec
> > Trace Level off
> > Security OFF
> > SNMP OFF
> > Listener Parameter File
> > /u02/oracle/testdb/8.1.7/network/admin/listener.ora
> > Listener Log File
> > /u02/oracle/testdb/8.1.7/network/admin/test.log
> > Services Summary...
> > PLSExtProc has 1 service handler(s)
> > TEST has 1 service handler(s)
> > The command completed successfully
> >
> > However I cannot connect to the database at all:
> >
> > OraTEST >
> > OraTEST >sqlplus "/ as sysdba"
> >
> > SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jan 11 03:43:12 2007
> >
> > (c) Copyright 2000 Oracle Corporation. All rights reserved.
> >
> > ERROR:
> > ORA-01031: insufficient privileges
> >
> > Enter user-name: system
> > Enter password:
> > ERROR:
> > ORA-01034: ORACLE not available
> > ORA-27101: shared memory realm does not exist
> > SVR4 Error: 2: No such file or directory
> >
> > Enter user-name: ^C
> > OraTEST >sqlplus /nolog
> >
> > SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jan 11 03:43:23 2007
> >
> > (c) Copyright 2000 Oracle Corporation. All rights reserved.
> >
> > SQL> connect system/manager_at_TEST as sysdba
> > ERROR:
> > ORA-01031: insufficient privileges
> >
> > SQL>
> >
> > Hence I carn't start the database up. I have recreated the password
> > file, and even tried creating a new OS user and new DBA group, but
> > nothing seems to be making much difference.
> >
> > Has anyone got any ideas?
> >
> > Thanks for any posts,
> >
> > Marky Mark.

>
>

> I have changed the
> > ownership and group of the ORACLE_HOME and datafiles

>

> Why? Was the previous group owner (on the source system)the DBA group?
> Is it in uppercase in /etc/group?
> If you really changed the group, you are aware you now need to relink
> Oracle?

>

> --
> Sybrand Bakker
> Senior Oracle DBA

In answer to your question, yeah... Essentially, on the other box it was a group called DBA, on the box that I have cloned to it the group is dba. We did have 2 dba groups set up in /etc/group (dba and DBA). Now we just have dba. After altering the owner and gid of the ORACLE_HOME I have always ran a relink all at the prompt whilst using the oracle user.

However non of this seems to be making any difference.

Thanks for the posts,

Marky Boy... Received on Thu Jan 11 2007 - 06:42:12 CST