| aiman |
Posted: Apr 13, 2007 04:01:44 AM |
Total Post: 2
Joined: Apr, 2007
|
| I've used php mambo and oracle (oci 9) to develop a web-based application..I also used separate server for database and the system..but sometime an error occur to the database connection, its display "Could not connect to database" after submit the data..Anyone can help me out to solve this problem? |
|
|
 Oracle Virus |
| Posted: Apr 13, 2007 05:00:44 AM |  |
|
Total Post: 50
Joined: Jan, 2007
|
Dear Aiman,
This solution to this problem could range from software to hardware. I guess you are gettin this error "Couldnot connect to Oracle Database. Time out." If it is time out, 80% chances are there for hardware. I mean some loose connection in network cable that is conneting to Oracle Database. If the Database and PHP exists in the same machine, we have to start debugging in the same manner. Keep it under testing for 24hrs. Check the listener uptime every one hour. With this you can trace whether is listener is restarting or stable. If this wont work, we will work further. Post me the exact error.
Regards,
Aneel Kanuri
|
|
|
|
|
| aiman |
| Posted: Apr 13, 2007 05:50:15 AM | |
|
Total Post: 2
Joined: Apr, 2007
|
dear Oracle Virus
thanks a lot for your advice...I'll try out later
|
|
|
|
|
| Oracle Virus |
| Posted: Apr 13, 2007 08:57:28 AM | |
|
Total Post: 50
Joined: Jan, 2007
|
Dear Aiman,
You are weklcome. Post any problem here regarding Oracle DB.
Regards,
Aneel Kanuri
|
|
|
|
|
| parth |
| Posted: Apr 13, 2007 09:48:32 AM | |
|
Total Post: 17
Joined: Apr, 2007
|
bhai , what you need is just check out your TNSNAMES.ora file and see there is any changes has been made in it...cause some times it happens that listener is not able to listen and thus connection has not been done,, other hard problem is there....try out and tell.
regards, Parth
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
