Re: Help with connection failure during conversion 9i to 10g

I am sorry, I think I have it.

Permissions on files and a problem with the install.

Evan

Evan wrote:
> 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
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> 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
>
> Copyright (c) 1991, 2005, Oracle. All rights reserved.
>
> 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:43:30 CST