Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> OCISessionBegin gives ORA-01005

OCISessionBegin gives ORA-01005

From: <CMattos_at_americel.com.br>
Date: Thu, 27 Jul 2000 13:57:17 -0300
Message-Id: <10571.113141@fatcity.com>


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";

 $ora_pass=3D"intra";
 $ora_conn=3Docilogon($ora_user,$ora_pass,$ora_sid);  if (!$ora_conn) {

         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">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0">
<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 &quot;ORA-01005 null password = given&quot;.</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">&nbsp;define(&quot;ORACLE&quot;, = 1);</FONT>
</P>

<P><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;putenv(&quot;ORACLE_SID=3Decd1&quot;);</FONT> <BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;putenv(&quot;ORACLE_HOME=3D/oracle/app/oracle/produ= ct/8.1.5&quot;);</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;putenv(&quot;TWO_TASK=3Decd1&quot;);</FONT> </P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;$ora_sid=3D&quot;ecd1&quot;; /* = Define base a ser pesquisada */</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;$ora_user=3D&quot;intra&quot;;</FONT> <BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;$ora_pass=3D&quot;intra&quot;;</FONT> <BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;$ora_conn=3Docilogon($ora_user,$ora_pass,$ora_sid);=

</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;if (!$ora_conn) {</FONT>
<BR><FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo = &quot;&lt;h1&gt;&gt;&gt; Ocorreu um erro durante a conex=E3o ao Banco =
Oracle.&lt;&lt;&lt;/h1&gt;\</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">n&quot;</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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = exit();</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>
</P>
<BR>

<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 = Black">AMERICEL</FONT>
<BR><FONT COLOR=3D"#FF0000" SIZE=3D1 FACE=3D"Arial">I.T. - Coordenador = de Sistemas</FONT>
<BR><FONT COLOR=3D"#000080" SIZE=3D1 FACE=3D"Arial">email: = cmattos_at_americel.com.br</FONT>
<BR><FONT COLOR=3D"#000080" SIZE=3D1 FACE=3D"Arial">Fone: +55 61 329 =
6836</FONT>
<BR><FONT COLOR=3D"#000080" SIZE=3D1 =

FACE=3D"Arial">Cel:&nbsp;&nbsp;&nbsp; +55 61 929 0</FONT><FONT = COLOR=3D"#000080" SIZE=3D2 FACE=3D"Tahoma">638</FONT> <BR><U><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Tahoma"><A = HREF=3D"http://www.americel.com.br" = Received on Thu Jul 27 2000 - 11:57:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US