Re: error ORA-12699
| From: | sang | Date: | Wed, 27 Jun 2001 13:31:56 +0000 |
| Subject: | Re: error ORA-12699 | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9862@lists.php.net to get a copy of this message | ||
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@digitalphenom.com> wrote in message
news:B75F483C.E61%anthony@digitalphenom.com...
> 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@technical-e.co.jp>
> > Date: Wed, 27 Jun 2001 18:59:31 +0900
> > To: php-db@lists.php.net
> > 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@lists.php.net
> > For additional commands, e-mail: php-db-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>