Ocilogon Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of call to undefined function ocilogon() this site About Us Learn more about Stack Overflow the company Business oci_connect example Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask ocifetch Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign
Ociparse
up OCILOGON error ORA 12514 up vote 0 down vote favorite I am getting Array ( [code] => 12514 [message] => Error while trying to retrieve text for error ORA-12514 [offset] => 0 [sqltext] => ) when calling the Ocilogon function to connect with oracle. I got the correct string but still getting the error. php oracle share|improve this question edited Apr 7 call to undefined function oci_connect() at 22:24 halfer 13k54075 asked Jul 15 '14 at 12:58 DLV 52116 this answer . You are getting this error, because the SID mentioned in your connection string is invalid. –Maheswaran Ravisankar Jul 15 '14 at 13:01 @maheswaran Can you please elaborate this. I did not used SID as a parameter. –DLV Jul 15 '14 at 13:11 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted ocilogon() is deprecated (along with many other aliases) and you should not be using it in new code. Use oci_connect() instead. Personally I use the following code that doesn't rely on environment settings like TNS_ADMIN: oci_connect($username, $password, $conn_string); Where $conn_string is a valid connection string that looks something like this: (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOST.EXAMPLE.COM)(PORT = 1521)) ) (CONNECT_DATA = (SID = EXAMPLE)) ) You can copy the connection string directly from your TNSNAMES.ORA file. This blog entry on oracle.com might be useful further reading for you. share|improve this answer answered Jul 15 '14 at 20:02 timclutton 4,2332822 Yes its working now.
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back oci_connect php on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in PHP All PlacesDatabaseDatabase Application DevelopmentPHP This discussion is archived 1 2 Previous Next 18 Replies Latest reply on May 16, 2007 2:05 AM by user574815 Go to http://stackoverflow.com/questions/24758806/ocilogon-error-ora-12514 original post This content has been marked as final. Show 18 replies 15. Re: ocilogon() error trying to retrieve ORA-12514 466315 Mar 13, 2006 1:59 PM (in response to 461579) I had the same problem, however I am using IIS instead of Apache. The Error Warning: ocilogon() [function.ocilogon]: ORA-12514: TNS:listener does not currently know https://community.oracle.com/thread/337232?start=15&tstart=0 of service requested in connect descriptor in D:\www\oraTest.php Failed. Oracle Connect Error After checking many forums I discovered that there was/is very little related to the IIS world, and so I was left to my own devices. Going over my connect string and modifing it did nothing to resolve my problem. The problem baffled me, because I could connect via SQL*Plus. That was untill I tried another program PLSQL Developer. It could not connect. I now understood that the problem was not related to my PHP code (Code that worked wonderfully before), or to IIS PHP server. I then began to check the TNSNAME files and every single ORA file I had on my HDD. Still nothing. Solution I remembered that I once had a connection problem when the system PATH was modified. Checking the system PATH I discovered that the system PATH was indeed modified and that the Oracle bin path was no longer there. I quickly add
with the OCILogon error. Im using WampServer Version 2.2. I have a script which connects to 10g and 11g database and it works perfect from the browser. Now i want to automate the https://www.daniweb.com/programming/web-development/threads/471145/wampserver-ocilogon-error-from-command-line php script via batch file which will be windows 7 schedule task. I have set the classpath to C:\wamp\bin\php\php5.4.3 for php. While executing script it gives "Call to undefined function OCILogon() in c:\wamp\www\cps_auto\testauto.php on line 6. PHP Stack trace: php 1.(main) c:\c:\wamp\www\cps_auto\testauto.php:0 Please help need it urgently. command error from line php dippy78 11 posts since Nov 2009 Community Member 2Contributors 2Replies 14Views 2 YearsDiscussion Span call to 2 Years Ago Last Post by dippy78 0 cereal 1,078 2 Years Ago Hi, from the command line check if the oci8 module is loaded: php -r 'echo extension_loaded("oci8") ? "true":"false";'; You can also list all the modules loaded by using: php -m The PHP version used in command line is known as CLI version and the configuration of this is usually different from the Apache version. call to undefined They use different php.ini files. So if in the Apache version you see extension=oci8.dll or something similar, copy this to the php.ini of the CLI version and it should work. Also by using oci_connect() do you get the same error? Ocilogon is an alias of oci_connect and the alias is deprecated since PHP 5.4.0. More information about the installation process: http://www.php.net/manual/en/oci8.installation.php 1 Discussion Starter dippy78 2 Years Ago Hi cereal, You are right, we need to decomment in php.INI file in phpx.x.x folder also. Bit confusing the need to have 2 files for config.. It worked finally.. Thanks a lot Cheers Deepak command error from line php This question has already been answered. Start a new discussion instead. Message Insert Code Snippet Alt+I Code Inline Code Link H1 H2 Preview Submit your Reply Alt+S Ask a Different Web Development Question Related Articles Execute a PHP command on form Submit 2 replies G'day, I'm currently trying to get a input box with a submit button that puts the command into a string and executes it on a … move_uploaded_file gives 500 internal server error. 5 replies move_uploaded_file gives Internal Server Error The server encountered an internal error or