Home » RDBMS Server » Server Administration » Oracle 10g Connection Failed (merged 5) (Oracle 10g, Win2003)
Oracle 10g Connection Failed (merged 5) [message #421090] Fri, 04 September 2009 03:45 Go to next message
gmkhaw@yahoo.com
Messages: 14
Registered: September 2006
Location: Malaysia
Junior Member

My company is running 2 separate version of oracle, 9i and 10g for different purposes. I found that 9i is very stable but 10g keep creating connection problem, the auto email message as follow:

Name=OMERP
Type=Database Instance
Host=ssomerp
Metric=Status
Timestamp=Jul 27, 2009 2:43:47 PM SGT
Severity=Critical
Message=Failed to connect to database instance: ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach).
Rule Name=Database Availability and Critical States
Rule Owner=SYSMAN

I need to restart my oracle services every times the problem occur, and this happen quite frequent (about once a week). Anyone has the idea why this is happening and how to solve it?

Thanks

[Updated on: Fri, 04 September 2009 04:05] by Moderator

Report message to a moderator

Re: Oracle 10g Connection Failed (merged 5) [message #421098 is a reply to message #421090] Fri, 04 September 2009 04:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
STOP reposting the same question.

Regards
Michel
Re: Oracle 10g Connection Failed (merged 5) [message #421116 is a reply to message #421098] Fri, 04 September 2009 05:49 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>I need to restart my oracle services every times the problem occur, and this happen quite frequent (about once a week). Anyone has the idea why this is happening and how to solve it?

Please communicate with your DBA Manager
Re: Oracle 10g Connection Failed (merged 5) [message #421178 is a reply to message #421090] Fri, 04 September 2009 23:28 Go to previous message
gmkhaw@yahoo.com
Messages: 14
Registered: September 2006
Location: Malaysia
Junior Member

guys, can give more constructive answer?
Previous Topic: Strange ora_*** processes
Next Topic: Error while STARTUP database
Goto Forum:
  


Current Time: Sun Dec 01 17:07:40 CST 2024