Suddenly 'Not Logged On' [message #2186] |
Fri, 03 July 2009 12:00 ![Go to next message Go to next message](/theme/default/images/down.png) |
ajwid01
Messages: 26 Registered: June 2009 Location: UK
|
Junior Member |
|
|
Hello there,
I last "touched" my Radicore installation a couple of days ago, and at that time, everything appeared to be functioning normally.
I am seeing no 'changed' files since that time, and my Apache access logs are showing that everything was functioning 'as expected' at that time.
However, just today, when I have returned to demonstrate a 'proof of concept', I am receiving a:
2009-07-03 14:49:02
Fatal Error: oci_execute() [function.oci-execute]: ORA-01012: not logged on (# 1012).
SQL query: SELECT * FROM global_name
Error in line 323 of file 'C:\Program Files\Zend\Core For Oracle\ZendFramework\library\dml.oracle.php5.class.inc'.
Database: //121.0.3.7/cube
PHP_SELF: /radicore/menu/logon.php
SERVER_ADDR: 127.0.0.1
SERVER_NAME: 127.0.0.1
HTTP_HOST: 127.0.0.1
REMOTE_ADDR: 127.0.0.1
REQUEST_URI: /radicore/menu/logon.php?csxslt=on
error.
I can alter the logon password in the config.inc, and I receive an incorrect username/password instead of this - which leads me to believe that the actual connection phase must be proceeding normally - but then a follow-on lookup to the database is acting as though we're not actually logged on.
This confuses me...
I would have expected a "logging on" error message (similar to the username/password issue) to have occurred if we weren't logged on.
Considering nothing has changed since Wednesday, I'm at a bit of a loss as to what's causing this.
I'll likely setup a database-side logon trigger to capture database session initiation capturing hereafter, to see if I can see what's happening at that point in time.
Just thought I would mention this incidence of this issue in the interim.
- Tony.
|
|
|
Re: Suddenly 'Not Logged On' [message #2187 is a reply to message #2186] |
Fri, 03 July 2009 13:12 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
AJM
Messages: 2361 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
I've googled for ORA-01012 and it would appear to be a problem with your Oracle database, such as too many instances, or the listener has died.
When I run Radicore on either of my development PCs (one with PHP4 and one with PHP5) they both work OK, but perhaps that is because I am running with a small number of instances.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Re: Suddenly 'Not Logged On' [message #2189 is a reply to message #2188] |
Mon, 06 July 2009 04:42 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
AJM
Messages: 2361 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
The reason that I use 'oci_pconnect' is that when running on my development PC is uses a single persistent connection, wheras when I used 'oci_connect' is created a new connection with each request, then quickly ran out of connections.
Perhaps there is a way to configure Oracle to get around this bijoux problemette?
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
|