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

x
?
Solved

SQL+ in my PC can't connect to AIX Oracle DB

Posted on 2001-06-25
3
Medium Priority
?
373 Views
Last Modified: 2007-12-19
I have problem in using SQL+ 8.0 in my PC connecting to AIX Oracle database (8i 8.0.6).  What's
the problem?

The following are the error details that Window give me:

PLUS80W caused an invalid page fault in
module ORA805.DLL at 015f:6764a9c4.
Registers:
EAX=535c3036 CS=015f EIP=6764a9c4 EFLGS=00010216
EBX=61726f5c SS=0167 ESP=006ce0e0 EBP=006ce4fc
ECX=49474f4c DS=0167 ESI=006ce50b FS=124f
EDX=00000135 ES=0167 EDI=52425c32 GS=0000
Bytes at CS:EIP:
c7 01 00 00 00 00 c7 03 62 24 00 00 c7 43 04 00
Stack dump:

But there is no problem when using Oracle Forms 6i or Oracle Reports 6i to connect to the database.
The same situation occurs when trying connect to Oracle 8i on Linux.

Pls advise.
Regards,
Lyon.
0
Comment
Question by:lyon88
3 Comments
 
LVL 2

Expert Comment

by:noriegaa
ID: 6226359
Are you getting any oracle message such as ora-99999 ? It seems to me like a client install issue. If you are not getting any ora- messages, may I recommend for you to take a look at the install/config. and possibly try reinstalling/ reconfiguring your client.
0
 
LVL 2

Accepted Solution

by:
stmontgo earned 30 total points
ID: 6226405
see if this helps....

Problem Description
-------------------
PLUS80W caused an invalid page fault in module ORA805.DLL
when trying to start SQLPLUS.

This problem has been noticed when Oracle Personal Edition 8.1.5
was installed and Forms and Reports 6i were installed in a
separate ORACLE_HOME as required.

The order of the installation did not make a difference.


Solution Description
--------------------
Reinstall some of the .dll's again.

To do this, use the Developer 6i Forms/Reports CD and start the installer.
Choose custom install and select:

1. Guicommon Files
2. Required Support Files
3. SQL*Plus


Explanation
-----------

There has been some confusion in the .dll's installed.  Sometimes the
installer does not overwrite the .dll's and hence they do not get installed.

0
 

Author Comment

by:lyon88
ID: 6227074
Thks a lot! It works with my PC's sql+.
Though i've never installed Personal Edition to my PC.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

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.  …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

916 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