Re: error ORA-12699

From: 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 >

« previous php.db (#9862) next »