Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

connetion fail in Oracle eBusiness Suite

sassou
Frequent Advisor

connetion fail in Oracle eBusiness Suite

hi

I have Oracle Ebusiness Suite Installed in RP5450 2 Cluster and 12H Array.
All the package Of oracle is on scsi auto raid.
My system runs about 24 heure and the could connect with the database.
I lose listener.
But the package still runing.
When I restart all the nodes everything become good.
The problem appears aftet I install ignite.
And perform fbackup interactively
I need help
7 REPLIES
Nicolas Dumeige
Esteemed Contributor

Re: connetion fail in Oracle eBusiness Suite

Hello Kuzo,

Is there something intersting in the listener log ?

(
To get the log path
[The show log_file doesn't seems to work properly for me]
# lsnrctl status SVC_NAME | grep 'Log File'
)

Have you tried to restart the listener ?
# lsnrctl reload SVC_NAME

Cheers

Nicolas
All different, all Unix
Gecseg Gyula_1
Occasional Visitor

Re: connetion fail in Oracle eBusiness Suite

Hello Kuzo!

I don,t know your environment, but I had similar problem. There was responsible for the problem, that TCP/IP protocoll was collapsed. I found the problem, that I could trace the Oracle listener.

Gyula Gecseg
Bharat Katkar
Honored Contributor

Re: connetion fail in Oracle eBusiness Suite

Hi KUZO,
Why don't you check the Package log file that resides in /etc/cmcluster/.
I hope that can direct you towards exact cause of problem.
All the best.
You need to know a lot to actually know how little you know
sassou
Frequent Advisor

Re: connetion fail in Oracle eBusiness Suite

Thank you

Something interrestant happend in my system
The var directory /var is full
specialy /var/adm/crash
When the /var directory attempt 100% The node is unreachble and the listener and connetion fail.
I remove some file whith sam and the system continue until the node crash again.
Could I clean all the crash directories?
I need help
Ingo Duschl
Frequent Advisor

Re: connetion fail in Oracle eBusiness Suite

you can change the path in oracle for your database instances ini chenge the *_dump_dest to another path with more space or even switch it off
Yogeeraj_1
Honored Contributor

Re: connetion fail in Oracle eBusiness Suite

hi,

"Could I clean all the crash directories?"
The crash directories contain information that HP can use to trace the cause of the crash. You may wish to backup before deleting them. You may also be asked for a copy in case you are troubleshooting with HP.

hope this helps too!
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Eric Antunes
Honored Contributor

Re: connetion fail in Oracle eBusiness Suite

Hi Kuzo,

As Ingo said before, you need to move some of your variables paths:

Make sure that utl_file_dir (in init.ora file) is not directed to /var. For exemple (on E-Business Suite 11.0.3):

...

utl_file_dir = /disc2/app/appltst/1103/common/TST/tmp

...

As appl user, make sure that APPLCSF is pointing to the right place:

$echo $APPLCSF
/disc2/app/appl.../1103/common/

Each and every day is a good day to learn.