Onames

B

Babo

Member³
Hello,
just DL the 5.1.2.682. Using against 8174.
While it's working good with local tnsnames it's completely hangs if i 'm trying to use it with Onames.
At the same time sqlplus works fine.

I can connect, but simple select * from dual - hangs saying "initilising".

in "about" menu it somehow points ( ot doesn't list though) the $O_H/anetworkk/admin/tnsnames.ora file.

Please advise.
 
Update:

After some hanging it returns with : ORA-12154, TNS unable to resolve the service name.

At the same time i can browse objetcs and see there source code. Also "sessions" works.

so , kinda , sum up: main window and sql window are not working

Trace files on client side looks ... hmmm see here:
(1640) [06-MAY-2003 15:17:35:617] nsprecv: packet dump
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 01 66 00 00 06 00 00 00 |.f......|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 00 00 06 02 01 01 00 01 |........|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 19 00 00 00 07 3A 4F 72 |.....:Or|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 61 63 6C 65 38 69 20 45 |acle8i.E|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 6E 74 65 72 70 72 69 73 |nterpris|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 65 20 45 64 69 74 69 6F |e.Editio|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 6E 20 52 65 6C 65 61 73 |n.Releas|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 65 20 38 2E 31 2E 37 2E |e.8.1.7.|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 34 2E 30 20 2D 20 50 72 |4.0.-.Pr|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 6F 64 75 63 74 69 6F 6E |oduction|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 00 00 06 02 01 01 01 01 |........|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 01 19 00 01 01 01 01 00 |........|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 07 25 50 4C 2F 53 51 4C |.%PL/SQL|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 20 52 65 6C 65 61 73 65 |.Release|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 20 38 2E 31 2E 37 2E 34 |.8.1.7.4|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 2E 30 20 2D 20 50 72 6F |.0.-.Pro|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 64 75 63 74 69 6F 6E 00 |duction.|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 00 06 02 01 01 01 02 01 |........|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 19 00 01 01 01 01 00 07 |........|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 19 43 4F 52 45 09 38 2E |.CORE.8.|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 31 2E 37 2E 30 2E 30 09 |1.7.0.0.|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 50 72 6F 64 75 63 74 69 |Producti|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 6F 6E 00 00 06 02 01 01 |on......|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 01 03 01 19 00 01 01 01 |........|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 01 00 07 2F 54 4E 53 20 |.../TNS.|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 66 6F 72 20 53 6F 6C 61 |for.Sola|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 72 69 73 3A 20 56 65 72 |ris:.Ver|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 73 69 6F 6E 20 38 2E 31 |sion.8.1|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 2E 37 2E 34 2E 30 20 2D |.7.4.0.-|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 20 50 72 6F 64 75 63 74 |.Product|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 69 6F 6E 00 00 06 02 01 |ion.....|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 01 01 04 01 19 00 01 01 |........|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 01 01 00 07 25 4E 4C 53 |....%NLS|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 52 54 4C 20 56 65 72 73 |RTL.Vers|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 69 6F 6E 20 33 2E 34 2E |ion.3.4.|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 31 2E 30 2E 30 20 2D 20 |1.0.0.-.|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 50 72 6F 64 75 63 74 69 |Producti|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 6F 6E 00 00 04 01 05 02 |on......|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 05 7B 00 00 01 02 00 03 |.{......|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 00 60 00 00 00 00 00 00 |.`......|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 00 00 00 00 10 00 01 01 |........|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 00 00 00 00 19 4F 52 41 |.....ORA|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 2D 30 31 34 30 33 3A 20 |-01403:.|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 6E 6F 20 64 61 74 61 20 |no.data.|
(1640) [06-MAY-2003 15:17:35:617] nsprecv: 66 6F 75 6E 64 0A |found. |
(1640) [06-MAY-2003 15:17:35:617] nsprecv: normal exit
 
This sounds like Oracle Bug 2048583:

Reconnecting from a session in 9i net client on Windows fails with ORA-12154

fix:

Install the 9.0.1.2 rdbms patchset
or
Do not use ONAMES for name resolution (use tnsnames.ora file instead)

------------------
Marco Kalter
Allround Automations
 
I see. I have 9.2.0 .. let me work on this.
thank you for pointing out

Originally posted by mkalter:
This sounds like Oracle Bug 2048583:

Reconnecting from a session in 9i net client on Windows fails with ORA-12154

fix:

Install the 9.0.1.2 rdbms patchset
or
Do not use ONAMES for name resolution (use tnsnames.ora file instead)
Click to expand...
 
Ok. here are some findings:

SQL*Plus: Release 9.2.0.1.0 - Production on Wed May 7 16:22:28 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

SQL> connect system/****@fwts.world
Connected.
SQL> select * from dual;
D
-
X
=------- end test ---------------
---- in this part i checked that this is not the bug you refered to anymore.
---------------------------------

pl/sql developer:

multi connection - fails.
dual connection - fails
single connection - works fine

all with Onames.
with TNSnames both progs are working fine.

Please update.
 
Looks like bug 2048583 to me. Any secondary connection fails with ORA-12154 when using ONAMES.

------------------
Marco Kalter
Allround Automations
 
Marko,
I would not be so sure about this. And this is why ( please read carefully ):
in sqlplus :
SQL*Plus: Release 9.2.0.1.0 - Production on Wed May 7 16:22:28 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:


-- At this stage i already opened the
-- connection to 8174 db.
-- now i'm reconnecting again
SQL> connect system/****@fwts.world
Connected.
SQL> select * from dual;
D
-
X


I also started several sqlplus sessions - no problem at all.

Only Developer has this problem.

Please advise.
 
SQL*Plus always makes just one connection. This works okay from PL/SQL Developer as well (Single Session mode). As soon as it makes a secondary connection, the ORA-12154 bug surfaces.

------------------
Marco Kalter
Allround Automations
 
Marco,
I'm talking to Ora Support. Looks like it is a bug in both versions : 9.0.2 and 9.2.0.
I'll post the reuslts.
have a good weekend
 
Originally posted by mkalter:
SQL*Plus always makes just one connection. This works okay from PL/SQL Developer as well (Single Session mode). As soon as it makes a secondary connection, the ORA-12154 bug surfaces.
Click to expand...

Marco,
What you are saying is not actually what i could monitor. I _was_ able to esteblish the secondary connection and thus it is eliminate the bug you were referring.
But this is only part of story.
Second part is - it started working. Why and when i don't know. Probably my Oname guy change smth in server? settings. I'll go hunt him..
Here is the sqlnet.ora i'm using currently.
# SQLNET.ORA Network Configuration File: C:\oracle\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = WORLD
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (ONAMES)
NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.YYY.137.121)(PORT = 1575))
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.YYY.137.118)(PORT = 1575))
)
 
Markus,
I think it has smth to do with sqlnet config.
I'll have to talk to my Onames admin, because it started working.. One of this weird problems i guess.
Anyway, just want ed to let you know that IT IS WORKING.

One strange thing is - the "initialization" stage it takes allot of time - about 5-7 secs before it returns the set. but i have to look into this better.

that's it for now.
thank you
Andrew.
 
Thanks for the info. I will try to setup a similar configuration and verify the performance issue.

------------------
Marco Kalter
Allround Automations
 
Originally posted by mkalter:
Thanks for the info. I will try to setup a similar configuration and verify the performance issue.
Click to expand...

Don't waist your time . this is smth local, i guess. At least i'll have to find out what was wrong before and what has been changed.
thnx

[This message has been edited by Babo (edited 21 May 2003).]
 
Markus,
I spent some time with OSupport and looked into this in different situations. Here are my findings:

Good part:
- it is working
- i can repeat the problem again and again

Bad part
- sqlnet logs showing NOTHING except "waiting for input"
this mean that i can't send you any logs ( unless there are --verbose" options in developer itself ? ) so you can take a look.
all i can give you is a description when it not working.. i mean working baaaad.
So here it is:
client 9201, server 8174, onames 9.2.0.1 on NT/Solaris ( i have 2 servers )

opening connection to any database - fast enough - 1-2 secs.
select * from dual - saying "initializing" for 10-15 secs, than returns result of query in less than a sec .
repeating the same query - with the speed of the lightning - no problem. Any other query ( no db links ) - no problem.

Connecting to different server - same story again - looooooooong "init" stage and than working fine.

I also checked sqlplus - no problem with anything.

if i switch to "single mode" - flag "i'm happy"=TRUE.
smile.gif


so the location of problem:
pl/sql developer 512.682, client 90201 , server 8174, onames 9201. not single session. First query takes forever to execute.

BTW, if i switching to any other application - i can't get pl/sql back - it is hanging.

Please update.
 
You must log in or register to reply here.

Similar threads

J
  • Discussion Discussion
PLSQL Dev v9 vs v8 behaviour changes
Replies
7
Views
5K
Marco Kalter
Marco Kalter
Back
Top