Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> OCISessionBegin gives ORA-01005
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFF7EB.B8EF8D00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi everyone,
We have a code that connects to an Oracle DB via an Apache Web Server =
using
OCI calls. Everything worked fine till we reboot our server (Digital =
Unix
4.0f). After reboot, the code stopped working, giving the error =
"ORA-01005
null password given".
As shown in the code bellow, a password is provided but the error stil occurs. Any clues????
Thanks in advance!
define("ORACLE", 1);
putenv("ORACLE_SID=3Decd1"); putenv("ORACLE_HOME=3D/oracle/app/oracle/product/8.1.5"); putenv("TWO_TASK=3Decd1"); $ora_sid=3D"ecd1"; /* Define base a ser pesquisada */ $ora_user=3D"intra";
echo "<h1>>> Ocorreu um erro durante a conex=E3o ao Banco
Oracle.<<</h1>\
n"
; /* Verifica se o logon ao oracle foi feito, senao sai do programa */
exit(); } =20
Oracle Enterprise Server 7.3.4.3.0
SQL*Net - Server (Listener) 8.1.5.0
SQL*Net - Client 8.1.5.0
> Clebert Duarte Mattos
> AMERICEL
> I.T. - Coordenador de Sistemas
> email: cmattos_at_americel.com.br
> Fone: +55 61 329 6836
> Cel: +55 61 929 0638
> http://www.americel.com.br
>=20 >=20 >=20
------_=_NextPart_001_01BFF7EB.B8EF8D00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =charset=3Diso-8859-1">
<TITLE>OCISessionBegin gives ORA-01005</TITLE> </HEAD> <BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">Hi everyone,</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">We have a code that connects to an = Oracle DB via an Apache Web Server using OCI calls. Everything worked = fine till we reboot our server (Digital Unix 4.0f). After reboot, the = code stopped working, giving the error "ORA-01005 null password = given".</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">As shown in the code bellow, a = password is provided but the error stil occurs. Any clues????</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks in advance!</FONT> </P> <BR>
<P><FONT SIZE=3D2 FACE=3D"Arial"> define("ORACLE", =
1);</FONT>
</P>
<P><FONT SIZE=3D2 =
FACE=3D"Arial"> putenv("ORACLE_SID=3Decd1");</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial"> putenv("ORACLE_HOME=3D/oracle/app/oracle/produ=
ct/8.1.5");</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial"> putenv("TWO_TASK=3Decd1");</FONT>
</P>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial"> $ora_sid=3D"ecd1"; /* =
Define base a ser pesquisada */</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial"> $ora_user=3D"intra";</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial"> $ora_pass=3D"intra";</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial"> $ora_conn=3Docilogon($ora_user,$ora_pass,$ora_sid);=
</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"> if (!$ora_conn) {</FONT> <BR><FONT SIZE=3D2 =
Oracle.<<</h1>\</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">n"</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">; /* Verifica se o logon ao oracle =foi feito, senao sai do programa */</FONT> <BR><FONT SIZE=3D2 =
FACE=3D"Arial"> } &n= bsp; &n= bsp; </FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Oracle Enterprise Server =
7.3.4.3.0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">SQL*Net - Server (Listener) =
8.1.5.0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">SQL*Net - Client 8.1.5.0</FONT> </P> <BR> <BR> <BR> <UL> <P><B><I><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Clebert Duarte =Mattos</FONT></I></B><I></I>
<BR><FONT COLOR=3D"#000080" SIZE=3D1 FACE=3D"Arial">Fone: +55 61 329 = 6836</FONT> <BR><FONT COLOR=3D"#000080" SIZE=3D1 =