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  |
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  |
 |
BlackSwan
Messages: 26766
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 |
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 #322908 is a reply to message #322906] |
Mon, 26 May 2008 16:12 |
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 #323192 is a reply to message #322914] |
Tue, 27 May 2008 11:42 |
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 |
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 #323499 is a reply to message #323492] |
Wed, 28 May 2008 10:47 |
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 #323545 is a reply to message #323499] |
Wed, 28 May 2008 14:00 |
joy_division
Messages: 4963
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 |
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 #323553 is a reply to message #323552] |
Wed, 28 May 2008 15:45 |
thorin666
Messages: 144
Registered: March 2007
|
Senior Member |
|
|
Here is it 
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 |
|
BlackSwan
Messages: 26766
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?
|
|
|
|
Goto Forum:
Current Time: Fri Sep 06 13:57:14 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
)