Help with connection failure during conversion 9i to 10g

From: Evan <eehrenh_at_comcast.net>
Date: Wed, 14 Dec 2005 09:18:08 -0500
Message-ID: <dnp9j0$ino$1@leto.cc.emory.edu>

Hello,

Thank you for all your posts. I learn alot from just lurking.

We are a 9.2.0.6 shop looking to upgrade to 10.2.

I have installed the software in a new home and taken my cold backup of the database. Now I want to connect as sysdba via the 10.2 client.

I can not connect to the database with the 10.2 client.

Any advice would be fantastic,

Evan

I try to connect to the database using 9.2 and it works fine. I try to connect to the database using 10.2 and get the following:

$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 14 08:56:28 2005

SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges

- - Here is my setup - - - SQLPATH=/home/oracle:/u01/app/oracle/product/102:/home/oracle/evan PATH=
/u01/app/oracle/product/102/bin:/usr/bin:/etc:/usr/sbin:
/usr/local/bin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.:
/usr/bin/sendmail:/u01/app/oracle/product/102/bin:
/usr/dt/bin:/usr/openwin/bin

ORACLE_BASE=/u01/app/oracle
ORACLE_PATH=

     .:/u01/app/oracle/product/102/bin:


     /u01/app/oracle/product/102/obackup/bin:

     /opt/bin:/bin:/usr/bin:/home/oracle

ORACLE_SID=FMQA
ORACLE_DOC=/u01/app/oracle/product/102/orainst/doc TNS_ADMIN=/u01/app/oracle/product/102/network/admin ORACLE_ADMIN=/u01/app/oracle/admin
ORA_NLS10=/u01/app/oracle/product/102/nls/data ORACLE_TERM=vt220
ORA_NLS32=/u01/app/oracle/product/102/ocommon/nls/admin/data

STAT=/u01/app/oracle/product/102/statistics
LD_LIBRARY_PATH=/u01/app/oracle/product/102/lib:/usr/dt/lib
ORACLE_HOME=/u01/app/oracle/product/102

- - Machine - - - SunOS testbox 5.8 Generic_117350-29 sun4u sparc SUNW,Sun-Fire-480R Four CPUs, 16 GB RAM.
- - PFILE - - - background_dump_dest = /u01/app/oracle/admin/FMQA/bdump core_dump_dest = /u01/app/oracle/admin/FMQA/cdump user_dump_dest = /u01/app/oracle/admin/FMQA/udump log_archive_format = arch%S.arc log_archive_dest = /u01/app/oracle/admin/FMQA/arch utl_file_dir = "/u01/app/fm/fmd/transfers_in" utl_file_dir = "/u01/app/fm/fmd/transfers_out" utl_file_dir = "/u01/app/dbadmin/logs/FMQA" db_block_size = 8192 db_name = FMQA db_files = 1021 db_file_multiblock_read_count = 8 # SMALL java_pool_size=157286400 large_pool_size=157286400 shared_pool_size= 157286400 sort_area_size = 2048000 open_cursors = 500 optimizer_index_cost_adj=80 optimizer_index_caching =20 compatible=10.2.0.1.0 log_checkpoint_interval = 3600 log_checkpoint_timeout = 0 processes = 200 log_buffer = 163840 # LARGE audit_trail = true # if you want auditing audit_trail = false # if you want auditing audit_file_dest=/u01/app/oracle/admin/FMQA/audit audit_trail=OS max_dump_file_size = 10240 # limit trace file size to 5 Meg each job_queue_processes=5 timed_statistics = TRUE QUERY_REWRITE_ENABLED=TRUE undo_management=AUTO undo_retention=1560 undo_tablespace=UNDOTBS1 star_transformation_enabled=FALSE fast_start_mttr_target=300 event='10235 trace name context forever, level 2' remote_login_passwordfile=EXCLUSIVE streams_pool_size=50331648 pga_aggregate_target=25165824 session_max_open_files=20 db_domain=cc.emory.edu control_files = (/u02/oradata/FMQA/control01/control01.ctl, /u02/oradata/FMQA/control02/control02.ctl, /u02/oradata/FMQA/control03/control03.ctl)
- - Listener - - - $ lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 14-DEC-2005 09:14:48

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=melpomene.cc.emory.edu)(PORT=1521))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 10.2.0.1.0 - 
Production
Start Date                14-DEC-2005 08:39:10
Uptime                    0 days 0 hr. 35 min. 37 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF

Listener Parameter File
/u01/app/oracle/product/102/network/admin/listener.ora Listener Log File
/u01/app/oracle/product/102/network/log/listener.log Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=melpomene.cc.emory.edu)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=melpomene.cc.emory.edu)(PORT=1526)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=FMTEST))) Services Summary...
Service "AECTEST.cc.emory.edu" has 1 instance(s).

Instance "FMTEST", status UNKNOWN, has 1 handler(s) for this service... Service "FMQA.CC.EMORY.EDU" has 1 instance(s).

Instance "FMQA", status UNKNOWN, has 1 handler(s) for this service... Service "FMTEST.CC.EMORY.EDU" has 2 instance(s).

Instance "FMTEST", status UNKNOWN, has 1 handler(s) for this service... Instance "FMTEST", status READY, has 1 handler(s) for this service... Service "extproc" has 1 instance(s).

Instance "extproc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully Received on Wed Dec 14 2005 - 08:18:08 CST