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@ORCL.
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:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 9:32 AM
To: [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" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[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" <[EMAIL PROTECTED]>
> > Date: Wed, 27 Jun 2001 18:59:31 +0900
> > To: [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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
