listener fails after upgrade to 10.2.0.5

Hello,

I'm facing a problem with listener, I'm unable to execute lsnrctl start

I've upgraded oracle from 10.2.0.2 to 10.2.0.5 with package downloaded from service.sap.com (no errors during patching) and I cannot start listener

Sys op = SuSE11SP1 X86_64

I have an error:

Starting /oracle/DEV/102_64/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed

TNS-12560: TNS:protocol adapter error

TNS-00507: Connection closed

Linux Error: 29: Illegal seek

Best regards,

Michal

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (3)

OSS solved a problem. There was a incorrect library in sap kernel which cause a erorrs.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello Michal,

Did you just update you SAP DB Kernel to the latest version to solve the issue? I have the same

Best Regards,

Thomas

No, making an SAP Kernel upgrade doesn't help you.

I found that you have libclntsh.so.10.1 under /usr/sap/DEV/SYS/exe/run,

which could be the cause of this case.

Please do the following to resolve the problem:

- go to /usr/sap/DEV/SYS/exe/run folder

- mv libclntsh.so.10.1 libclntsh.so.10.1.old

Afterwards the listener picked the correct client library from

/oracle/P60/102_64/lib and started properly.

Best Regards,

Michal

Hi,

mmmh, I don't have this file into the /usr/sap/<SID>/SYS/exe/run directory.

Did you update also the Oracle 10.2 client? (that is the directory /oracle/PSD/102_64?) or just upgrade Oracle with the Oracle Patch Set 10.2.0.5?

br,

Thomas

Edited by: Thomas Knodt on Jul 15, 2011 11:59 AM

Hi,

Ok SOLVED too..... ouf

The file old lib file libclntsh.so.10.1 was situated in the directory "/oracle/client/10x_64/instantclient". This directory is mentionned into my LD_LIBRARY_PATH environement variable.

To other people with the same issue, check the old library file "libclntsh.so.10.1" in the following directories:

- echo $LD_LIBRARY_PATH

- /usr/sap/PSD/SYS/exe/run

- /oracle/client/10x_64/instantclient

Thanks a lot,

Thomas Knodt

Well,

the file belongs there.

But the instantclient directory does not belong to the library path for orasid, just for sidadm!

Check the note which describes the installation of the instantclient and watch

esp. out for the different environment settings for the users orasid and sidadm.

Volker

I have an error:

Starting /oracle/DEV/102_64/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek

It seems there is some issue with your listener.ora or tnsnames.ora file. Please check if it is refering to correct hostname and port.Also there are many other ways described in oracle metalink also.Please check at oracle metalink as well.

Thanks..

Mohit

Edited by: mohit gupta on Apr 4, 2011 11:10 AM

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

> I've upgraded oracle from 10.2.0.2 to 10.2.0.5 with package downloaded from service.sap.com (no errors during patching) and I cannot start listener

> Sys op = SuSE11SP1 X86_64

> I have an error:

> Starting /oracle/DEV/102_64/bin/tnslsnr: please wait...

> TNS-12537: TNS:connection closed

> TNS-12560: TNS:protocol adapter error

> TNS-00507: Connection closed

> Linux Error: 29: Illegal seek

It seems there went something wrong during the upgrade.

Did you follow the upgrade guide and made all necessary steps (like copying tnsnames.ora and changing ORACLE_HOME in the files etc.?

Markus

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Markus,

I've follow the readme file from 10.2.0.5 upgrade package.

I saw tnsnames.ora file didn't change during the upgrade.

What do you mean 'change ORACLE_HOME in the files'? I've started upgrade form sidadm user so all environment variables were ok.

As I see in readme file in point

10.6.1 Upgrading a Release 10.2 Database using Oracle Database Upgrade Assistant

"After you install the patch set, you must perform the following steps on every database associated with the upgraded Oracle home"

#Log in as the Oracle software owner user.

#Set the values for the environment variables $ORACLE_HOME, $ORACLE_SID and $PATH.

#For single-instance installations, if you are using Automatic Storage Management, start the Automatic Storage Management instance.

lsnrctl start

#dbua

So I can't start listener so I can't finish these steps with dbua..

Best regards,

Michal

Hi!

Stop the listener

Search for listener processes still running

rotate the listener log.

Be shore you start the listener with ora<SID> user.

If it still doesn't work, please upload:

- listener.ora

- output from 'lsnrctl status'

- the startup part from listener log.

Regards

Audun

DBA

Hi,

Error 29 mostly indicates that components are not relinked after upgrading.

Generate the trace of the listener with "truss" or any available utility and post it. Try to relink all oracle executable again.

Set LD_LIBRARY_PATH to include $ORACLE_HOME/lib and try relink all.

Regards

Vinod

 I've started upgrade form sidadm user ...

I am quite sure your upgrade guide will tell you that in Unix/Linux you have to start it from orasid user.

my mistake, of course I've started upgrade with orasid user:)

Try to use $ $ORACLE_HOME/bin/relink all

https://service.sap.com/sap/support/notes/841728

Best Regards,

Aleh

Hi,

Thanks for all advices....but for now no success.

listener.log:

TNSLSNR for Linux: Version 10.2.0.5.0 - Production on 04-APR-2011 18:27:28

System parameter file is /oracle/DEV/102_64/network/admin/listener.ora

Log messages written to /oracle/DEV/102_64/network/log/listener.log

Trace information written to /oracle/DEV/102_64/network/trace/listener.trc

Trace level is currently 0

Started with pid=43571

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=DEV.WORLD)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=DEV)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ceres.frc.feroco.pl)(PORT=1527)))

ceres:oradev 56> lsnrctl status

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 04-APR-2011 18:39:11

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DEV.WORLD))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DEV))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=ceres)(PORT=1527))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

ceres:oradev 50> lsnrctl start

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 04-APR-2011 18:52:40

Starting /oracle/DEV/102_64/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed

TNS-12560: TNS:protocol adapter error

TNS-00507: Connection closed

Linux Error: 29: Illegal seek

in /etc/hosts i have entry:

127.0.0.1 localhost.localdomain localhost

relink all done, all ok, listener won't start

maybe there is a problem with too old client libraries?

Best regards,

Michal

Hello

Can you please post the contents of /etc/hosts file?

Regards

Could you please show the contents of your listener.ora file, as already requested in an other reply above?

And besides that, what is the output of:

ps -ef | grep -i listener

Not sure about it; but I have seen similar problems when there was confusion about the listener name. It may or may not be the default of listener.

regards

This is strange because files listener.ora, tnsnames, sqlnet didn't change between 10.2.0.2 and upgraded 10.2.0.5

ceres:~ # more /etc/hosts

special IPv6 addresses

::1 localhost ipv6-localhost ipv6-loopback

127.0.0.1 localhost.localdomain localhost

root 54638 54605 0 09:39 pts/0 00:00:00 grep -i listener

ceres:~ # more /oracle/DEV/102_64/network/admin/listener.ora

################

Filename......: listener.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DEV.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DEV)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = ceres)

(PORT = 1527)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = ADMIN

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = DEV)

(ORACLE_HOME = /oracle/DEV/102_64)

)

Hi!

Please upload the file /oracle/DEV/102_64/network/admin/listener.ora and sqlnet.ora

Normally trouble due to starting the listener are misconfigurations in these two files, or wrong environment in the session you try to start the listener.

Regards

Audun

DBA

You need to have an entry in /etc/hosts file with:

<ip-address of lovalhost> <nodemane> <full qualilfied nodename>

to resolve the name of the name ceres

Regards

Audun

entries from sqlnet.ora:

ceres:~ # more /oracle/DEV/102_64/network/admin/sqlnet.ora

################

Filename......: sqlnet.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/SQLNET.ORA#4 $

################

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

05.01.06 set to default

#TCP.NODELAY=YES

05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

What is confusing me:

In your post from Apr 4, 2011 8:21 PM, your listener.log file is telling us that you started the listener.

Nevertheless the lsnrctl status says it is not running.

Could you please look at the log file again, and check if there are messages about stopping or crashing?

(And no, please do not post hundreds of lines here. Look for the relevant lines!)

regards

Do you have DNS setup?

Please post the output of following commands:

#hostname
#hostname -f

Also post the contents of the file tnsnames.ora.

Regards

I know that listener.log says that listener is started despite of lsnrctl status. That is why I posted here:)

No messages of stop or crash inside.

entries in tnsname.ora:

DEV.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = ceres)

(PORT = 1527)

)

(CONNECT_DATA =

(SID = DEV)

(GLOBAL_NAME = DEV.WORLD)

)

hostname -f shows:

ceres.frc.companyname.pl

Ping to ceres.frc.companyname.pl

Check the IP address from the ping response.

Try using the IP address of the system as a value for HOST parameter( HOST = ceres) in the listener.ora and tnsnames.ora files.

regards

Edited by: VijayIngle on Apr 5, 2011 12:23 PM

Hi,

ceres:oradev 56> lsnrctl status and ceres:oradev 50> lsnrctl start

whats this ? which machine has the problem. Please confirm this.

TNS-00511: No listener

Linux Error: 111: Connection refused

For this Error ...

There is possibly an incorrect IP Address specified for the host in the /etc/hosts file

please execute the following steps:

1. Correct the mapping in the /etc/hosts file by adding/correcting the IP address and/or hostname reference for the Unix/Linux Server (both long and short host names).

For example:

Add or edit the /etc/hosts file to include a valid entry for the Server:

192.168.101.110 pg.uk.hp.com pg

2. Check that the localhost loopback name and address are correct (both long and short host names).

An example of a correct localhost entry would be as follows:

127.0.0.1 localhost.localdomain localhost

3. Remember to save the /etc/hosts file and then start the listener.

There is possibly an incorrect IP Address specified for the host in the /etc/hosts file

Regards

Vinod

Michael

has there been any change in /etc/hosts after upgrade?

if the pre-upgrade listener was running with the sam /etc/host configuration, then this is not the issue.

can you confirm what other changes you have done for the upgrade ?

please activate listener trace for further analysis.

Thanks

Hello,

Yes we have DNS. ceres is virtual host maybe here is the problem with 10.2.0.5 version?

No, I didn't change /etc/hosts file and any other of listener, tnsnames, sqlora as i wrote before.

10.2.0.2 was working well, so why 10.2.0.5 need any new entries in hosts file?

I activate listener trace in leevel support, I don't see inside of it any errors, last entry is:

nsglldsec: entry

One more thought about your /etc/hosts file:

special IPv6 addresses
::1 localhost ipv6-localhost ipv6-loopback

Are you really making use of IPv6?

If you don't, you better remove these ipv6-localhost entries.

We had some trouble, as long as they were in.

regards

Hi Michal,

Even though there is no change in upgrade, once again make sure ALL ENVIRONMENT VARIABLES.

Please check the current user permissions to hosts file.

IPv6 is supported from 11g. in 10g some time in past it reported that dual configuration will give some problems because of ONS.

Verify the user attempting to start the TNS Listener process has read permissions on the /etc/hosts file, and that the /etc/hosts file contains the localhost entry .

If it is non RAC environment you can try adding parameter SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF =OFF in listener.ora file.

If the OS is configured with both IPv4 and IPv6 then make sure that following entries exists in /etc/hosts file.

127.0.0.1 localhost.localdomain localhost

::1 localhost6.localdomain localhost6

Please post the listener trace if possible.

Regards

Vinod

Hello,

I made a lot of tests without any success.

now I have in /etc/hosts

special IPv6 addresses

#::1 localhost ipv6-localhost ipv6-loopback

127.0.0.1 localhost.localdomain localhost

192.168.11.212 ceres.frc.feroco.pl ceres

oradev user have rights to read /etc/hosts

also param SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF in listener.ora doesn't work,

environment od oradev user is ok.

listener trace is too long to paste it here. What expression I have to search in trace?

Edited by: Michal Sarna on Apr 6, 2011 11:13 AM

also I tried with changed ( HOST = ceres) param ceres to IP in listener and tnsnames, lsnrctl throw the same error

Edited by: Michal Sarna on Apr 6, 2011 11:14 AM

Add following line at the start of /etc/hosts as shown below:

127.0.0.1 ceres

127.0.0.1 localhost.localdomain localhost

192.168.11.212 ceres.frc.feroco.pl ceres


> hi
> 
> Add following line at the start of /etc/hosts as shown below:
> 
> 127.0.0.1 ceres
> 127.0.0.1 localhost.localdomain localhost
> 192.168.11.212 ceres.frc.feroco.pl ceres

also doesn't work

Hi,

check notes 284602.1 and 315720.1 on http://metalink.oracle.com

Access for SAP Customers: https://service.sap.com/sap/support/notes/758563

Best Regards,

Aleh

Aleh,

nice try, however:

No access to metalink for SAP customers currently; have a look at that note yourself!

Or this thread:

Joe

Yes, you are right, I had old version on local pc. Time is changing :(.

This alternative article http://mpoojari.wordpress.com/2010/06/24/tns-linux-error-29-illegal-seek/ can be used as possible solution.

Best Regards,

Aleh

I think you can attach the trace for analysis. Look for relevant information which can guide users to help you

Regards

Vinod

many tests, no luck.

Tommorow I will try to instal ora_home from scratch. first 10.2.0.1 then upgrade to 10.2.0.5, maybe it will be working

for now, listener,trc

TNSLSNR for Linux: Version 10.2.0.5.0 - Production on 09-APR-2011 21:09:45

....

[09-APR-2011 21:09:45:187] nsnainit: NS Connection version: 313

[09-APR-2011 21:09:45:187] nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd

[09-APR-2011 21:09:45:187] nsnainit: "or" info flags: 0xd Translations follow:

native service(s) is (are) wanted

NA disabled remotely for this connection

NA services unavailable on both processes - negotiation not needed

[09-APR-2011 21:09:45:187] nsnainit: "or" info flags: 0xd Translations follow:

native service(s) is (are) wanted

NA disabled remotely for this connection

NA services unavailable on both processes - negotiation not needed

"and" info flags: 0xd Translations follow:

native service(s) is (are) wanted

NA disabled remotely for this connection

NA services unavailable on both processes - negotiation not needed

try

[09-APR-2011 21:09:45:191] snlinGetAddrInfo: entry

[09-APR-2011 21:09:45:191] snlinGetAddrInfo: Invalid IP address string ceres ??

[09-APR-2011 21:09:45:191] snlinFreeAddrInfo: entry

[09-APR-2011 21:09:45:191] snlinFreeAddrInfo: exit

[09-APR-2011 21:09:45:191] snlinGetAddrInfo: exit

[09-APR-2011 21:09:45:191] nttbnd2addr: looking up IP addr for host: ceres ??

[09-APR-2011 21:09:45:191] nsgllsn: Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ceres.frc.feroco.pl)(PORT=1527)))

[09-APR-2011 21:09:45:191] nsevreg: begin registration process for 4

[09-APR-2011 21:09:45:191] nsevreg: sgt=0, evn=1, evt[2]=0x0

[09-APR-2011 21:09:45:191] nsevreg: begin notification process for 4

[09-APR-2011 21:09:45:191] nsevreg: rdm=0, sgt=0, evt[0]=0x1, [1]=0x1, [2]=0x0, nrg=0

[09-APR-2011 21:09:45:191] nsevreg: registering for 0x1

[09-APR-2011 21:09:45:191] nsglhins: entry

[09-APR-2011 21:09:45:191] nsglhins: exit

[09-APR-2011 21:09:45:191] nladget: entry

[09-APR-2011 21:09:45:192] nladget: exit

[09-APR-2011 21:09:45:192] nladtrm: entry

[09-APR-2011 21:09:45:192] nladtrm: exit

[09-APR-2011 21:09:45:192] nsglldsec: entry <- last entry of file

Edited by: Michal Sarna on Apr 9, 2011 9:33 PM

ceres:/oracle/DEV/102_64/network/admin # nslookup ceres

Server: 192.168.11.204

Address: 192.168.11.204#53

Name: ceres.frc.feroco.pl

Address: 192.168.11.212

Edited by: Michal Sarna on Apr 9, 2011 10:14 PM

Dear ..

Its an IP and Host name resolution issue.

Anyway just try this and let me know..

Move the listener.ora file to listerner.ora.bkp.

Start the database

start the listener with command "lsnrctl start"

Post the results here ..lets fix it

Regards

Vinod

Hello,

I moved listener. Listener also fail, throws the same error.

ceres:oradev 52> lsnrctl start

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 12-APR-2011 09:55:43

Starting /oracle/DEV/102_64/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed

TNS-12560: TNS:protocol adapter error

TNS-00507: Connection closed

Linux Error: 29: Illegal seek

ceres:oradev 51> lsnrctl status

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 12-APR-2011 09:55:27

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

ceres:/oracle/DEV/102_64/network/log # more listener.log

TNSLSNR for Linux: Version 10.2.0.5.0 - Production on 12-APR-2011 09:54:17

Log messages written to /oracle/DEV/102_64/network/log/listener.log

Trace information written to /oracle/DEV/102_64/network/trace/listener.trc

Trace level is currently 0

Started with pid=21633

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ceres.frc.feroco.pl)(POR

T=1521)))

only port in listsener.log changed to default 1521.

ps -ef |grep tns shows nothing

Please post the contents of /etc/nsswitch.conf

I want to see the entry

hosts: files dns

Regards

Vinod

Based on all reply.

You said nothing is changed from 10.2.0.2 at OS level. Listener was working before upgrade.

You upgraded to 10.2.0.5 .. you have the problem .. the change is Oracle libraries .. so I doubt on network libraries linking

Are you sure relink all executed with no errors... upgrade didn't had any errors

Based on your reply Hostname IP network config everything is correct you tried setting all parameters on listsner and sqlnet.ora file .. you tried also tcp.validnode_checking = no in sqlnet.ora file......

Why dont you try to run netca to regenerate the listener and see how it works....

most of the time running 'relink all' from the /bin/ directory of the ORACLE_HOME will resolve this kind of issue.

lets try to run netca to regenerate the listener

Vinod

ehh,

thanks for helping Vinod

as for now file /etc/nsswitch.conf inculde entry hosts: files dns

netca says all successfull but:

Oracle Net Services Configuration:

Configuring Listener:LISTENER

Listener configuration complete.

Oracle Net Listener Startup:

Running Listener Control:

/oracle/DEV/102_64/bin/lsnrctl start LISTENER

Listener Control complete.

Listener start failed. Listener may already be running.

Oracle Net Services configuration successful. The exit code is 0

There isn't any other listener visible on ps -ef

also relink all logfile is free of errors.

I will check upgrade logfiles one more time.

Try to create new listener LISTENER_NEW and let me know the status..

Regards

Vinod

LISTENER_NEW also failed with

Listener start failed. Listener may already be running.

Oracle Net Services configuration successful. The exit code is 0

Another idea; it's just a guess, in the absence of useful logfiles.

And just in case you didn't check already:

The IP port needed for the listener could be blocked by another process.

For example by a previously started and hanging listener.

Linux commands lsof or netstat could help.

Or if anything else fails, a reboot could be worth a try.

regards


> Another idea; it's just a guess, in the absence of useful logfiles.
> And just in case you didn't check already:
> The IP port needed for the listener could be blocked by another process.
> For example by a previously started and hanging listener.
> Linux commands lsof or netstat could help.
> Or if anything else fails, a reboot could be worth a try.
> 
> regards

Vinod,

I checked upgrade logfiles - no errors.

I did reboot.

No previounsly started or hanged listeners found.

lsof and netstat show nothing for 1527, tns, listener

tcp.validnode_checking = no in sqlnet.ora any luck with this??

Please post the trace for LISTENER_NEW....


> tcp.validnode_checking = no in sqlnet.ora   any luck with this??

no luck, still the same error

trace for LISTENER_NEW....please....

TNSLSNR for Linux: Version 10.2.0.5.0 - Production on 13-APR-2011 13:30:31

[13-APR-2011 13:30:31:462] --- TRACE CONFIGURATION INFORMATION FOLLOWS ---

[13-APR-2011 13:30:31:462] New trace stream is /oracle/DEV/102_64/network/trace/listener.trc

[13-APR-2011 13:30:31:462] New trace level is 6

[13-APR-2011 13:30:31:462] --- TRACE CONFIGURATION INFORMATION ENDS ---

[13-APR-2011 13:30:31:462] --- PARAMETER SOURCE INFORMATION FOLLOWS ---

[13-APR-2011 13:30:31:462] Attempted load of system pfile source /oracle/DEV/102_64/network/admin/listener.ora

[13-APR-2011 13:30:31:462] Parameter source loaded successfully

[13-APR-2011 13:30:31:462]

[13-APR-2011 13:30:31:462] Attempted load of command line source

[13-APR-2011 13:30:31:462] Parameter source was not loaded

[13-APR-2011 13:30:31:462]

[13-APR-2011 13:30:31:462] -> PARAMETER TABLE LOAD RESULTS FOLLOW <-

[13-APR-2011 13:30:31:462] Successful parameter table load

[13-APR-2011 13:30:31:462] -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-

[13-APR-2011 13:30:31:462] ADMIN_RESTRICTIONS_LISTENER = on

[13-APR-2011 13:30:31:462] TRACE_LEVEL_LISTENER = ADMIN

[13-APR-2011 13:30:31:462] LISTENER_NEW = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = DEV)) (ADDRESS = (PROTOCOL = TCP)(HOST = ceres)(PORT = 1527))))

[13-APR-2011 13:30:31:462] STARTUP_WAIT_TIME_LISTENER = 0

[13-APR-2011 13:30:31:462] LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = DEV.WORLD)) (ADDRESS = (PROTOCOL = IPC)(KEY = DEV)) (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = ceres)(PORT = 1527)))

[13-APR-2011 13:30:31:462] INBOUND_CONNECT_TIMEOUT_LISTENER = 120

[13-APR-2011 13:30:31:462] CONNECT_TIMEOUT_LISTENER = 10

[13-APR-2011 13:30:31:462] SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER = OFF

[13-APR-2011 13:30:31:462] SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = DEV) (ORACLE_HOME = /oracle/DEV/102_64)))

[13-APR-2011 13:30:31:462] --- PARAMETER SOURCE INFORMATION ENDS ---

[13-APR-2011 13:30:31:462] --- LOG CONFIGURATION INFORMATION FOLLOWS ---

[13-APR-2011 13:30:31:462] Log stream will be "/oracle/DEV/102_64/network/log/listener.log"

[13-APR-2011 13:30:31:462] Log stream validation requested

[13-APR-2011 13:30:31:462] Log stream is valid

[13-APR-2011 13:30:31:462] --- LOG CONFIGURATION INFORMATION ENDS ---

[13-APR-2011 13:30:31:462] nlstdipi: entry

[13-APR-2011 13:30:31:462] nlstdipi: exit

[13-APR-2011 13:30:31:462] nsglldprm: Resolved "INBOUND_CONNECT_TIMEOUT_LISTENER" to: 120

[13-APR-2011 13:30:31:462] nsglldprm: Resolved "STARTUP_WAIT_TIME_LISTENER" to: 0

[13-APR-2011 13:30:31:462] nsglldprm: LocalOSauth enabled

[13-APR-2011 13:30:31:462] snsgblini: exit

[13-APR-2011 13:30:31:462] nsinherit: doing connect handshake...

[13-APR-2011 13:30:31:462] nsc2addr: (ADDRESS=(PROTOCOL=beq))

[13-APR-2011 13:30:31:462] nlpcaini: entry

[13-APR-2011 13:30:31:462] nlpcaini: No process parameters set

[13-APR-2011 13:30:31:462] nlpcaini: exit

[13-APR-2011 13:30:31:463] nsinh_hoff: inheriting the connection...

[13-APR-2011 13:30:31:463] nsmal: 1144 bytes at 0x699150

[13-APR-2011 13:30:31:463] nsmal: 1992 bytes at 0x6995d0

[13-APR-2011 13:30:31:463] nsmal: 168 bytes at 0x699f20

[13-APR-2011 13:30:31:463] nsopen: opening transport...

[13-APR-2011 13:30:31:463] ntpcon: entry

[13-APR-2011 13:30:31:463] ntpcon: toc = 4

[13-APR-2011 13:30:31:463] ntpcon: NT layer IPC connection has been established.

[13-APR-2011 13:30:31:463] ntpcon: exit

[13-APR-2011 13:30:31:463] nsopen: transport is open

[13-APR-2011 13:30:31:463] nsoptions: lcl[0]=0x0, lcl[1]=0x10000000, gbl[0]=0x0, gbl[1]=0x0, cha=0x0

[13-APR-2011 13:30:31:463] nsoptions: lcl[0]=0xf4ffe9ff, lcl[1]=0x10000000, gbl[0]=0x7ebf, gbl[1]=0x0

[13-APR-2011 13:30:31:463] nsnainit: inherit

[13-APR-2011 13:30:31:463] nsnasvnainfo: NA disabled for this connection

[13-APR-2011 13:30:31:463] ntpctl: entry

[13-APR-2011 13:30:31:463] ntpctl: exit

[13-APR-2011 13:30:31:463] nainit: entry

[13-APR-2011 13:30:31:463] nagblini: entry

[13-APR-2011 13:30:31:463] nau_gin: entry

[13-APR-2011 13:30:31:463] nau_gparams: entry

[13-APR-2011 13:30:31:463] nam_gbp: Reading parameter "sqlnet.authentication_required" from parameter file

[13-APR-2011 13:30:31:463] nam_gbp: Parameter not found

[13-APR-2011 13:30:31:463] nau_gparams: Using default value "FALSE

[13-APR-2011 13:30:31:463] nau_gslf: entry

[13-APR-2011 13:30:31:463] nam_gic: entry

[13-APR-2011 13:30:31:463] nam_gic: Counting # of items in "sqlnet.authentication_services" parameter

[13-APR-2011 13:30:31:463] nam_gic: Parameter not found

[13-APR-2011 13:30:31:463] nam_gic: Found 0 items

[13-APR-2011 13:30:31:463] nam_gic: exit

[13-APR-2011 13:30:31:463] nau_gslf: Using default value "all available adapters"

[13-APR-2011 13:30:31:463] nauss_set_state: entry

[13-APR-2011 13:30:31:463] nauss_set_state: exit

[13-APR-2011 13:30:31:463] nau_gslf: exit

[13-APR-2011 13:30:31:463] nau_gparams: exit

[13-APR-2011 13:30:31:463] nau_gin: exit

[13-APR-2011 13:30:31:463] nagblini: exit

[13-APR-2011 13:30:31:463] na_saveprot: entry

[13-APR-2011 13:30:31:463] na_saveprot: exit

[13-APR-2011 13:30:31:463] nacomin: entry

[13-APR-2011 13:30:31:463] nas_init: entry

[13-APR-2011 13:30:31:463] nas_init: exit

[13-APR-2011 13:30:31:463] nau_ini: entry

[13-APR-2011 13:30:31:463] naugcp_get_connect_parameters: entry

[13-APR-2011 13:30:31:463] nauss_set_state: entry

[13-APR-2011 13:30:31:463] nauss_set_state: exit

[13-APR-2011 13:30:31:463] naugcp_get_connect_parameters: exit

[13-APR-2011 13:30:31:463] nau_gettab: entry

[13-APR-2011 13:30:31:463] nau_gettab: exit

[13-APR-2011 13:30:31:463] nau_sini: entry

[13-APR-2011 13:30:31:463] nau_sini: exit

[13-APR-2011 13:30:31:463] nau_ini: exit

[13-APR-2011 13:30:31:463] naeeinit: entry

[13-APR-2011 13:30:31:463] nam_gbp: Reading parameter "SQLNET.FIPS_140" from parameter file

[13-APR-2011 13:30:31:463] nam_gbp: Parameter not found

[13-APR-2011 13:30:31:463] nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_SERVER" from parameter file

[13-APR-2011 13:30:31:463] nam_gnsp: Parameter not found

[13-APR-2011 13:30:31:463] naequad: Using default value "ACCEPTED"

[13-APR-2011 13:30:31:463] nam_gic: entry

[13-APR-2011 13:30:31:463] nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_SERVER" parameter

[13-APR-2011 13:30:31:463] nam_gic: Parameter not found

[13-APR-2011 13:30:31:463] nam_gic: exit

[13-APR-2011 13:30:31:463] naesno: Using default value "all available algorithms"

[13-APR-2011 13:30:31:463] naeshow: entry

[13-APR-2011 13:30:31:463] naeshow: exit

[13-APR-2011 13:30:31:463] naeeinit: exit

[13-APR-2011 13:30:31:463] naecinit: entry

[13-APR-2011 13:30:31:463] nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_SERVER" from parameter file

[13-APR-2011 13:30:31:463] nam_gnsp: Parameter not found

[13-APR-2011 13:30:31:463] naequad: Using default value "ACCEPTED"

[13-APR-2011 13:30:31:463] nam_gic: entry

[13-APR-2011 13:30:31:463] nam_gic: Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER" parameter

[13-APR-2011 13:30:31:463] nam_gic: Parameter not found

[13-APR-2011 13:30:31:463] nam_gic: exit

[13-APR-2011 13:30:31:463] naesno: Using default value "all available algorithms"

[13-APR-2011 13:30:31:463] naeshow: entry

[13-APR-2011 13:30:31:463] naeshow: exit

[13-APR-2011 13:30:31:463] naecinit: exit

[13-APR-2011 13:30:31:463] nadisc: entry

[13-APR-2011 13:30:31:463] nacomtm: entry

[13-APR-2011 13:30:31:463] nacompd: entry

[13-APR-2011 13:30:31:463] nacompd: exit

[13-APR-2011 13:30:31:463] nacompd: entry

[13-APR-2011 13:30:31:463] nacompd: exit

[13-APR-2011 13:30:31:463] nacomtm: exit

[13-APR-2011 13:30:31:463] nas_dis: entry

[13-APR-2011 13:30:31:463] nas_dis: exit

[13-APR-2011 13:30:31:463] nau_dis: entry

[13-APR-2011 13:30:31:463] nau_dis: exit

[13-APR-2011 13:30:31:463] naeetrm: entry

[13-APR-2011 13:30:31:463] naeetrm: exit

[13-APR-2011 13:30:31:463] naectrm: entry

[13-APR-2011 13:30:31:464] naectrm: exit

[13-APR-2011 13:30:31:464] nagbltrm: entry

[13-APR-2011 13:30:31:464] nau_gtm: entry

[13-APR-2011 13:30:31:464] nau_gtm: exit

[13-APR-2011 13:30:31:464] nagbltrm: exit

[13-APR-2011 13:30:31:464] nadisc: exit

[13-APR-2011 13:30:31:464] nainit: exit

[13-APR-2011 13:30:31:464] nsnainit: NS Connection version: 313

[13-APR-2011 13:30:31:464] nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd

[13-APR-2011 13:30:31:464] nsnainit: "or" info flags: 0xd Translations follow:

native service(s) is (are) wanted

NA disabled remotely for this connection

NA services unavailable on both processes - negotiation not needed

[13-APR-2011 13:30:31:464] nsnainit: "or" info flags: 0xd Translations follow:

native service(s) is (are) wanted

NA disabled remotely for this connection

NA services unavailable on both processes - negotiation not needed

"and" info flags: 0xd Translations follow:

native service(s) is (are) wanted

NA disabled remotely for this connection

NA services unavailable on both processes - negotiation not needed

[13-APR-2011 13:30:31:464] nsopen: global context check-in (to slot 0) complete

[13-APR-2011 13:30:31:464] nsopen: lcl[0]=0xf4ffe9ff, lcl[1]=0x10000000, gbl[0]=0x7ebf, gbl[1]=0x0, tdu=4096, sdu=2048

[13-APR-2011 13:30:31:464] nsdo: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2

[13-APR-2011 13:30:31:464] nsdo: rank=64, nsctxrnk=0

[13-APR-2011 13:30:31:464] nsdo: nsctx: state=7, flg=0x4000, mvd=0

[13-APR-2011 13:30:31:464] nsmal: 168 bytes at 0x69b750

[13-APR-2011 13:30:31:464] nsmal: 168 bytes at 0x69aff0

[13-APR-2011 13:30:31:464] nsdo: nsctxrnk=0

[13-APR-2011 13:30:31:464] nsdo: cid=0, opcode=68, *bl=0, *what=8, uflgs=0x0, cflgs=0x3

[13-APR-2011 13:30:31:464] nsdo: rank=64, nsctxrnk=0

[13-APR-2011 13:30:31:464] nsdo: nsctx:

state=14, flg=0x4004, mvd=0

[13-APR-2011 13:30:31:464] nsdo: gtn=10, gtc=10, ptn=10, ptc=2011

[13-APR-2011 13:30:31:464] nscon: doing connect handshake...

[13-APR-2011 13:30:31:464] nscon: recving a packet

[13-APR-2011 13:30:31:464] nsprecv: reading from transport...

[13-APR-2011 13:30:31:464] ntprd: entry

[13-APR-2011 13:30:31:464] ntprd: exit

[13-APR-2011 13:30:31:464] nsprecv: 175 bytes from transport

[13-APR-2011 13:30:31:464] nsprecv: tlen=175, plen=175, type=1

[13-APR-2011 13:30:31:464] nscon: got NSPTCN packet

[13-APR-2011 13:30:31:464] nsconneg: vsn=313, lov=300, opt=0x0, sdu=2048, tdu=4096, ntc=0x4f98

[13-APR-2011 13:30:31:464] nsconneg: vsn=313, gbl=0x0, sdu=2048, tdu=4096

[13-APR-2011 13:30:31:464] nsmal: 117 bytes at 0x69b0a0

[13-APR-2011 13:30:31:464] nscon: got 117 bytes connect data

[13-APR-2011 13:30:31:464] nsmfr: 117 bytes at 0x69b0a0

[13-APR-2011 13:30:31:464] nscon: discarding connect data (117 bytes)

[13-APR-2011 13:30:31:464] nsdo: nsctxrnk=0

[13-APR-2011 13:30:31:464] nsinh_hoff: connection inherited

[13-APR-2011 13:30:31:464] nsinherit: connected

[13-APR-2011 13:30:31:464] nsglma: entry

[13-APR-2011 13:30:31:464] nsglma: Listener's pid=8311

[13-APR-2011 13:30:31:464] nladini: entry

[13-APR-2011 13:30:31:464] nladini: exit

[13-APR-2011 13:30:31:464] nladget: entry

[13-APR-2011 13:30:31:464] nladget: exit

[13-APR-2011 13:30:31:464] nsgllsn: LSNDSC==>(ADDRESS=(PROTOCOL=IPC)(KEY=DEV.WORLD))

[13-APR-2011 13:30:31:464] nsglhcrt: entry

[13-APR-2011 13:30:31:464] nsglhcrt: exit

[13-APR-2011 13:30:31:464] nsglbgetRSPidx: entry

[13-APR-2011 13:30:31:464] nladini: entry

[13-APR-2011 13:30:31:464] nladini: exit

[13-APR-2011 13:30:31:464] nladget: entry

[13-APR-2011 13:30:31:464] nladget: exit

[13-APR-2011 13:30:31:464] nsglbn2i: entry

[13-APR-2011 13:30:31:464] nsglbn2i: exit

[13-APR-2011 13:30:31:465] nladtrm: entry

[13-APR-2011 13:30:31:465] nladtrm: exit

[13-APR-2011 13:30:31:465] nsglbgetRSPidx: returning ecode=0

[13-APR-2011 13:30:31:465] nsglbgetRSPidx: exit

[13-APR-2011 13:30:31:465] nsc2addr: (ADDRESS=(PROTOCOL=IPC)(KEY=DEV.WORLD))

[13-APR-2011 13:30:31:465] sntuscrt: entry

[13-APR-2011 13:30:31:465] sntuscrt: exit

[13-APR-2011 13:30:31:465] ntusb2adr: entry

[13-APR-2011 13:30:31:465] ntusb2adr: KEY = DEV.WORLD

[13-APR-2011 13:30:31:465] ntusb2adr: exit

[13-APR-2011 13:30:31:465] nsmal: 1144 bytes at 0x69df90

[13-APR-2011 13:30:31:465] nsmal: 1992 bytes at 0x69e410

[13-APR-2011 13:30:31:465] nsmal: 168 bytes at 0x69de20

[13-APR-2011 13:30:31:465] ntusconn: entry

[13-APR-2011 13:30:31:465] ntusconn: connect: operation 6

[13-APR-2011 13:30:31:465] ntuscnp: entry

[13-APR-2011 13:30:31:465] ntuscnp: exit

[13-APR-2011 13:30:31:465] ntusconn: exit

[13-APR-2011 13:30:31:465] nsopen: opening transport...

[13-APR-2011 13:30:31:465] ntusconn: entry

[13-APR-2011 13:30:31:465] ntusconn: connect: operation 2

[13-APR-2011 13:30:31:465] ntuscnp: entry

[13-APR-2011 13:30:31:465] sntusgph: entry

[13-APR-2011 13:30:31:465] sntusgph: exit

[13-APR-2011 13:30:31:465] ntus2err: entry

[13-APR-2011 13:30:31:465] ntus2err: sd=9, op=1, resnt[0]=512, resnt[1]=98, resnt[2]=0

[13-APR-2011 13:30:31:465] ntus2err: exit

[13-APR-2011 13:30:31:465] sntusgph: entry

[13-APR-2011 13:30:31:465] sntusgph: exit

[13-APR-2011 13:30:31:465] ntuscnp: exit

[13-APR-2011 13:30:31:465] ntusconn: exit

[13-APR-2011 13:30:31:465] nsopen: transport is open

[13-APR-2011 13:30:31:465] nsoptions: lcl[0]=0x0, lcl[1]=0x12003, gbl[0]=0x0, gbl[1]=0x2001, cha=0x0

[13-APR-2011 13:30:31:465] nsoptions: lcl[0]=0xf4ffe9ff, lcl[1]=0x12003, gbl[0]=0x78bf, gbl[1]=0x2001

[13-APR-2011 13:30:31:465] nsopen: global context check-in (to slot 1) complete

[13-APR-2011 13:30:31:465] nsopen: lcl[0]=0xf4ffe9ff, lcl[1]=0x12003, gbl[0]=0x78bf, gbl[1]=0x2001, tdu=32767, sdu=8192

[13-APR-2011 13:30:31:465] nsdo: cid=1, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2

[13-APR-2011 13:30:31:465] nsdo: rank=64, nsctxrnk=0

[13-APR-2011 13:30:31:465] nsdo: nsctx: state=7, flg=0x4002, mvd=0

[13-APR-2011 13:30:31:465] nsdo: nsctxrnk=0

[13-APR-2011 13:30:31:465] nsgllsn: completing partial addr: (ADDRESS=(PROTOCOL=IPC)(KEY=DEV.WORLD))

[13-APR-2011 13:30:31:465] ntusad2b: entry

[13-APR-2011 13:30:31:465] ntusad2b: exit

[13-APR-2011 13:30:31:465] nsgllsn: Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=DEV.WORLD)))

[13-APR-2011 13:30:31:465] nsevreg: begin registration process for 1

[13-APR-2011 13:30:31:465] nsevreg: sgt=0, evn=1, evt[2]=0x0

[13-APR-2011 13:30:31:465] nsevreg: begin notification process for 1

[13-APR-2011 13:30:31:465] nsevreg: rdm=0, sgt=0, evt[0]=0x1, [1]=0x1, [2]=0x0, nrg=0

[13-APR-2011 13:30:31:465] nsevreg: registering for 0x1

[13-APR-2011 13:30:31:465] nsglhins: entry

[13-APR-2011 13:30:31:465] nsglhins: exit

[13-APR-2011 13:30:31:465] nsc2addr: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))

[13-APR-2011 13:30:31:465] ntusb2adr: entry

[13-APR-2011 13:30:31:465] nsmal: 1144 bytes at 0x6a1bd0

[13-APR-2011 13:30:31:465] nsmal: 1992 bytes at 0x6a2050

[13-APR-2011 13:30:31:465] nsmal: 168 bytes at 0x6a29a0

[13-APR-2011 13:30:31:465] ntusconn: entry

[13-APR-2011 13:30:31:465] ntusconn: connect: operation 6

[13-APR-2011 13:30:31:465] ntuscnp: entry

[13-APR-2011 13:30:31:465] ntuscnp: exit

[13-APR-2011 13:30:31:465] ntusconn: exit

[13-APR-2011 13:30:31:465] nsopen: opening transport...

[13-APR-2011 13:30:31:465] ntusconn: entry

[13-APR-2011 13:30:31:465] ntusconn: connect: operation 2

[13-APR-2011 13:30:31:465] ntuscnp: entry

[13-APR-2011 13:30:31:465] sntusgph: entry

[13-APR-2011 13:30:31:465] sntusgph: exit

[13-APR-2011 13:30:31:465] ntuscnp: exit

[13-APR-2011 13:30:31:465] ntusconn: exit

[13-APR-2011 13:30:31:465] nsopen: transport is open

[13-APR-2011 13:30:31:465] nsoptions: lcl[0]=0x0, lcl[1]=0x10003, gbl[0]=0x0, gbl[1]=0x2001, cha=0x0

[13-APR-2011 13:30:31:465] nsoptions: lcl[0]=0xf4ffe9ff, lcl[1]=0x10003, gbl[0]=0x78bf, gbl[1]=0x2001

[13-APR-2011 13:30:31:465] nsopen: global context check-in (to slot 2) complete

[13-APR-2011 13:30:31:465] nsopen: lcl[0]=0xf4ffe9ff, lcl[1]=0x10003, gbl[0]=0x78bf, gbl[1]=0x2001, tdu=32767, sdu=2048

[13-APR-2011 13:30:31:465] nsdo: cid=2, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2

[13-APR-2011 13:30:31:465] nsdo: rank=64, nsctxrnk=0

[13-APR-2011 13:30:31:466] nsdo: nsctx: state=7, flg=0x4002, mvd=0

[13-APR-2011 13:30:31:466] nsdo: nsctxrnk=0

[13-APR-2011 13:30:31:466] nladget: entry

[13-APR-2011 13:30:31:466] nladget: exit

[13-APR-2011 13:30:31:466] nsgllsn: LSNDSC==>(ADDRESS=(PROTOCOL=IPC)(KEY=DEV))

[13-APR-2011 13:30:31:466] nsglhcrt: entry

[13-APR-2011 13:30:31:466] nsglhcrt: exit

[13-APR-2011 13:30:31:466] nsglbgetRSPidx: entry

[13-APR-2011 13:30:31:466] nladini: entry

[13-APR-2011 13:30:31:466] nladini: exit

[13-APR-2011 13:30:31:466] nladget: entry

[13-APR-2011 13:30:31:466] nladget: exit

[13-APR-2011 13:30:31:466] nsglbn2i: entry

[13-APR-2011 13:30:31:466] nsglbn2i: exit

[13-APR-2011 13:30:31:466] nladtrm: entry

[13-APR-2011 13:30:31:466] nladtrm: exit

[13-APR-2011 13:30:31:466] nsglbgetRSPidx: returning ecode=0

[13-APR-2011 13:30:31:466] nsglbgetRSPidx: exit

[13-APR-2011 13:30:31:466] nsc2addr: (ADDRESS=(PROTOCOL=IPC)(KEY=DEV))

[13-APR-2011 13:30:31:466] ntusb2adr: entry

[13-APR-2011 13:30:31:466] ntusb2adr: KEY = DEV

[13-APR-2011 13:30:31:466] ntusb2adr: exit

[13-APR-2011 13:30:31:466] nsmal: 1144 bytes at 0x6a4040

[13-APR-2011 13:30:31:466] nsmal: 1992 bytes at 0x6a44c0

[13-APR-2011 13:30:31:466] nsmal: 168 bytes at 0x6a3f10

[13-APR-2011 13:30:31:466] ntusconn: entry

[13-APR-2011 13:30:31:466] ntusconn: connect: operation 6

[13-APR-2011 13:30:31:466] ntuscnp: entry

[13-APR-2011 13:30:31:466] ntuscnp: exit

[13-APR-2011 13:30:31:466] ntusconn: exit

[13-APR-2011 13:30:31:466] nsopen: opening transport...

[13-APR-2011 13:30:31:466] ntusconn: entry

[13-APR-2011 13:30:31:466] ntusconn: connect: operation 2

[13-APR-2011 13:30:31:466] ntuscnp: entry

[13-APR-2011 13:30:31:466] sntusgph: entry

[13-APR-2011 13:30:31:466] sntusgph: exit

[13-APR-2011 13:30:31:466] ntus2err: entry

[13-APR-2011 13:30:31:466] ntus2err: sd=11, op=1, resnt[0]=512, resnt[1]=98, resnt[2]=0

[13-APR-2011 13:30:31:466] ntus2err: exit

[13-APR-2011 13:30:31:466] sntusgph: entry

[13-APR-2011 13:30:31:466] sntusgph: exit

[13-APR-2011 13:30:31:466] ntuscnp: exit

[13-APR-2011 13:30:31:466] ntusconn: exit

[13-APR-2011 13:30:31:466] nsopen: transport is open

[13-APR-2011 13:30:31:466] nsoptions: lcl[0]=0x0, lcl[1]=0x12003, gbl[0]=0x0, gbl[1]=0x2001, cha=0x0

[13-APR-2011 13:30:31:466] nsoptions: lcl[0]=0xf4ffe9ff, lcl[1]=0x12003, gbl[0]=0x78bf, gbl[1]=0x2001

[13-APR-2011 13:30:31:466] nsopen: global context check-in (to slot 3) complete

[13-APR-2011 13:30:31:466] nsopen: lcl[0]=0xf4ffe9ff, lcl[1]=0x12003, gbl[0]=0x78bf, gbl[1]=0x2001, tdu=32767, sdu=8192

[13-APR-2011 13:30:31:466] nsdo: cid=3, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2

[13-APR-2011 13:30:31:466] nsdo: rank=64, nsctxrnk=0

[13-APR-2011 13:30:31:466] nsdo: nsctx: state=7, flg=0x4002, mvd=0

[13-APR-2011 13:30:31:466] nsdo: nsctxrnk=0

[13-APR-2011 13:30:31:466] nsgllsn: completing partial addr: (ADDRESS=(PROTOCOL=IPC)(KEY=DEV))

[13-APR-2011 13:30:31:466] ntusad2b: entry

[13-APR-2011 13:30:31:466] ntusad2b: exit

[13-APR-2011 13:30:31:466] nsgllsn: Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=DEV)))

[13-APR-2011 13:30:31:466] nsevreg: begin registration process for 3

[13-APR-2011 13:30:31:466] nsevreg: sgt=0, evn=1, evt[2]=0x0

[13-APR-2011 13:30:31:466] nsevreg: begin notification process for 3

[13-APR-2011 13:30:31:466] nsevreg: rdm=0, sgt=0, evt[0]=0x1, [1]=0x1, [2]=0x0, nrg=0

[13-APR-2011 13:30:31:466] nsevreg: registering for 0x1

[13-APR-2011 13:30:31:466] nsglhins: entry

[13-APR-2011 13:30:31:466] nsglhins: exit

[13-APR-2011 13:30:31:466] nladget: entry

[13-APR-2011 13:30:31:466] nladget: exit

[13-APR-2011 13:30:31:466] nsgllsn: LSNDSC==>(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=ceres)(PORT=1527))

[13-APR-2011 13:30:31:466] nsglhcrt: entry

[13-APR-2011 13:30:31:466] nsglhcrt: exit

[13-APR-2011 13:30:31:466] nsglbgetRSPidx: entry

[13-APR-2011 13:30:31:466] nladini: entry

[13-APR-2011 13:30:31:466] nladini: exit

[13-APR-2011 13:30:31:466] nladget: entry

[13-APR-2011 13:30:31:466] nladget: exit

[13-APR-2011 13:30:31:466] nsglbn2i: entry

[13-APR-2011 13:30:31:466] nsglbn2i: exit

[13-APR-2011 13:30:31:466] nladtrm: entry

[13-APR-2011 13:30:31:466] nladtrm: exit

[13-APR-2011 13:30:31:466] nsglbgetRSPidx: returning ecode=0

[13-APR-2011 13:30:31:466] nsglbgetRSPidx: exit

[13-APR-2011 13:30:31:466] nsc2addr: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=ceres)(PORT=1527))

[13-APR-2011 13:30:31:466] nttbnd2addr: entry

[13-APR-2011 13:30:31:466] snlinGetAddrInfo: entry

[13-APR-2011 13:30:31:466] snlinGetAddrInfo: Invalid IP address string ceres

[13-APR-2011 13:30:31:466] snlinFreeAddrInfo: entry

[13-APR-2011 13:30:31:466] snlinFreeAddrInfo: exit

[13-APR-2011 13:30:31:466]

snlinGetAddrInfo: exit

[13-APR-2011 13:30:31:466] nttbnd2addr: looking up IP addr for host: ceres

[13-APR-2011 13:30:31:467] snlinGetAddrInfo: entry

[13-APR-2011 13:30:31:467] snlinGetAddrInfo: exit

[13-APR-2011 13:30:31:467] snlinFreeAddrInfo: entry

[13-APR-2011 13:30:31:467] snlinFreeAddrInfo: exit

[13-APR-2011 13:30:31:467] nttbnd2addr: exit

[13-APR-2011 13:30:31:467] nsmal: 1144 bytes at 0x6a8470

[13-APR-2011 13:30:31:467] nsmal: 1992 bytes at 0x6a88f0

[13-APR-2011 13:30:31:467] nsmal: 168 bytes at 0x6a7a60

[13-APR-2011 13:30:31:467] nttcon: entry

[13-APR-2011 13:30:31:467] nttcon: toc = 6

[13-APR-2011 13:30:31:467] nttcnp: entry

[13-APR-2011 13:30:31:467] nttcnp: exit

[13-APR-2011 13:30:31:467] nttcon: exit

[13-APR-2011 13:30:31:467] nsopen: opening transport...

[13-APR-2011 13:30:31:467] nttcon: entry

[13-APR-2011 13:30:31:467] nttcon: toc = 2

[13-APR-2011 13:30:31:467] nttcnp: entry

[13-APR-2011 13:30:31:467] ntvlin: entry

[13-APR-2011 13:30:31:467] ntvllt: entry

[13-APR-2011 13:30:31:467] ntvllt: tcp.validnode_checking not turned on

[13-APR-2011 13:30:31:467] ntvllt: exit

[13-APR-2011 13:30:31:467] ntvlin: exit

[13-APR-2011 13:30:31:467] nttcnp: Validnode Table IN use; err 0x0

[13-APR-2011 13:30:31:467] snlinGetAddrInfo: entry

[13-APR-2011 13:30:31:467] snlinGetAddrInfo: exit

[13-APR-2011 13:30:31:467] snlinFreeAddrInfo: entry

[13-APR-2011 13:30:31:467] snlinFreeAddrInfo: exit

[13-APR-2011 13:30:31:467] nttcnp: getting sockname

[13-APR-2011 13:30:31:467] nttcnp: getting peername

[13-APR-2011 13:30:31:467] nttcnp: exit

[13-APR-2011 13:30:31:467] snlinGetAddrInfo: entry

[13-APR-2011 13:30:31:467] snlinGetAddrInfo: exit

[13-APR-2011 13:30:31:467] snlinFreeAddrInfo: entry

[13-APR-2011 13:30:31:467] snlinFreeAddrInfo: exit

[13-APR-2011 13:30:31:467] nttcon: exit

[13-APR-2011 13:30:31:467] nsopen: transport is open

[13-APR-2011 13:30:31:467] nsoptions: lcl[0]=0x0, lcl[1]=0x12003, gbl[0]=0x0, gbl[1]=0x2001, cha=0x0

[13-APR-2011 13:30:31:467] nsoptions: lcl[0]=0xf4ffe9ff, lcl[1]=0x12003, gbl[0]=0x7ebf, gbl[1]=0x2001

[13-APR-2011 13:30:31:467] nsopen: global context check-in (to slot 4) complete

[13-APR-2011 13:30:31:467] nsopen: lcl[0]=0xf4ffe9ff, lcl[1]=0x12003, gbl[0]=0x7ebf, gbl[1]=0x2001, tdu=32767, sdu=8192

[13-APR-2011 13:30:31:467] nsdo: cid=4, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2

[13-APR-2011 13:30:31:467] nsdo: rank=64, nsctxrnk=0

[13-APR-2011 13:30:31:467] nsdo: nsctx: state=7, flg=0x4002, mvd=0

[13-APR-2011 13:30:31:467] nsdo: nsctxrnk=0

[13-APR-2011 13:30:31:467] nsgllsn: completing partial addr: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=ceres)(PORT=1527))

[13-APR-2011 13:30:31:467] nttaddr2bnd: entry

[13-APR-2011 13:30:31:467] snlinGetAddrInfo: entry

[13-APR-2011 13:30:31:467] snlinGetAddrInfo: exit

[13-APR-2011 13:30:31:467] snlinFreeAddrInfo: entry

[13-APR-2011 13:30:31:467] snlinFreeAddrInfo: exit

[13-APR-2011 13:30:31:467] nttaddr2bnd: exit

[13-APR-2011 13:30:31:467] nsgllsn: Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ceres.frc.feroco.pl)(PORT=1527)))

[13-APR-2011 13:30:31:467] nsevreg: begin registration process for 4

[13-APR-2011 13:30:31:467] nsevreg: sgt=0, evn=1, evt[2]=0x0

[13-APR-2011 13:30:31:467] nsevreg: begin notification process for 4

[13-APR-2011 13:30:31:467] nsevreg: rdm=0, sgt=0, evt[0]=0x1, [1]=0x1, [2]=0x0, nrg=0

[13-APR-2011 13:30:31:467] nsevreg: registering for 0x1

[13-APR-2011 13:30:31:467] nsglhins: entry

[13-APR-2011 13:30:31:467] nsglhins: exit

[13-APR-2011 13:30:31:467] nladget: entry

[13-APR-2011 13:30:31:467] nladget: exit

[13-APR-2011 13:30:31:467] nladtrm: entry

[13-APR-2011 13:30:31:467] nladtrm: exit

[13-APR-2011 13:30:31:467] nsglldsec: entry

Hi,

The out put

hostname -f shows:

ceres.frc.companyname.pl says hostname is ceres.frc.companyname.pl

hostname

ceres.frc.companyname.pl says hostname is ceres.frc.companyname.pl

but from the traces some time it reads "ceres" and some times "ceres.frc.companyname.pl". And it runs but crashes aftre that when registering the service. that time the error is from function "snlinGetAddrInfo: Invalid IP address string ceres".

I think you tried all possible settings for listener.ora and sqlnet.ora.

as last option you can try

1. Move all network files to backup folder ( lister.ora and sqlnet.ora )

2. Have fresh good working sqlnet.ora file from other working system

3. With netca configure new listener ( first try LISTENER and then LISTENR_XXX)

4. Use physical IP address of the machine when configuring listener

5. verify this IP at eth0 configuration

6. Now you have good sqlnet.ora and listsner.ora created from netca

7. First start listener ( lsnrctl start ) and then ( lsnrctl start LISTSNER_XXX and lsnrctl status LISTSNER_XXX ) ; try different ports

8. Once again verify TNS_ADMIN and environment variables

9. we tried all options; last option is support call or fresh upgrade or install

but the question is ; when it was working earlier why not now?? when nothing is changed....

Sorry, I was unable to fix this...

Regards

Vinod

Hi,

1. Remove LISTENER_NEW from the configuration (If it still exists)

2. Shutdown the database.

3. In user ora<sid>, browse to $ORACLE_HOME\bin

4. Issue the command "relink all" (without the quotes).

5. Start database and then listener.

Hope this helps.

Regards,

Anish

Ask a Question

Top Q&A Solution Author

User

Count