Home » RDBMS Server » Server Administration » Problem upgrading 8.1.7.0 - 10.2.0.4 (Solaris 9)
Problem upgrading 8.1.7.0 - 10.2.0.4 [message #322902] Mon, 26 May 2008 15:07 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Hi, i was trying to upgrade a database.
i was following the migration tutorial from oracle but when i copy my initSID.ora from oracle8 to oracle10 (i modified follow the instructions after running utlu102i.sql and when i try to startup oracle 10 i get the follow error
/oracle/app/oracle/product/10.2.0.1/dbs =>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 26 17:03:08 2008

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: 


i think is not the connection cause i use the same tnsnames, listeners and sqlnet.ora
i can start and stop listeners and do tnspings without problem.

do anyone know what i am wrong? thank you in advance
Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #322904 is a reply to message #322902] Mon, 26 May 2008 15:32 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>when i try to startup oracle 10 i get the follow error
I doubt what you posted was from CUT & PASTE of whole session.

At the command prompt while logged in as user "oracle" ( or who ever owns the Oracle s/w tree) do the following:
lsnrctl status
lsnrctl service
env | sort
sqlplus
/ as sysdba
startup
exit
===========================
Then using CUT & PASTE, post back EVERYTHING on the terminal for these commands & what was returned/displayed.

[Updated on: Mon, 26 May 2008 15:33] by Moderator

Report message to a moderator

Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #322906 is a reply to message #322904] Mon, 26 May 2008 16:01 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

lsnrctl status
/oracle/app/oracle/product/10.2.0.1/network/log =>lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 26-MAY-2008 17:55:03

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
Start Date                26-MAY-2008 17:49:18
Uptime                    0 days 0 hr. 5 min. 44 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /oracle/app/oracle/product/10.2.0.1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e3000-9)(PORT=1521)))
The listener supports no services
The command completed successfully


lsnrctl status
:/oracle/app/oracle/product/10.2.0.1/network/log =>lsnrctl services

LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 26-MAY-2008 17:55:09

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The listener supports no services
The command completed successfully
:/oracle/app/oracle/product/10.2.0.1/network/log =>

look at The listener supports no services

tnsping
:/oracle/app/oracle/product/10.2.0.1/network/log =>tnsping META4T

TNS Ping Utility for Solaris: Version 10.2.0.4.0 - Production on 26-MAY-2008 17:55:26

Copyright (c) 1997,  2007, Oracle.  All rights reserved.

Used parameter files:
/oracle/app/oracle/product/10.2.0.1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST= localhost)(PORT=1528)) (CONNECT_DATA=(SID=META4T)))
TNS-12541: TNS:no listener

look at TNS-12541: TNS:no listener :S


sqlplus
:/oracle/app/oracle/product/10.2.0.1/network/log =>sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 26 17:59:12 2008

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: 

Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #322907 is a reply to message #322902] Mon, 26 May 2008 16:12 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
Since you are incapable or unwilling to follow simple directions,
You're On Your Own (YOYO)!
Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #322908 is a reply to message #322906] Mon, 26 May 2008 16:12 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

i did a mistake and i fix it but i continue with the same problem
ill post all here together this time

:/oracle/app/oracle/product/10.2.0.1/network/admin =>lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 26-MAY-2008 18:10:44

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
Start Date                26-MAY-2008 18:08:28
Uptime                    0 days 0 hr. 2 min. 16 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/10.2.0.1/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/product/10.2.0.1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e3000-9)(PORT=1521)))
The listener supports no services
The command completed successfully
META4T:/oracle/app/oracle/product/10.2.0.1/network/admin =>lsnrctl services

LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 26-MAY-2008 18:10:49

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The listener supports no services
The command completed successfully


env |sort
DISPLAY=192.168.253.53:0.0
EDITOR=vi
EPC_DISABLED=TRUE
HOME=/export/home/oracle
HOSTNAME=e3000-9
HOSTTYPE=sparc
HZ=
LD_LIBRARY_PATH=/oracle/app/oracle/product/10.2.0.1/lib:/oracle/app/oracle/product/10.2.0.1/ctx/lib:/usr/lib:/usr/openwin/lib:/usr/dt/lib:
LOGNAME=oracle
MACHTYPE=sparc-sun-solaris2.9
NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS
NLS_LANG=american_america.WE8ISO8859P15
OLDPWD=/oracle/app/oracle/product/8.1.7/network/admin
ORACLE_BASE=/oracle/app/oracle/product
ORACLE_DOC=/oracle/app/oracle/product/10.2.0.1/doc
ORACLE_HOME=/oracle/app/oracle/product/10.2.0.1
ORACLE_PATH=/usr/local/bin:/oracle/app/oracle/product/10.2.0.1/bin:/opt/bin:/bin:/usr/bin:/usr/ccs/bin
ORACLE_SID=META4T
ORACLE_TERM=dtterm
ORA_CSM_MODE=line
ORA_NLS10=/oracle/app/oracle/product/10.2.0.1/nls/data
OSTYPE=solaris2.9
PATH=/usr/local/bin:/oracle/app/oracle/product/10.2.0.1/bin:/usr/local/bin:/usr/openwin/bin:/usr/bin:/usr/sbin:/etc:/usr/ccs/bin:/usr/ucb:
PS1=$ORACLE_SID:$PWD =>
PWD=/oracle/app/oracle/product/10.2.0.1/network/admin
SHELL=/bin/ksh
SHLVL=1
TERM=vt100
TMPDIR=/var/tmp
TNS_ADMIN=/oracle/app/oracle/product/10.2.0.1/network/admin
TZ=GMT+3
_=/usr/bin/env


:/oracle/app/oracle/product/10.2.0.1/network/admin =>tnsping META4T

TNS Ping Utility for Solaris: Version 10.2.0.4.0 - Production on 26-MAY-2008 18:11:08

Copyright (c) 1997,  2007, Oracle.  All rights reserved.

Used parameter files:
/oracle/app/oracle/product/10.2.0.1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST= localhost)(PORT=1528)) (CONNECT_DATA=(SID=META4T)))
OK (10 msec)
:/oracle/app/oracle/product/10.2.0.1/network/admin =>

META4T:/oracle/app/oracle/product/10.2.0.1/network/admin =>sqlplus 

SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 26 18:15:19 2008

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: 


[Updated on: Mon, 26 May 2008 16:15]

Report message to a moderator

Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #322910 is a reply to message #322907] Mon, 26 May 2008 16:57 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

anacedent wrote on Mon, 26 May 2008 16:12
Since you are incapable or unwilling to follow simple directions,
You're On Your Own (YOYO)!


sorry i think now you have what you asked for
Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #322914 is a reply to message #322902] Mon, 26 May 2008 18:42 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>I am still not sure exactly what is wrong but I see numerous "things that just don't look right".

>PS1=$ORACLE_SID:$PWD =>
The prompt is supposed to contain $ORACLE_SID, but for many of the commands posted prompt contained a NULL value as below:
>:/oracle/app/oracle/product/10.2.0.1/network/admin =>lsnrctl status

>Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
HOST=????????
Probably confuses Oracle s/w profoundly.

>(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST= localhost)(PORT=1528)) (CONNECT_DATA=(SID=META4T)))
PORT=1528?????? see PORT=1521 above

>HOST=localhost
I doubt this is correct.
Installation Guide says to use valid, fully qualified domain name.
Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #323192 is a reply to message #322914] Tue, 27 May 2008 11:42 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

anacedent wrote on Mon, 26 May 2008 18:42
>I am still not sure exactly what is wrong but I see numerous "things that just don't look right".

>PS1=$ORACLE_SID:$PWD =>
The prompt is supposed to contain $ORACLE_SID, but for many of the commands posted prompt contained a NULL value as below:
>:/oracle/app/oracle/product/10.2.0.1/network/admin =>lsnrctl status

>Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
HOST=????????
Probably confuses Oracle s/w profoundly.

>(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST= localhost)(PORT=1528)) (CONNECT_DATA=(SID=META4T)))
PORT=1528?????? see PORT=1521 above

>HOST=localhost
I doubt this is correct.
Installation Guide says to use valid, fully qualified domain name.



Ok i changed it
listener.ora
META4T =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= TCP)(Host= e3000-9)(Port= 1521))
  )

SID_LIST_META4T =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME= META4T)
      (ORACLE_HOME= /oracle/app/oracle/product/10.2.0.1)
      (SID_NAME = META4T)
    )
  )



tnsnames.ora


META4T = (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST= e3000-9)(PORT=1521))
                (CONNECT_DATA=(SID=META4T)
                )
            )
META4T.WORLD=
        (DESCRIPTION=
                (ADDRESS_LIST=
                        (ADDRESS=(PROTOCOL=TCP)(HOST=e3000-9)(PORT=1521))
      )
      (CONNECT_DATA=
         (SERVICE_NAME=META4T.WORLD)
      )
   )


lsnrctl services
$ lsnrctl services

LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 27-MAY-2008 13:38:54

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The listener supports no services
The command completed successfully


lsnrctl status
lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 27-MAY-2008 13:38:58

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
Start Date                27-MAY-2008 13:36:19
Uptime                    0 days 0 hr. 2 min. 39 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/10.2.0.1/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/product/10.2.0.1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e3000-9)(PORT=1521)))
The listener supports no services
The command completed successfully


and at least
env |sort
 env |sort
DISPLAY=192.168.253.53:0.0
EDITOR=vi
EPC_DISABLED=TRUE
HOME=/export/home/oracle
HZ=
LD_LIBRARY_PATH=/oracle/app/oracle/product/10.2.0.1/lib:/oracle/app/oracle/product/10.2.0.1/ctx/lib:/usr/lib:/usr/openwin/lib:/usr/dt/lib:
LOGNAME=oracle
NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS
NLS_LANG=american_america.WE8ISO8859P15
ORACLE_BASE=/oracle/app/oracle/product
ORACLE_DOC=/oracle/app/oracle/product/10.2.0.1/doc
ORACLE_HOME=/oracle/app/oracle/product/10.2.0.1
ORACLE_PATH=/usr/local/bin:/oracle/app/oracle/product/10.2.0.1/bin:/opt/bin:/bin:/usr/bin:/usr/ccs/bin
ORACLE_SID=META4T
ORACLE_TERM=dtterm
ORA_CSM_MODE=line
ORA_NLS10=/oracle/app/oracle/product/10.2.0.1/nls/data
PATH=/usr/local/bin:/oracle/app/oracle/product/10.2.0.1/bin:/usr/local/bin:/usr/openwin/bin:/usr/bin:/usr/sbin:/etc:/usr/ccs/bin:/usr/ucb:
PWD=/oracle/app/oracle/product/10.2.0.1/network/admin
SHELL=/bin/ksh
TERM=vt100
TMPDIR=/var/tmp
TNS_ADMIN=/oracle/app/oracle/product/10.2.0.1/network/admin
TZ=GMT+3
_=/usr/bin/env
Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #323486 is a reply to message #322902] Wed, 28 May 2008 10:23 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

i think that is a configuration problem

i saw at sqlnet.log this
Fatal NI connect error 12560, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/app/oracle/product/10.2.0.1/bin/oracle)(ARGV0=oracleMETA4T)(ARGS='(DESCRIPTIOYES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=sqlplus)(HOST=e3000-9)(USER=oracle))))

  VERSION INFORMATION:
        TNS for Solaris: Version 10.2.0.4.0 - Production
        Oracle Bequeath NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production
        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production
  Time: 28-MAY-2008 12:11:55
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12560
    TNS-12560: TNS:protocol adapter error
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 8
    nt OS err code: 


at listener.log
bash-2.05$ cat listener.log 

TNSLSNR for Solaris: Version 10.2.0.4.0 - Production on 28-MAY-2008 12:10:41

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

System parameter file is /oracle/app/oracle/product/10.2.0.1/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/10.2.0.1/network/log/listener.log
Trace information written to /oracle/app/oracle/product/10.2.0.1/network/trace/listener.trc
Trace level is currently 0

Started with pid=2005
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=e3000-9)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
28-MAY-2008 12:10:41 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=e3000-9)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
28-MAY-2008 12:10:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=e3000-9)(USER=oracle))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * services * 0
WARNING: Subscription for node down event still pending
28-MAY-2008 12:11:08 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=e3000-9)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
bash-2.05$ 


what can it be that WARNING?



my listener.ora
META4T =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= TCP)(Host=e3000-9)(Port= 1528))
  )

SID_LIST_META4T =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME= META4T)
      (ORACLE_HOME= /oracle/app/oracle/product/10.2.0.1)
      (SID_NAME = META4T)
    )
  )
LOG_DIRECTORY_META4T= /oracle/app/oracle/product/10.2.0.1/network/log


TNSNAMES
META4T = (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=e3000-9)(PORT=1528))
                (CONNECT_DATA=(SID=META4T))
            )




do anyone hae an idea?
Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #323492 is a reply to message #322902] Wed, 28 May 2008 10:34 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Why is HOST value NULL?

By the way, SQL*Net is NOT required to start database.
Simply put, you have NOT followed Installation Guide for your OS.
An error of omission is most likely.
Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #323497 is a reply to message #322902] Wed, 28 May 2008 10:39 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>Listener completed notification to CRS on start
Is/was this system ever a member of Real Application Cluster?

Why are both ports 1521 & & 1528 appearing in your posts?

Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #323499 is a reply to message #323492] Wed, 28 May 2008 10:47 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

anacedent wrote on Wed, 28 May 2008 10:34
>Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Why is HOST value NULL?

By the way, SQL*Net is NOT required to start database.
Simply put, you have NOT followed Installation Guide for your OS.
An error of omission is most likely.



you are wrong my friend, i followed and i have it at my side (printed)
note (in oracle 8 the same db works perfectly
Step 24:
If needed copy the SQL*Net files like (listener.ora,tnsnames.ora etc)  to the new location (when no TNS_ADMIN env. Parameter is used) 

$ cp $OLD_ORACLE_HOME/network/admin/*.ora /network/admin 



and

Step 26: 
Copy configuration files from the ORACLE_HOME of the database being upgraded  to the new Oracle Database 10g ORACLE_HOME: 


2 notes:
1.- when said configuration files i think is not initsid.ora file, btw i tried without the net configuration files (listener/tnsnames/sqlnet) but was the same
2.- i saw the same like you at

[code]
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Why is HOST value NULL?
[/note]

[Updated on: Wed, 28 May 2008 10:48]

Report message to a moderator

Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #323503 is a reply to message #323497] Wed, 28 May 2008 10:52 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

anacedent wrote on Wed, 28 May 2008 10:39
>Listener completed notification to CRS on start
Is/was this system ever a member of Real Application Cluster?

Why are both ports 1521 & & 1528 appearing in your posts?




i don´t know why
btw is the 2nd time i do this task with the same database
the first worked perfectly and i don´t know why now it don´t work fine...

btw it was not a part of a RAC
BUT in the future i ll do with a rac database
now i am trying with a 10gb db (a toy db Wink)
Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #323545 is a reply to message #323499] Wed, 28 May 2008 14:00 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
thorin666 wrote on Wed, 28 May 2008 11:47

note (in oracle 8 the same db works perfectly
Step 24:
If needed copy the SQL*Net files like (listener.ora,tnsnames.ora etc)  to the new location (when no TNS_ADMIN env. Parameter is used) 

$ cp $OLD_ORACLE_HOME/network/admin/*.ora /network/admin 





Bad idea here.
SQL*Net changed a whole lot from 8 to 10g. You cannot just copy tnsnames and listener.ora files from one version to another. Where are these instructions from?
And what do you mean in oracle 8 the same db works perfectly? A database is only one version at a time.
Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #323546 is a reply to message #323545] Wed, 28 May 2008 14:09 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

joy_division wrote on Wed, 28 May 2008 14:00
thorin666 wrote on Wed, 28 May 2008 11:47

note (in oracle 8 the same db works perfectly
Step 24:
If needed copy the SQL*Net files like (listener.ora,tnsnames.ora etc)  to the new location (when no TNS_ADMIN env. Parameter is used) 

$ cp $OLD_ORACLE_HOME/network/admin/*.ora /network/admin 





Bad idea here.
SQL*Net changed a whole lot from 8 to 10g. You cannot just copy tnsnames and listener.ora files from one version to another. Where are these instructions from?
And what do you mean in oracle 8 the same db works perfectly? A database is only one version at a time.


These notes are from Oracle
Note:316889.1 Type: BULLETIN
Last Revision Date: 22-APR-2008 Status: PUBLISHED

and i mean that database was originally 8 and is working fine
now i am trying to login into 10 to follow the upgrade process
and i cant login into oracle10 that´s why i can do that in oracle8 is working fine
Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #323552 is a reply to message #322902] Wed, 28 May 2008 15:32 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
Since we seem to be out of ideas, I have a suggestion which may be the equivalent to giving chicken soup to a dead man.
It won't hurt & just might help.

You'll need 2 windows/OS processes; one logged on a root & the other as user "oracle" (or who ever owns the Oracle s/w.

as the "oracle" user do the following 2 commands [no more & no less]
env | sort
sqlplus


Now from the process running root do
ps -ef | grep sqlplus
to determine the Solaris process ID (PID) of the process about to log into Oracle

As root issue the next 2 commands:
script capture.log
truss -p <pid> ; where "<pid>" is the actual PID displayed by ps -ef

Now back in the Oracle window at the username prompt do;

/ as sysdba
exit

Back in the ROOT process, issue a Ctl-D to terminate the capture.log file.

Use CUT & PASTE to post here the output from the Oracle session & the contents of the capture.log file.
Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #323553 is a reply to message #323552] Wed, 28 May 2008 15:45 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Here is it Very Happy
e3000-9# cat capture.log
Script started on Wed 28 May 2008 05:42:25 PM GMT
e3000-9# truss -p 2447
read(0, 0xFFFFFFFF7CCC4AD8, 1024) (sleeping...)
read(0, " /   a s   s y s d b a\n", 1024)       = 12
brk(0x1001B8DF0)                                = 0
brk(0x1001C0DF0)                                = 0
open(".", O_RDONLY|O_LARGEFILE)                 = 7
fstat(7, 0xFFFFFFFF7FFF83C0)                    = 0
close(7)                                        = 0
open("./..", O_RDONLY|O_NDELAY|O_LARGEFILE)     = 7
fstat(7, 0xFFFFFFFF7FFF83C0)                    = 0
getdents(7, 0xFFFFFFFF7FFF5C98, 8192)           = 112
close(7)                                        = 0
open("./../..", O_RDONLY|O_NDELAY|O_LARGEFILE)  = 7
fstat(7, 0xFFFFFFFF7FFF83C0)                    = 0
getdents(7, 0xFFFFFFFF7FFF5C98, 8192)           = 72
close(7)                                        = 0
open("./../../..", O_RDONLY|O_NDELAY|O_LARGEFILE) = 7
fstat(7, 0xFFFFFFFF7FFF83C0)                    = 0
getdents(7, 0xFFFFFFFF7FFF5C98, 8192)           = 2160
close(7)                                        = 0
open("./../../../..", O_RDONLY|O_NDELAY|O_LARGEFILE) = 7
fstat(7, 0xFFFFFFFF7FFF83C0)                    = 0
close(7)                                        = 0
lstat("/export/home/oracle", 0xFFFFFFFF7CCC31C0) = 0
brk(0x1001C0DF0)                                = 0
brk(0x1001C4DF0)                                = 0
access("/oracle/app/oracle/product/10.2.0.1/network/admin/sqlnet.ora", 0) Err#2 
ENOENT
access("/oracle/app/oracle/product/10.2.0.1/network/admin/sqlnet.ora", 0) Err#2 
ENOENT
access("/export/home/oracle/.sqlnet.ora", 0)    Err#2 ENOENT
getpid()                                        = 2447 [2431]
access("/export/home/oracle/cli_2447.trc", 0)   Err#2 ENOENT
access("/oracle/app/oracle/product/10.2.0.1/network/admin/sqlnet.ora", 0) Err#2 
ENOENT
access("/oracle/app/oracle/product/10.2.0.1/network/admin/sqlnet.ora", 0) Err#2 
ENOENT
access("/oracle/app/oracle/product/10.2.0.1/network/admin/intchg.ora", 0) Err#2 
ENOENT
access("/var/opt/oracle/intchg.ora", 0)         Err#2 ENOENT
access("/oracle/app/oracle/product/10.2.0.1/network/admin/intchg.ora", 0) Err#2 
ENOENT
access("/oracle/app/oracle/product/10.2.0.1/network/admin/tnsnav.ora", 0) Err#2 
ENOENT
access("/var/opt/oracle/tnsnav.ora", 0)         Err#2 ENOENT
access("/oracle/app/oracle/product/10.2.0.1/network/admin/tnsnav.ora", 0) Err#2 
ENOENT
open("/proc/self/psinfo", O_RDONLY)             = 7
read(7, "\b\0C4 H\0\0\001\0\0\t8F".., 416)      = 416
close(7)                                        = 0
uname(0xFFFFFFFF7EEFA148)                       = 1
getuid()                                        = 704 [704]
open("/var/run/name_service_door", O_RDONLY)    = 7
fcntl(7, F_SETFD, 0x00000001)                   = 0
door_info(7, 0xFFFFFFFF7CCC3630)                = 0
door_call(7, 0xFFFFFFFF7FFF8238)                = 0
getrlimit(RLIMIT_NOFILE, 0xFFFFFFFF7FFF82D0)    = 0
brk(0x1001C4DF0)                                = 0
brk(0x1001C8DF0)                                = 0
brk(0x1001C8DF0)                                = 0
brk(0x1001CCDF0)                                = 0
brk(0x1001CCDF0)                                = 0
brk(0x1001D0DF0)                                = 0
brk(0x1001D0DF0)                                = 0
brk(0x1001D4DF0)                                = 0
so_socket(PF_INET, SOCK_DGRAM, IPPROTO_IP, "", 1) = 8
bind(8, 0x1001D4600, 16, 3)                     = 0
getsockname(8, 0xFFFFFFFF7FFF79F4, 0xFFFFFFFF7FFF7A3C, 1) = 0
getpeername(8, 0xFFFFFFFF7FFF79F4, 0xFFFFFFFF7FFF7A3C, 1) Err#134 ENOTCONN
getsockopt(8, SOL_SOCKET, SO_SNDBUF, 0xFFFFFFFF7FFF7B6C, 0xFFFFFFFF7FFF7B7C, 1) 
= 0
getsockopt(8, SOL_SOCKET, SO_RCVBUF, 0xFFFFFFFF7FFF7B6C, 0xFFFFFFFF7FFF7B7C, 1) 
= 0
fcntl(8, F_SETFD, 0x00000001)                   = 0
ioctl(8, FIONBIO, 0xFFFFFFFF7FFF7BBC)           = 0
brk(0x1001D4DF0)                                = 0
brk(0x1001D8DF0)                                = 0
sigaction(SIGCLD, 0x00000000, 0xFFFFFFFF7FFF6220) = 0
sigprocmask(SIG_SETMASK, 0xFFFFFFFF7C61D500, 0xFFFFFFFF7FFF6060) = 0
sigprocmask(SIG_SETMASK, 0xFFFFFFFF7FFF604C, 0x00000000) = 0
sigaction(SIGCLD, 0xFFFFFFFF7FFF5EF0, 0xFFFFFFFF7FFF60B8) = 0
sigprocmask(SIG_SETMASK, 0xFFFFFFFF7C61D500, 0xFFFFFFFF7FFF6060) = 0
sigprocmask(SIG_SETMASK, 0xFFFFFFFF7FFF604C, 0x00000000) = 0
pipe()                                          = 9 [10]
pipe()                                          = 11 [12]
fork1()                                         = 2457
lwp_schedctl(SC_STATE|SC_PREEMPT, 0, 0xFFFFFFFF7FFF6018) = 0
sigprocmask(SIG_SETMASK, 0xFFFFFFFF7C61D500, 0xFFFFFFFF7FFF6060) = 0
sigprocmask(SIG_SETMASK, 0xFFFFFFFF7FFF604C, 0x00000000) = 0
sigaction(SIGPIPE, 0xFFFFFFFF7FFF5EF0, 0xFFFFFFFF7FFF60B8) = 0
sigprocmask(SIG_SETMASK, 0xFFFFFFFF7C61D500, 0xFFFFFFFF7FFF6060) = 0
sigprocmask(SIG_SETMASK, 0xFFFFFFFF7FFF604C, 0x00000000) = 0
close(9)                                        = 0
close(12)                                       = 0
read(11, " N T P 8   0\n", 64)                  = 7
close(11)                                       = 0
close(10)                                       = 0
getpid()                                        = 2447 [2431]
open("/export/home/oracle/sqlnet.log", O_WRONLY|O_APPEND|O_CREAT, 0666) = 9
lseek(9, 0, SEEK_END)                           = 22222
fcntl(9, F_SETFD, 0x00000001)                   = 0
fstat(9, 0xFFFFFFFF7FFF7CC0)                    = 0
fchmod(9, 0100640)                              = 0
lseek(9, 0, SEEK_CUR)                           = 22222
fstat(9, 0xFFFFFFFF7FFF6C60)                    = 0
brk(0x1001D8DF0)                                = 0
brk(0x1001DCDF0)                                = 0
fstat(9, 0xFFFFFFFF7FFF6B30)                    = 0
ioctl(9, TCGETA, 0xFFFFFFFF7FFF6B9C)            Err#25 ENOTTY
lseek(9, 0, SEEK_CUR)                           = 22222
lseek(9, 0, SEEK_CUR)                           = 22222
lseek(9, 0, SEEK_CUR)                           = 22222
lseek(9, 0, SEEK_CUR)                           = 22222
lseek(9, 0, SEEK_CUR)                           = 22222
lseek(9, 0, SEEK_CUR)                           = 22222
lseek(9, 0, SEEK_CUR)                           = 22222
open("/oracle/app/oracle/product/10.2.0.1/network/mesg/tnsus.msb", O_RDONLY) = 1
0
fcntl(10, F_SETFD, 0x00000001)                  = 0
lseek(10, 0, SEEK_SET)                          = 0
read(10, "1513 "011303\t\t\0\0\0\0".., 256)     = 256
lseek(10, 512, SEEK_SET)                        = 512
read(10, " 19B\0\0\0\0\0\0\0\0\0\0".., 512)     = 512
lseek(10, 1024, SEEK_SET)                       = 1024
read(10, "\0\t\012\01A\0 &\0 -\0 F".., 172)     = 172
lseek(10, 40448, SEEK_SET)                      = 40448
read(10, "\010 106\0\0\0 h 107\0\0".., 512)     = 512
lseek(9, 0, SEEK_CUR)                           = 22222
write(9, "\n\n * * * * * * * * * *".., 750)     = 750
lseek(9, 0, SEEK_CUR)                           = 22972
lseek(9, 0, SEEK_CUR)                           = 22972
lseek(9, 0, SEEK_CUR)                           = 22972
lseek(10, 15360, SEEK_SET)                      = 15360
read(10, "\0\v020F\0\0\0 J0210\0\0".., 512)     = 512
lseek(9, 0, SEEK_CUR)                           = 22972
write(9, "         n s   s e c o n".., 93)      = 93
lseek(9, 0, SEEK_CUR)                           = 23065
lseek(9, 0, SEEK_CUR)                           = 23065
close(8)                                        = 0
open("/oracle/app/oracle/product/10.2.0.1/rdbms/mesg/oraus.msb", O_RDONLY) = 8
fcntl(8, F_SETFD, 0x00000001)                   = 0
lseek(8, 0, SEEK_SET)                           = 0
read(8, "1513 "011303\t\t\0\0\0\0".., 256)      = 256
lseek(8, 512, SEEK_SET)                         = 512
read(8, "1A Q 5 C [ V uE085FC9480".., 512)      = 512
lseek(8, 1536, SEEK_SET)                        = 1536
read(8, "1A `1A m1A {1A921A9A1AF5".., 512)      = 512
lseek(8, 232960, SEEK_SET)                      = 232960
read(8, "\011 1\r\0\0\0 n 10E\0\0".., 512)      = 512
close(8)                                        = 0
lseek(4, 512, SEEK_SET)                         = 512
read(4, "17A5\0\0\0\0\0\0\0\0\0\0".., 512)      = 512
lseek(4, 1024, SEEK_SET)                        = 1024
read(4, "\016\0 *\0 R\0 h\081\09E".., 512)      = 512
lseek(4, 5120, SEEK_SET)                        = 5120
read(4, "\0\r\0E9\0\0\0 V\0EA\0\0".., 512)      = 512
write(1, " E R R O R :\n", 7)                   = 7
write(1, " O R A - 1 2 5 6 0 :   T".., 38)      = 38
write(1, "\n", 1)                               = 1
write(1, "\n", 1)                               = 1
lseek(4, 512, SEEK_SET)                         = 512
read(4, "17A5\0\0\0\0\0\0\0\0\0\0".., 512)      = 512
lseek(4, 1024, SEEK_SET)                        = 1024
read(4, "\016\0 *\0 R\0 h\081\09E".., 512)      = 512
lseek(4, 4608, SEEK_SET)                        = 4608
read(4, "\00F\0A0\0\0\0 b\0A1\0\0".., 512)      = 512
write(1, " E n t e r   u s e r - n".., 17)      = 17
read(0, 0xFFFFFFFF7CCC4AD8, 1024) (sleeping...)
read(0, " e x i t\n", 1024)                     = 5
lseek(4, 512, SEEK_SET)                         = 512
read(4, "17A5\0\0\0\0\0\0\0\0\0\0".., 512)      = 512
lseek(4, 1024, SEEK_SET)                        = 1024
read(4, "\016\0 *\0 R\0 h\081\09E".., 512)      = 512
lseek(4, 5120, SEEK_SET)                        = 5120
read(4, "\0\r\0E9\0\0\0 V\0EA\0\0".., 512)      = 512
write(1, " E n t e r   p a s s w o".., 16)      = 16
ioctl(0, TCGETA, 0xFFFFFFFF7FFFF10C)            = 0
ioctl(0, TCGETS, 0xFFFFFFFF7FFFF1DC)            = 0
ioctl(0, TCSETSF, 0xFFFFFFFF7FFFF1DC)           = 0
read(0, 0x1001C71E0, 2500)      (sleeping...)
read(0, 0x1001C71E0, 2500)                      = 0
write(1, "\n", 1)                               = 1
ioctl(0, TCGETA, 0xFFFFFFFF7FFFF13C)            = 0
ioctl(0, TCSETSW, 0xFFFFFFFF7EE92190)           = 0
lstat(".", 0xFFFFFFFF7FFF84F0)                  = 0
lstat("/export/home/oracle", 0xFFFFFFFF7FFF84F0) = 0
getuid()                                        = 704 [704]
door_info(7, 0xFFFFFFFF7FFF8268)                = 0
door_call(7, 0xFFFFFFFF7FFF8238)                = 0
so_socket(PF_INET, SOCK_DGRAM, IPPROTO_IP, "", 1) = 8
bind(8, 0x1001D31F0, 16, 3)                     = 0
getsockname(8, 0xFFFFFFFF7FFF79F4, 0xFFFFFFFF7FFF7A3C, 1) = 0
getpeername(8, 0xFFFFFFFF7FFF79F4, 0xFFFFFFFF7FFF7A3C, 1) Err#134 ENOTCONN
getsockopt(8, SOL_SOCKET, SO_SNDBUF, 0xFFFFFFFF7FFF7B6C, 0xFFFFFFFF7FFF7B7C, 1) 
= 0
getsockopt(8, SOL_SOCKET, SO_RCVBUF, 0xFFFFFFFF7FFF7B6C, 0xFFFFFFFF7FFF7B7C, 1) 
= 0
fcntl(8, F_SETFD, 0x00000001)                   = 0
ioctl(8, FIONBIO, 0xFFFFFFFF7FFF7BBC)           = 0
pipe()                                          = 11 [12]
pipe()                                          = 13 [14]
fork1()                                         = 2458
lwp_schedctl(SC_STATE|SC_PREEMPT, 0, 0xFFFFFFFF7FFF6018) = 0
close(11)                                       = 0
close(14)                                       = 0
read(13, " N T P 8   0\n", 64)                  = 7
close(13)                                       = 0
close(12)                                       = 0
getpid()                                        = 2447 [2431]
lseek(9, 0, SEEK_CUR)                           = 23065
lseek(9, 0, SEEK_CUR)                           = 23065
lseek(9, 0, SEEK_CUR)                           = 23065
lseek(9, 0, SEEK_CUR)                           = 23065
lseek(9, 0, SEEK_CUR)                           = 23065
lseek(9, 0, SEEK_CUR)                           = 23065
lseek(9, 0, SEEK_CUR)                           = 23065
lseek(9, 0, SEEK_CUR)                           = 23065
lseek(9, 0, SEEK_CUR)                           = 23065
write(9, "         n t   s e c o n".., 793)     = 793
lseek(9, 0, SEEK_CUR)                           = 23858
lseek(9, 0, SEEK_CUR)                           = 23858
lseek(9, 0, SEEK_CUR)                           = 23858
lseek(9, 0, SEEK_CUR)                           = 23858
write(9, "         n s   s e c o n".., 93)      = 93
lseek(9, 0, SEEK_CUR)                           = 23951
lseek(9, 0, SEEK_CUR)                           = 23951
close(8)                                        = 0
open("/oracle/app/oracle/product/10.2.0.1/rdbms/mesg/oraus.msb", O_RDONLY) = 8
fcntl(8, F_SETFD, 0x00000001)                   = 0
lseek(8, 0, SEEK_SET)                           = 0
read(8, "1513 "011303\t\t\0\0\0\0".., 256)      = 256
lseek(8, 512, SEEK_SET)                         = 512
read(8, "1A Q 5 C [ V uE085FC9480".., 512)      = 512
lseek(8, 1536, SEEK_SET)                        = 1536
read(8, "1A `1A m1A {1A921A9A1AF5".., 512)      = 512
lseek(8, 232960, SEEK_SET)                      = 232960
read(8, "\011 1\r\0\0\0 n 10E\0\0".., 512)      = 512
close(8)                                        = 0
lseek(4, 512, SEEK_SET)                         = 512
read(4, "17A5\0\0\0\0\0\0\0\0\0\0".., 512)      = 512
lseek(4, 1024, SEEK_SET)                        = 1024
read(4, "\016\0 *\0 R\0 h\081\09E".., 512)      = 512
lseek(4, 5120, SEEK_SET)                        = 5120
read(4, "\0\r\0E9\0\0\0 V\0EA\0\0".., 512)      = 512
write(1, " E R R O R :\n", 7)                   = 7
write(1, " O R A - 1 2 5 6 0 :   T".., 38)      = 38
write(1, "\n", 1)                               = 1
write(1, "\n", 1)                               = 1
lseek(4, 512, SEEK_SET)                         = 512
read(4, "17A5\0\0\0\0\0\0\0\0\0\0".., 512)      = 512
lseek(4, 1024, SEEK_SET)                        = 1024
read(4, "\016\0 *\0 R\0 h\081\09E".., 512)      = 512
lseek(4, 4608, SEEK_SET)                        = 4608
read(4, "\00F\0A0\0\0\0 b\0A1\0\0".., 512)      = 512
write(1, " E n t e r   u s e r - n".., 17)      = 17
read(0, 0xFFFFFFFF7CCC4AD8, 1024) (sleeping...)
read(0, 0xFFFFFFFF7CCC4AD8, 1024)               = 0
close(6)                                        = 0
close(5)                                        = 0
close(3)                                        = 0
close(4)                                        = 0
write(9, "         n t   s e c o n".., 51)      = 51
_exit(0)
e3000-9# ^D

script done on Wed 28 May 2008 05:43:38 PM GMT
e3000-9# 

Re: Problem upgrading 8.1.7.0 - 10.2.0.4 [message #323556 is a reply to message #322902] Wed, 28 May 2008 16:21 Go to previous message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
I don't have access to a Solaris system now days.
You might want to compare & contrast the truss output from a working instance (of the same version) against this broken install.

The following might be involved with the error.
getpeername(8, 0xFFFFFFFF7FFF79F4, 0xFFFFFFFF7FFF7A3C, 1) Err#134 ENOTCONN

If you kill or otherwise shutdown all listeners on this system, then do

netstat -a | grep -i listener
what gets returned & does sqlplus still throw error?
Previous Topic: DB parameters
Next Topic: Oracle Locale Builder : NLB Generation Error
Goto Forum:
  


Current Time: Wed Dec 07 20:18:50 CST 2016

Total time taken to generate the page: 0.11010 seconds