Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 959
  • Last Modified:

Problem with Oracle Client 8.0.6

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
Solve
Asked:
Solve
  • 17
  • 9
  • 6
  • +1
1 Solution
 
catchmeifuwantCommented:
What problem???
0
 
SolveAuthor Commented:
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
 
catchmeifuwantCommented:
Does it give you any error message?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
SolveAuthor Commented:
Program Error

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

S
0
 
catchmeifuwantCommented:
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
 
SolveAuthor Commented:
we type:

"sqlplus scott/tiger@tmp1"

Oracle forms builder brokes in the same way.

Where to find windows error log?

Solve
0
 
SolveAuthor Commented:
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
 
catchmeifuwantCommented:
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
 
SolveAuthor Commented:
there is no messages in command window after abort

S.
0
 
catchmeifuwantCommented:
Can you copy and paste the entire command window contents
0
 
SolveAuthor Commented:
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
 
catchmeifuwantCommented:
i have no idea why it's failing...

try

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

Lets see if it captures any message
0
 
SolveAuthor Commented:
xxx.txt is empty :(

s.
0
 
Helena Markováprogrammer-analystCommented:
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
 
SolveAuthor Commented:
"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
 
Helena Markováprogrammer-analystCommented:
I understand it as "E-Business Suites with Forms 6i" ...
0
 
SolveAuthor Commented:
we have no ideas anymore what to do ......
how to work?

S
0
 
Helena Markováprogrammer-analystCommented:
"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
 
SolveAuthor Commented:
Oracle forms6i use client 8.0.6 ?!

S.
0
 
Helena Markováprogrammer-analystCommented:
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
 
SolveAuthor Commented:
Does any anybody know if Forms 6i can work with Oracle Client version 8.1.7 installed into the same Oracle home ?

s.
0
 
Helena Markováprogrammer-analystCommented:
It works I have the same configuration.
0
 
SolveAuthor Commented:
ok, will try to install the latest client.

s.
0
 
Helena Markováprogrammer-analystCommented:
I recommend you at first istall a client and after that install Forms and Reports.
0
 
SolveAuthor Commented:
Thanks for recommendation.
But one more question - doesn't forms install their own client?

s.
0
 
Helena Markováprogrammer-analystCommented:
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
 
SolveAuthor Commented:
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
 
Helena Markováprogrammer-analystCommented:
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
 
SolveAuthor Commented:
probably you have Oracle Client 8.0.6, because it comes with Oracle Forms 6i
0
 
SolveAuthor Commented:
Mabe it is a problem in Oracle server?

s.
0
 
Helena Markováprogrammer-analystCommented:
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
 
SolveAuthor Commented:
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
 
Computer101Commented:
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 17
  • 9
  • 6
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now