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@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.

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@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.

What does the output of the following command show?

ls -l $ORACLE_HOME/bin/oracle

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@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.
>
> What does the output of the following command show?
>
> ls -l $ORACLE_HOME/bin/oracle

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 >

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

The setuid bit isn't set. Try the following:

chmod 6755 $ORACLE_HOME/bin/oracle

HTH

-g

gazzag wrote:
> B14 wrote:
> > 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 >
>
> The setuid bit isn't set. Try the following:
>
> chmod 6755 $ORACLE_HOME/bin/oracle
>
> HTH
>
> -g

This doesn't seem to have made any difference:

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 >chmod 6755 $ORACLE_HOME/bin/oracle
OraTEST >sqlplus "/ as sysdba"

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jan 11 04:24:52 2007

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:

gazzag wrote:
> B14 wrote:
> > 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 >
>
> The setuid bit isn't set. Try the following:
>
> chmod 6755 $ORACLE_HOME/bin/oracle
>
> HTH
>
> -g

Hi,

Thanks for the reply, this doesn't seem to make any difference:

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 >chmod 6755 $ORACLE_HOME/bin/oracle
OraTEST >sqlplus "/ as sysdba"

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jan 11 04:24:52 2007

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:

thanks again,

Marky Boy...

On Jan 11, 12:44 pm, "B14" <b14speedfr...@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@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

sybrandb wrote:
> On Jan 11, 12:44 pm, "B14" <b14speedfr...@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@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...

Is your ORACLE_SID set to TEST?

Valentin Minzatu wrote:
> Is your ORACLE_SID set to TEST?

I think that this will answer your question:

OraTEST >echo $ORACLE_SID
TEST
OraTEST >echo $ORACLE_HOME
/u02/oracle/testdb/8.1.7
OraTEST >

I looked at that, and a few other things as well. But alas no joy, I
ran through the metalink guide to resolving connect "/ as sysdba" but
that didn't get me anywhere....

thanks again for the posts though,

Marky Boy...