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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 6 Nov 2001 14:02:31 +0100
Message-ID: <tufnlkn12cgn86@corp.supernews.com>

"Alexey" <neomatrix21_at_mail.ru> wrote in message news:c0d668f2.0111060312.5e47f5df_at_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\SQLPLU SW.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\SQLPLU SW.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

Your listener.ora is incorrect.
The upper half should read
 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)
       )
     )

   )

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Tue Nov 06 2001 - 07:02:31 CST