Oracle Database Discussions

Hi all,

My thanks in advance for any subsequent posts.

I have recently cloned one of our production (legacy) instances which we are looking at upgrading (8.1.7.0.0). Anyhow I have copied all the appl top's over and the database software (including datafiles).

I have a user (which was used with a previous 10g instance) which is in the dba group (its on a Solaris 5.8 box). I have changed the ownership and group of all the files in the database sofware and datafiles to this user. I have altered the .profile for the user, and the ones for the ORACLE_HOME .env file. I have also altered the tnsnames and listener files respectively. I have recreated the password file.

Having done all of this, I cannot connect to sqlplus using:

$ sqlplus "/ as sysdba"

all that I get is:

ERROR:
ORA-01031: insufficient privileges

Anyhow I can connect using:

sqlplus /nolog
connect sys/manager@TEST as sysdba

I can even issue a STARTUP NOMOUNT; which starts up the database sucessfully.

Has anyone any ideas how to resolve this??? I have even tried setting up a new user in the dba group and altered the file ownership and .profile

I have also run relink all at the prompt while logged in as the user (for both users).

Thanks in advance for any subsequent posts,

Marky Boy....