Re: [PHP-DB] Oracle error
ORA 600 errors are unhandled errors by the DB engine. To find the root cause you need to get the true error message. Check you alert.log file then repost it. It will be something like ora-00600: [ some_code_here ] [ some_number_here ] ... >From that we can identify the root cause. To find where your alert.log file is located, log into SQL*Plus and do --> show parameter background_dump_dest <--. Or log into the database via any tool and do --> SELECT * FROM v$parameter WHERE name = 'background_dump_dest'; <-- "Carel Smit" <[EMAIL PROTECTED]> 14-Feb-2006 09:10 Please respond to "Carel Smit" <[EMAIL PROTECTED]> To php-db@lists.php.net cc Subject [PHP-DB] Oracle error Hi, Can anyone tell me what the possible causes of this error are? PHP Warning: Unknown: _oci_close_session: OCISessionEnd: ORA-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s] in Unknown on line 0 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Oracle error
>From the manual: ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include: * timeouts * file corruption * failed data checks in memory * hardware, memory, or I/O errors * incorrectly restored files The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle. Action: Report this error to Oracle Support Services after gathering the following information: * events that led up to the error * the operations that were attempted that led to the error * the conditions of the operating system and databases at the time of the error * any unusual circumstances that occurred before receiving the ORA-00600 message * contents of any trace files generated by the error * the relevant portions of the Alter files Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error. Neil Morgan -Original Message- From: Carel Smit [mailto:[EMAIL PROTECTED] Sent: 14 February 2006 14:10 To: php-db@lists.php.net Subject: [PHP-DB] Oracle error Hi, Can anyone tell me what the possible causes of this error are? PHP Warning: Unknown: _oci_close_session: OCISessionEnd: ORA-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s] in Unknown on line 0 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] oracle error ORA-12154
Adam Williams wrote: yeah I got it to work, i had to do putenv() with my oracle home dir and then my scripts started working. thanks It would be better to set the variables before starting the web server. See http://otn.oracle.com/tech/opensource/php/php_troubleshooting_faq.html#envvars Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] oracle error ORA-12154
yeah I got it to work, i had to do putenv() with my oracle home dir and
then my scripts started working. thanks
Peter Beckman wrote:
The biggest problem with oci8 is having these four variables set:
$ORACLE_SID=SOMESID
$ORACLE_HOME=/home/beckman/oracle
$ORACLE_BASE=/home/beckman/oracle
$TNS_ADMIN=/home/beckman/oracle/network/admin
If those aren't set, then things won't work.
Please confirm that those environment variables are set in Apache or
whatever web server you are using. If they aren't, oci8 won't work.
Beckman
On Fri, 16 Jul 2004, Adam Williams wrote:
Hi, I'm trying to connect to an oracle 9.20 database using:
$conn = OCILOGON("dah50","dah50","zed2.aleph0");
but I get the error ORA-12154
Searching on google says my listener.ora or tnsnames.ora may have
problems, but I think mine are correct. Can someone take a look and see
if they are ok? Also, I can connect to the database from the command
line:
ORACLE>>sqlplus dah50/[EMAIL PROTECTED]
SQL*Plus: Release 9.2.0.3.0 - Production on Fri Jul 16 11:58:49 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
so I'm not really sure what is going on. below are my tnsnames.ora and
listener.ora:
tnsnames.ora
zed2.aleph0=(description=
(address=
(protocol=ipc)
(key=aleph0))
(address=
(protocol=tcp)
(host=zed2.mdah.state.ms.us)
(port=1521))
(connect_data=(service_name=aleph0)(server=DEDICATED)))
listener.ora
listener=(description=
(address_list=
(address =
(protocol = ipc)
(key = extproc))
(address=
(protocol=ipc)
(key=aleph0))
(address=
(protocol=tcp)
(host=zed2.mdah.state.ms.us)
(port=1521))
)
)
sid_list_listener=(sid_list=
(sid_desc=
(global_name=aleph0)
(sid_name=aleph0)
(oracle_home=/exlibris/app/oracle/product/920)
)
(sid_desc =
(sid_name = extproc)
(oracle_home=/exlibris/app/oracle/product/920)
(program = extproc)
)
)
startup_wait_time_listener=0
connect_timeout_listener=20
trace_level_listener=off
and when I start the listener I get no errors.
ORACLE>>lsnrctl stop ; lsnrctl start
LSNRCTL for Linux: Version 9.2.0.3.0 - Production on 16-JUL-2004 12:07:11
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(address=(protocol=ipc)(key=extproc)))
The command completed successfully
LSNRCTL for Linux: Version 9.2.0.3.0 - Production on 16-JUL-2004 12:07:11
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /exlibris/app/oracle/product/920/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.3.0 - Production
System parameter file is
/exlibris/app/oracle/product/920/network/admin/listener.ora
Log messages written to
/exlibris/app/oracle/product/920/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=aleph0)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zed2.mdah.state.ms.us)(PORT=1521)))
Connecting to (DESCRIPTION=(address=(protocol=ipc)(key=extproc)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.3.0 -
Production
Start Date16-JUL-2004 12:07:11
Uptime0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File
/exlibris/app/oracle/product/920/network/admin/listener.ora
Listener Log File
/exlibris/app/oracle/product/920/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=aleph0)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zed2.mdah.state.ms.us)(PORT=1521)))
Services Summary...
Service "aleph0" has 1 instance(s).
Instance "aleph0", status UNKNOWN, has 1 handler(s) for this service...
Service "extproc" has 1 instance(s).
Instance "extproc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Re: [PHP-DB] oracle error ORA-12154
The biggest problem with oci8 is having these four variables set:
$ORACLE_SID=SOMESID
$ORACLE_HOME=/home/beckman/oracle
$ORACLE_BASE=/home/beckman/oracle
$TNS_ADMIN=/home/beckman/oracle/network/admin
If those aren't set, then things won't work.
Please confirm that those environment variables are set in Apache or
whatever web server you are using. If they aren't, oci8 won't work.
Beckman
On Fri, 16 Jul 2004, Adam Williams wrote:
> Hi, I'm trying to connect to an oracle 9.20 database using:
>
> $conn = OCILOGON("dah50","dah50","zed2.aleph0");
>
> but I get the error ORA-12154
>
> Searching on google says my listener.ora or tnsnames.ora may have
> problems, but I think mine are correct. Can someone take a look and see
> if they are ok? Also, I can connect to the database from the command
> line:
>
> ORACLE>>sqlplus dah50/[EMAIL PROTECTED]
>
> SQL*Plus: Release 9.2.0.3.0 - Production on Fri Jul 16 11:58:49 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.3.0 - Production
>
>
> so I'm not really sure what is going on. below are my tnsnames.ora and
> listener.ora:
>
>
> tnsnames.ora
>
>
> zed2.aleph0=(description=
> (address=
> (protocol=ipc)
> (key=aleph0))
> (address=
> (protocol=tcp)
> (host=zed2.mdah.state.ms.us)
> (port=1521))
> (connect_data=(service_name=aleph0)(server=DEDICATED)))
>
>
>
> listener.ora
>
>
> listener=(description=
> (address_list=
> (address =
> (protocol = ipc)
> (key = extproc))
> (address=
> (protocol=ipc)
> (key=aleph0))
> (address=
> (protocol=tcp)
> (host=zed2.mdah.state.ms.us)
> (port=1521))
> )
>)
>
> sid_list_listener=(sid_list=
> (sid_desc=
> (global_name=aleph0)
> (sid_name=aleph0)
> (oracle_home=/exlibris/app/oracle/product/920)
> )
> (sid_desc =
> (sid_name = extproc)
> (oracle_home=/exlibris/app/oracle/product/920)
> (program = extproc)
> )
> )
> startup_wait_time_listener=0
> connect_timeout_listener=20
> trace_level_listener=off
>
>
>
>
> and when I start the listener I get no errors.
>
> ORACLE>>lsnrctl stop ; lsnrctl start
>
> LSNRCTL for Linux: Version 9.2.0.3.0 - Production on 16-JUL-2004 12:07:11
>
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
> Connecting to (DESCRIPTION=(address=(protocol=ipc)(key=extproc)))
> The command completed successfully
>
> LSNRCTL for Linux: Version 9.2.0.3.0 - Production on 16-JUL-2004 12:07:11
>
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
> Starting /exlibris/app/oracle/product/920/bin/tnslsnr: please wait...
>
> TNSLSNR for Linux: Version 9.2.0.3.0 - Production
> System parameter file is
> /exlibris/app/oracle/product/920/network/admin/listener.ora
> Log messages written to
> /exlibris/app/oracle/product/920/network/log/listener.log
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=aleph0)))
> Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zed2.mdah.state.ms.us)(PORT=1521)))
>
> Connecting to (DESCRIPTION=(address=(protocol=ipc)(key=extproc)))
> STATUS of the LISTENER
>
> Alias LISTENER
> Version TNSLSNR for Linux: Version 9.2.0.3.0 -
> Production
> Start Date16-JUL-2004 12:07:11
> Uptime0 days 0 hr. 0 min. 0 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File
> /exlibris/app/oracle/product/920/network/admin/listener.ora
> Listener Log File
> /exlibris/app/oracle/product/920/network/log/listener.log
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=aleph0)))
>
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zed2.mdah.state.ms.us)(PORT=1521)))
> Services Summary...
> Service "aleph0" has 1 instance(s).
> Instance "aleph0", status UNKNOWN, has 1 handler(s) for this service...
> Service "extproc" has 1 instance(s).
> Instance "
