Re: ORA-01031 Hell...

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