Connection with Oracle XE through customers does not work

[rafaelcardoso]

Good Tade,

At 91No connect to the XE, and Listener's logs.log it accuses a connection without errors, but SQLPLus and Forms close without giving any error.

Can anyone help me?

[gilbertoca]

The utility

Select all

tnsping <address>

works?
I entered the Oracle world in the 10G version so I may be wrong, but there must be an incompatibility of access of customers, is not it? For example: Version SQLPlus 10 accesses earlier versions, but old versions may have problems accessing the newer version. I do not know, I still have not had this demand here in my work.

The little look I gave in Oracle Express, I realized that one of the important points is simplicity and very good documentation. Look in the documentation for a compatibility matrix.

Gilberto

[dr_gori]

With XE I have not tested yet.
But to use Normal SQL * plus 8 in Oracle 10G.

Select all

SQL*Plus: Release 8.0.6.0.0 - Production on Wed Apr 19 10:49:36 2006 
 
(c) Copyright 1999 Oracle Corporation.  All rights reserved. 
 
 
Connected to: 
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production 
With the Partitioning, OLAP and Data Mining options

[gilbertoca]

Oh, beauty!
then Rafael's problem is possibly the listener configuration on the server where Oracle EX is installed.
The best way to resolve is through the Oracle Network Configuration Manager interface. In Linux it is Netmgr, in Windows not the name.

[rafaelcardoso]

This is the configuration of my listener:

Select all

 
# listener.ora Network Configuration File: 
 
SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = XE) 
      (ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server) 
 #     (PROGRAM = extproc) 
    ) 
  ) 
 
LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521)) 
    ) 
  ) 
 
DEFAULT_SERVICE_LISTENER = (XE) 

Thanks for the answers and attention to the topic.

[gilbertoca]

Yeah, now is the time to know if we are dbas or not! : Shock:

We will use the tools to diagnose connection problems: tnsping <service_name>

In your case it should be:

Select all

tnsping XE

Another way is to use more information in the SQLPLUS client connection string:

Select all

sqlplus system/mypassword@host/XE

[rafaelcardoso]

The SQL Plus I installed on the client next to the Forms Run Time, is the "SQL * Plus: Release 8.0.6.0.0" and SQL Plus that comes in the Oracle XE client is the "SQL * Plus: Release 10.2.0.1 .0 ', and the latter can make the normal connection. When I try to connect through the SQL * Plus 8 Linux Oracle XE SGBD logs are successful in connection, are identical to connection logs with SQL Plus 10.2.0.1.0, only SQL Plus 8 closes the connection without any message of error. As for forms, behavior and the same as SQL Plus, and I already formatted Linux and installed everything again, following all documentation but unsuccessfully...

[gilbertoca]

Rafeal, I installed Oracle Ex on my computer - Windows XP - and I gave a small look at the documentation: http://127.0.0.1:8080/apex/wwv_flow_hel ... ep_id=1000

The most important stretch says:

Oracle Database Xe Accepts Connections From Oracle Client Software:

*

Oracle Database Express Edition Client (Oracle Database Xe Client)

When You Install Oracle Database Xe, Oracle Database Xe Client Is Also Installed On The Same Computer. You can install Oracle Database Xe Client Separately on Remote Computers. It is available

http://www.oracle.com/technology/xe *

instant client

Instant Client is Available at
http://www.oracle.com/technology/tech/o ... lient.html
*

Oracle Client Client Software for Oracle Database Enterprise Edition Or Standard Edition (All Supported Releases of Oracle Database 8, 8i, 9i, and 10g)

can be a bug! Best you visit the mailing list http://www.oracle.com/technology/xe/forum/index.html
if you do not find anything similar, report the bug.

[rafaelcardoso]

The "Gilberto" statement for being an Oracle bug is correct. After installation and various tests, it was discovered that Oracle Xe Universal Installer, in the RPM version, downloaded from the Oracle website, is not with is compatible with the older versions of Oracle * net, making it impossible to use forms and reports for example . We use the name package:
Oracle-XE-10.2.0.1-1.0.i386.rpm and the connection has given no problem any.

My thanks to the forum staff and a DBA friend, the Gonçalo Franco da Support Consultants in Ribeirão Preto, which was the one who effectively discovered the bug.

For further clarification, they may contact me.

Thanks,
Rafael Cardoso.