Home » RDBMS Server » Networking and Gateways » ORA-1041 internal error.
ORA-1041 internal error. [message #66479] Tue, 02 July 2002 04:04 Go to next message
Avtar Mahajan
Messages: 2
Registered: July 2002
Junior Member
Problem:

We get the error message ORA-1041 internal error.

Communication channel seems to drop between production Weblogic Server and Database Server. We are starting the Weblogic Server with 10 database connections (by setting initial connections parameter of connection pool to 10 ). For couple of hours we are able to do the transactions on the website which acceess the database. Then the connection is dropped. Niether the Weblogic Server nor the database is down but they cannot communicate i.e we can access the database from SQL*Plus and Weblogic Server can display the pages which do not require database access. When this error occurs we restart the Weblogic server and the problem disappears.The possible causes:

1. Network connection problem between the Webloc Server and Databae Server
2. Timeout of the database connections.

Please can anyone tell me how to trace out this problem. This problem happens once every day at random. But there was a strech of 3 days when this problem didn't occur. This has reduced the possibility of timeout.

Any help will be very much appreciated.

Technology Stack
- iPlanet Webserver 4.0 Enterprise edition on Sun Solaris Server
- Weblogic Application Server 6.1 on Windows 2000 Server
- Oracle 8.1.5 on Sun Solaris Server
We are running three instances of the Oracle Databases on this server

Software
- J2EE (EJB/JSP/Servlet)

JDBC Driver
- Weblogic Server talks to Oracle database using Oracle Driver 8.1.7
Re: ORA-1041 internal error. [message #66480 is a reply to message #66479] Tue, 02 July 2002 07:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
for all internal errors, trace file ( alert logs) are most vital for diagnosis. Can you post the partial Trace with arguments and sequence in which the error originates?
any did you consider the DCD(dead connection detection)?
DCD is initiated on the server when a connection is established. At this time SQL*Net reads the SQL*Net parameter files and sets a timer to generate an
alarm. The timer interval is set by providing a non-zero value in minutes for the SQLNET.EXPIRE_TIME parameter in the sqlnet.ora file.
Re: ORA-1041 internal error. [message #66489 is a reply to message #66479] Thu, 04 July 2002 03:01 Go to previous message
Avtar Mahajan
Messages: 2
Registered: July 2002
Junior Member
Dear Mahesh,

Thanks for your reply.

I have done the follwoing:

On Clinet Side:

1. Modified the sqlnet.ora : added the following parameters
==== BEGIN SQLNET.ORA ON CLIENT ======
trace_file_client = sqlnetserver1.trc
trace_level_client = ADMIN

names.directory_path = (TNSNAMES, HOSTNAME)
names.default_domain = world
names.default_zone = world
automatic_ipc = off

names.log_directory = /oracle/app/oracle/product/8.1.5/network/log
names.log_file = sqlnetserver.log

names.log_stats_interval = 5
names.trace_directory =/oracle/app/oracle/product/8.1.5/network/log
names.trace_file = sqlnetserver.trc
names.trace_level = ADMIN

sqlnet.expire_time = 10

===============================================

QUESTIONS ABOUT SQLNET.ORA ON CLIENT SIDE
===============================================

Q1. It has generated the trace file on the client side. How to interpret it ?

Q2. No SQLNet Logfile has been generated ? Why ? When do the SQLNET log file is created ?

Q3. I am not sure the usage of names.trace_file ?

Q4. Am I right sqlnet.expire_time = 10 has no meaning on client side.

=========================================

SQLNET*ORA on SERVER SIDE
=========================================

The parameters are same as the client side except the change has been made to the file and directory names.

=======================================
QUESTIONS
=======================================

1. No entry has been made to SQLNet Logfile has been generated ? Why ? When do the SQLNET log file is created ?

2. Since it is a production box I did not stop the listener. Is that could be the reason it didn't generated the SQLNET Log.

===============================================
LISTENER.ORA file on the SERVER
===============================================

1. It produes the TRACE Files and LOG Files and have connetion_timeout parameter set to 10 seconds

=============================================
Question
==============================================

Q1. How to interpret the trace file? Is there any help available on line for this ?

Could you be kind enough to answer the above question.

Many Thanks,

Avtar
Previous Topic: about connection
Next Topic: Problem with Domain-Prefixing on WinNT/8.0.5
Goto Forum:
  


Current Time: Wed Feb 21 02:14:30 CST 2024