Just unbelievable problem with loadjava on Oracle 8.1.7 WIN2000 client and suse7.1 server

From: Alexey <neomatrix21_at_mail.ru>
Date: 6 Nov 2001 03:12:52 -0800
Message-ID: <c0d668f2.0111060312.5e47f5df@posting.google.com>

Hello, everybody entered here.
I`m in panic with my Oracle8.1.7, please help me I have nothing to do any longer...
I have such a problem with my Oracle 8.1.7:

1. Configuration: SUSe 7.1 with Oracle 8.1.7ee on server side WIn2000 with Oracle 8.1.7 client on client side I`ve been trying for about a week already to execute utility called LOADJAVA properly. I try to load some compiled java classes to server from client but I always get this f.ing error "SQL Error while connecting with oci8 driver to default database: ORA-12560" on it. That`s not so easy as you might thing... I can connect to the database using SQLPlus!!!

I created file called tnmsnames.ora for name resolving - it works I know
I even know that client reaches server`s listener that listenes on both 1521 and
2481 ports, but then it stops and droppes error.

I tried an example of helloworld in javavm/demo/demo.tar I tried following commands to load, for example, client.java:

1) standart makeit.bat in root of example helloworld
2) loadjava -t -r -v -u SCOTT/tiger -f .\client.class
3)loadjava -oci8 -r -v  -u SCOTT/tiger -f .\client.class

and so on...

I can post you tnsnames on server,client listener.ora on server and listener.log
That files you`ll see later

What has been happening to loadjava? I heard that Jserver has the other network
stack, hasn`t it? If it so than it`s just a Jserver problem,a? What is 'MODOSE' in init parameter file in database? There are so many unknown thing to me in Oracle..

PLease help me!! May be anybody had that problem too or knows what to do...

I`m eager to solve the problem - it crashes all my work!

Here are the files:

1. Clients tnsnames.ora (win2000) # TNSNAMES.ORA Network Configuration File: c:\ORACLE8.1.7\\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

ORA2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = ora2.ssl)

    )
  )

2) Servers (Suse) files:
2.1) tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/8.1.7/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

ORA2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 194.85.97.40)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = ora2.ssl)

    )
  )

2.2) listener.ora
# LISTENER.ORA Network Configuration File: /opt/oracle/product/8.1.7/network/admin/listener.ora # Generated by Oracle configuration tools.

SAVE_CONFIG_ON_STOP_LISTENER = TRUE LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )

    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 2481))
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = ora2.ssl)
(ORACLE_HOME = /opt/oracle/product/8.1.7)
(SID_NAME = ora2)

    )
  )

2.3) listener.log
THIS FILE UPDATED ONLY WITH SQLPLUS CONNECTION NOT WITH loadjava envoking

06-NOV-2001 14:43:05 *
(CONNECT_DATA=(SERVICE_NAME=ora2.ssl)(CID=(PROGRAM=C:\Oracle8.1.7\bin\SQLPLUSW.EXE)(HOST=DEVST1)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=194.85.97.41)(PORT=1174)) * establish * ora2.ssl * 406
NNC-00406: name "LISTENER_oracle" does not exist  NNC-00406: name "ora2.ssl" does not exist   NNC-00406: name "MODOSE" does not exist 06-NOV-2001 14:43:57 *
(CONNECT_DATA=(SERVICE_NAME=ora2.ssl)(CID=(PROGRAM=C:\Oracle8.1.7\bin\SQLPLUSW.EXE)(HOST=DEVST1)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=194.85.97.41)(PORT=1175)) * establish * ora2.ssl * 406
NNC-00406: name "LISTENER_oracle" does not exist  NNC-00406: name "ora2.ssl" does not exist   NNC-00406: name "MODOSE" does not exist Received on Tue Nov 06 2001 - 05:12:52 CST