Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001062

RE: [PHP-DB] error ORA-12699 From: Anthony Carlos (anthony <email protected>)
Date: 06/28/01

Sang,

Your tnsnames file appears to be misconfigured. It should look like this:

ORCL =
  (DESCRIPTION=
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
    (CONNECT_DATA = (SID = ORCL)))

The first line, "ORCL =", lets you know what to use as your connect string.
In this case, you're calling your connect string ORCL. When you try to
login, you should use username/password <email protected>

In PHP, you set the third argument to OCILogon to ORCL.

Here's what happens. When Oracle sees a connect string during a login
attempt, it checks the tnsnames.ora file to resolve it into a protocol,
address, and sid. In other words, ORCL is shorthand notation for all of the
TCP/IP info and then some.

I hope this makes sense,

Anthony
-----Original Message-----
From: sang [mailto:sang <email protected>]
Sent: Wednesday, June 27, 2001 9:32 AM
To: php-db <email protected>
Subject: Re: [PHP-DB] error ORA-12699

I have read some doc.
 $connect_string is set to equal from tnsnames.ora.

 $connect_string="(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.1.1)(PORT = 1521))(CONNECT_DATA = (SID = ORCL)))";

I can connect my local oracle server before when using
OCILogon("system","manager");

But now , i cannot connect local oracle server!!
It is always said the ORA-12699 error!

I donot know what is wrong.

sang

"Anthony Carlos" <anthony <email protected>> wrote in message
news:B75F483C.E61%anthony <email protected>
> Sang,
>
> Since you're trying to connect from another computer to the Oracle server,
> you probably need to specify a connect string in the OCILogon command.
>
> OCILogon('system', 'manager', "$connect_string");
>
> What's the value for $connect_string? It depends on how you've set-up your
> Oracle networking. If you can access your DB from that client machine with
> SQL*Plus, then you must be loging in via the following format:
>
> >sqlplus system/manager@<connect_string>
>
> Use the value of <connect_string> for $connect_string. It should be
defined
> in your tnsnames.ora file on your client, and have a corresponding entry
in
> your listern.ora file on your server.
>
> I suspect that your client machine is trying to access an Oracle database
on
> itself, because no connect string was specified.
>
> Lemme know if this helps,
>
> Anthony
>
> > From: "sang" <sang <email protected>>
> > Date: Wed, 27 Jun 2001 18:59:31 +0900
> > To: php-db <email protected>
> > Subject: [PHP-DB] error ORA-12699
> >
> > I have installed NT4+PHP+ORACLE8.0.4+APACHE in my computer.
> > I want to access ORACLE server to another computer from web server.
> > It is ok to access ORACLE SERVER with PERL, but i cannot access using
PHP.
> >
> > The first error is ora-12514 , but i change, change and change, now it
is
> > always
> > ORA-12699 Native service internal error .
> >
> >
> > <?php
> > ocilogon("system","manager","");
> > ?>
> >
> > Warning: _oci_open_server: ORA-12699:Native service internal error
> >
> >
> > Thanks in advance.
> >
> > sang
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> > For additional commands, e-mail: php-db-help <email protected>
> > To contact the list administrators, e-mail: php-list-admin <email protected>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
> 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>