Re: ORA-01031 Hell...

gazzag wrote:
> B14 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.

>

That command shows the following:

OraTEST >ls -l $ORACLE_HOME/bin/oracle
-rwxr-x--x 1 oratest DBA 33679836 Jan 11 02:38 /u02/oracle/testdb/8.1.7/bin/oracle
OraTEST > Received on Thu Jan 11 2007 - 06:06:52 CST