Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Problem with Oracle Client 8.0.6

Posted on 2004-09-30
34
Medium Priority
?
934 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 17
  • 9
  • 6
  • +1
34 Comments
 
LVL 12

Expert Comment

by:catchmeifuwant
ID: 12188581
What problem???
0
 
LVL 1

Author Comment

by:Solve
ID: 12188587
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
ID: 12188625
Does it give you any error message?
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 1

Author Comment

by:Solve
ID: 12188681
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
ID: 12188702
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
ID: 12188735
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
ID: 12188757
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
ID: 12188781
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
ID: 12188794
there is no messages in command window after abort

S.
0
 
LVL 12

Expert Comment

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

Author Comment

by:Solve
ID: 12188829
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
ID: 12188839
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
ID: 12188848
xxx.txt is empty :(

s.
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 12189115
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
ID: 12189240
"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á
ID: 12189369
I understand it as "E-Business Suites with Forms 6i" ...
0
 
LVL 1

Author Comment

by:Solve
ID: 12189442
we have no ideas anymore what to do ......
how to work?

S
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 12197287
"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
ID: 12197434
Oracle forms6i use client 8.0.6 ?!

S.
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 12197476
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
ID: 12197529
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á
ID: 12197553
It works I have the same configuration.
0
 
LVL 1

Author Comment

by:Solve
ID: 12197563
ok, will try to install the latest client.

s.
0
 
LVL 22

Expert Comment

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

Author Comment

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

s.
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 12197663
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
ID: 12197983
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á
ID: 12198040
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
ID: 12198055
probably you have Oracle Client 8.0.6, because it comes with Oracle Forms 6i
0
 
LVL 1

Author Comment

by:Solve
ID: 12198059
Mabe it is a problem in Oracle server?

s.
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 12198137
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
ID: 12236120
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
ID: 12317968
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup

688 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