Solved

Problem with Oracle Client 8.0.6

Posted on 2004-09-30
34
870 Views
Last Modified: 2013-12-12
We have a big problem with Oracle Client 8.0.6 comming with Oracle Forms 6i connecting to Oracle Server 9.2.0.5.0.
Any help????

Solve
0
Comment
Question by:Solve
  • 17
  • 9
  • 6
  • +1
34 Comments
 
LVL 12

Expert Comment

by:catchmeifuwant
Comment Utility
What problem???
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
This Oracle Client crashes trying to  connect to the server.
Other versions of client (8.1.7 and 9.2.0) work properly from the same client computer.

Solve
0
 
LVL 12

Expert Comment

by:catchmeifuwant
Comment Utility
Does it give you any error message?
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
Program Error

Plus80.exe Has generated errors and will be closed by windows.
You will need to restart the program

S
0
 
LVL 12

Expert Comment

by:catchmeifuwant
Comment Utility
Can you see the windows error log(doubt if anything can be expected out of this)..

How are you connecting to the database?Are you using sqlplus something?
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
we type:

"sqlplus scott/tiger@tmp1"

Oracle forms builder brokes in the same way.

Where to find windows error log?

Solve
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
Client computer runs Windows 2000 profesional SP4

In DrWatson log:

Exception number: C0000005 (access violation) in function kpuauthxa (67614F04)
and there is more things written, but nothing clear. Don't understand

Solve
0
 
LVL 12

Expert Comment

by:catchmeifuwant
Comment Utility
Go to StartMenu->Run->type cmd

In the command window that opens up...type your logon command

c>sqlplus scott/tiger@tmp1

If the sqlplus application aborts, the command window will stay open..and check for any error messages there
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
there is no messages in command window after abort

S.
0
 
LVL 12

Expert Comment

by:catchmeifuwant
Comment Utility
Can you copy and paste the entire command window contents
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\Oracle\Dev60\BIN>sqlplus scott/tiger@tmp1

C:\Oracle\Dev60\BIN>


SQLNET.ORA fil's contents:

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DEFAULT_DOMAIN = vidinis.lt
NAMES.DIRECTORY_PATH= (TNSNAMES)

TNSNAMES.ORA fil's contents:
TMP1.VIDINIS.LT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = srv-db-01)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = TMP1)
    )
  )
0
 
LVL 12

Expert Comment

by:catchmeifuwant
Comment Utility
i have no idea why it's failing...

try

cmd> sqlplus scott/tiger@tmp1 > xxx.txt

Lets see if it captures any message
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
xxx.txt is empty :(

s.
0
 
LVL 22

Expert Comment

by:Helena Marková
Comment Utility
It seems that it is a problem of certification:

Certify - Additional Info Oracle Database - Client Version 8.0.6 On Microsoft Windows 2000

Operating System: Microsoft Windows 2000 Version 2000
Oracle Database - Client Version 8.0.6
N/A Version N/A
Status: EMS

Product Version Note:

    * Terminal Oracle8 release

    * 8.0.6 is supported under Extended Maintenance Support.

    * To obtain Patch Sets from MetaLink, click the "Patches" button to the left.

Certification Note:

      8.0.6 client, ONLY, is certified to run with E-Business Suites and Forms 6i, on this Platform, until further notice or the desupport date for those products.

Existing patch sets:
     8.0.6.1.0,
     8.0.6.1.1,
     8.0.6.1.2,
     8.0.6.1.3,
     8.0.6.3.1

and these two are certified:

1)Operating System: Microsoft Windows 2000 Version  2000
Oracle Database - Client Version 8.1.7 (8i)
N/A Version N/A
Status: Certified

Product Version Note:

    * Terminal Oracle8i release

    * To obtain Patch Sets from MetaLink, click the "Patches" button to the left.

Certification Note:

Existing patch sets:
     8.1.7.0.1,
     8.1.7.0.2,
     8.1.7.1.1, withdrawn
     8.1.7.1.2,
     8.1.7.1.3,
     8.1.7.1.4, withdrawn
     8.1.7.1.5,
     8.1.7.2.1, Skipped
     8.1.7.2.2,
     8.1.7.2.3,
     8.1.7.2.4,
     8.1.7.2.5,
     8.1.7.3.0,
     8.1.7.4.0, withdrawn
     8.1.7.4.1,
     8.1.7.4.2 NT Patch for the Proc GUI for NON-ENGLISH USERS  

2)Operating System: Microsoft Windows 2000 Version  2000
Oracle Database - Client Version 9.2
N/A Version N/A
Status: Certified

Product Version Note:
None available for this product.

Certification Note:

Existing patch sets:
     9.2.0.2.1
     9.2.0.3.0
     9.2.0.4.0
     9.2.0.5.0
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
"Certification Note:

      8.0.6 client, ONLY, is certified to run with E-Business Suites and Forms 6i, on this Platform, until further notice or the desupport date for those products.

Existing patch sets:
     8.0.6.1.0,
     8.0.6.1.1,
     8.0.6.1.2,
     8.0.6.1.3,
     8.0.6.3.1 "

But forms 6i also don't work

s.
0
 
LVL 22

Expert Comment

by:Helena Marková
Comment Utility
I understand it as "E-Business Suites with Forms 6i" ...
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Author Comment

by:Solve
Comment Utility
we have no ideas anymore what to do ......
how to work?

S
0
 
LVL 22

Expert Comment

by:Helena Marková
Comment Utility
"Other versions of client (8.1.7 and 9.2.0) work properly from the same client computer." - so why you want to use there 8.0.6 client ?
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
Oracle forms6i use client 8.0.6 ?!

S.
0
 
LVL 22

Expert Comment

by:Helena Marková
Comment Utility
No, this line from the on-line help "About"

PL/SQL Verzia 8.0.6.3.0 (Produkcia)

only means that PL/SQL version embeded in Forms is 8.0.6  - some new features of Oracle databases 8i or 9i don't work - but it does't tell nothing about Oracle database CLIENT !
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
Does any anybody know if Forms 6i can work with Oracle Client version 8.1.7 installed into the same Oracle home ?

s.
0
 
LVL 22

Expert Comment

by:Helena Marková
Comment Utility
It works I have the same configuration.
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
ok, will try to install the latest client.

s.
0
 
LVL 22

Expert Comment

by:Helena Marková
Comment Utility
I recommend you at first istall a client and after that install Forms and Reports.
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
Thanks for recommendation.
But one more question - doesn't forms install their own client?

s.
0
 
LVL 22

Expert Comment

by:Helena Marková
Comment Utility
I don't know. There are some *.dll which can be older than those coming with Oracle 8i client and that is why Oracle recommends to install Forms and Reports after installing Oracle 8i client.
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
We've just tryed to install Oracle Forms 6i and Oracle Client 8.1.7 into the same Oracle home.
Oracle Forms 6i can not be installed into Oracle client 8.1.7 home and vice versa.

s.
0
 
LVL 22

Expert Comment

by:Helena Marková
Comment Utility
It seems to me very strange because I have this - Oracle 8i client and Forms6i (patch12) and Reports6i and also Designer6i in the same oracle home:
C:\OraNT\
with subdirectories:
BIN
...
FORMS60
GRAPH60
...
REPORT60
...

on Microsoft Windows 2000
5.00.1295
Service Pack 3
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
probably you have Oracle Client 8.0.6, because it comes with Oracle Forms 6i
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
Mabe it is a problem in Oracle server?

s.
0
 
LVL 22

Expert Comment

by:Helena Marková
Comment Utility
Huh, I don't know ... I know only that at first it was Oracle client installed and Forms at the end.
But if it cannot work so I think that you must install to the separate homes.
0
 
LVL 1

Author Comment

by:Solve
Comment Utility
We found a solution of that problem at leats in metalink:

Note:260893.1 Unicode character sets in the Oracle database

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=260893.1&p_database_id=NOT

Problem was that Oracle client prior to 9.0 doesn't support database characterset AL32UTF8.
Instead UTF8 should be used.

S.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
Comment Utility
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now