ORA-01031 Hell...

From: B14 <b14speedfreak_at_gmail.com>
Date: 11 Jan 2007 03:44:35 -0800
Message-ID: <1168515875.094433.200170@i56g2000hsf.googlegroups.com>

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. Received on Thu Jan 11 2007 - 05:44:35 CST