somitek.com

Home > To Initialize > Unable To Initialize Oracle Call Interface Linux

Unable To Initialize Oracle Call Interface Linux

Contents

I went to client side and open sqlplus. share|improve this answer answered Dec 19 at 11:55 Brijesh Rana 11 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign getting this error after upgrade to Oracle 11g. Also, it's not just SQL*Plus that was affected. navigate here

SP2-1503: Unable to initialize Oracle call interface . I get the following errors:$ sqlplusSP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properlyWhat causes the SP-1503 and SP-0152 errors? Do you think this is a good solution from a security perspective?Metalink says, "There is a one-off patch for the base bug 4516865, but this fixes the permissions problem only on So, on starting sqlplus, I was running the ora11.1.0.7 sqlplus client against the 11.2.0.2 server. http://www.dba-oracle.com/t_sp_1503_unable_to_initialize_call_interface.htm

Sp2-0152 Oracle May Not Be Functioning Properly Linux

Feel free to ask questions on our Oracle forum. In the Select Users or Group dialog box, click the user account that you want to add, click Add, and then click OK. Oracle Error :: SP2-1503 Unable to initialize O... Solved SP2-1503 error on connecting to oracle.

  1. When i run sqlplus as an administrator, it is invoking.
  2. But it was not working.
  3. Cause The issue is related to a Windows Security configuration.
  4. Though I had no issues during install I wasn't able to run sqlplus, either via the gui or through the command prompt.

Came across this little chsnut on win2k recently - how to make SQLPLUS work on Citrix - with non admin users - handy alright! - This works a charm.  Applies to: Oracle SQL> sqlplus / as sysdba <==== what do you get check $ ps -ef|grep pmon <=== if oracle is running or not 0 LVL 18 Overall: Level 18 Oracle Database linux oracle11g sqlplus opensuse share|improve this question edited Jan 9 '12 at 14:56 asked Jan 9 '12 at 14:47 wmorrison365 2,78011425 Think I may have a problem with my Sp2-1503 Unable To Initialize Oracle Call Interface Windows 10 From there you can link to the bug description. 0 Kudos Yogeeraj_1 Honored Contributor Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report

share|improve this answer answered Nov 6 '14 at 7:22 Lalit Kumar B 27.4k82749 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Sp2-1503 Unable To Initialize Oracle Call Interface 10g Windows 7 oracle windows-8.1 share|improve this question asked Nov 6 '14 at 7:18 Kumar 100214 1 Provide normal users necessary privileges to run Oracle client utility, most likely this could be privileges I was not able to upgrade my system after that. http://stackoverflow.com/questions/8790181/oracle-error-when-executing-sqlplus-sp2-1503-unable-to-initialize-oracle-call Regards, Tony.

Expand Local Policies, and then click User Rights Assignment. 3. Ora-01804: Failure To Initialize Timezone Information However, when I migrated the users to a Window 7 machines I knew there must have been some issue with writing files to directory the user did not have permission for. Action: Make a note of the message and the number, then contact the Database Administrator. Privacy Policy Support Terms of Use

Sp2-1503 Unable To Initialize Oracle Call Interface 10g Windows 7

Why wouldn't the part of the Earth facing the Sun a half year before be facing away from it now at noon? https://community.hpe.com/t5/Databases/SP2-1503-Unable-to-initialize-Oracle-call-interface/td-p/4969551 I added full-control for Authenticated Users under file properties for the client_1 folder (right click on folder, Security tab). Sp2-0152 Oracle May Not Be Functioning Properly Linux All rights reserve... Sp2-1503 Unable To Initialize Oracle Call Interface Unix What is a "frozen ATPL"?

What are the considerations for waterproofing a building's first few floors? check over here One of the solution given is to do "chmod -R 755 $ORACLE_HOME", a recursive permission command. PCMag Digital Group AdChoices unused Oracle DBA Basement Stellios' Oracle DBA Blog Thursday, February 23, 2012 SP2-1503: Unable to initialize Oracle call interface; SP2-0152: ORACLE may not be functioning properly When ORACLE_HOME=/oracle_path/client/ Remember without slash ('/') at the end !!!!!! Sp2-1503 Unable To Initialize Oracle Call Interface Windows 8

In the Local Security Policy Setting dialog box, click Add. 5. Make sure you have read access to the libraries. Powered by Blogger. his comment is here I tried even that.

Covered by US Patent. Sqlplus Ora-01804: Failure To Initialize Timezone Information Re: SP2-1503 when starting sqlplus (privilege problem) 34851 Nov 7, 2005 1:31 PM (in response to Jens Petersen) thanks, thats the same problem Like Show 0 Likes(0) Actions 5. Check if the DISPLAY variable is set.

In UNIX/Linux, you will see the standard background processing running (PMON, SMON, &c).

Reply Leave a Reply Cancel reply Enter your comment here... Starting SQL*Plus works when logged on locally to the Windows server console using the non-Administrator OS account. chmod o+r oracore chmod o+r oracore/zoneinfo/timezone.dat or just type from $ORACLE_HOME directory: Go to Solution 2 2 Participants sventhan(2 comments) LVL 18 Oracle Database16 schwertner LVL 47 Oracle Database47 3 Comments Sp2-1503 Unable To Initialize Oracle Call Interface 11gr2 Re: SP2-1503 when starting sqlplus (privilege problem) 470926 Nov 22, 2005 2:19 PM (in response to 34851) Solution: IF you have error like: SP2-1503: Unable to initialize Oracle call interface SP2-0152:

the software installation competed successfully. I'm not sure how to use this information to run it in command mode but I'm sure it's possible. This was due to my $PATH settings listing the 11107 bin before the 11202 bin [$ORACLE_HOME was irrlevant]). http://somitek.com/to-initialize/unable-to-initialize-oracle-call-interface-10g.html On 32-bit Linux the lib directory under the ORACLE_HOME is $ORACLE_HOME/lib32 so set: export LD_LIBRARY_PATH=${ORACLE_HOME}/lib32:${LD_LIBRARY_PATH} Posted by stellios Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: SP2-0152: ORACLE may not

Permissions at the OS level aren't set properly after the Oracle 10gR2 install. Join & Ask a Question Need Help in Real-Time? Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. I'll report back any sensible findings.

I found the same error again when i want to open sqlplus. I just right-clicked on the shortcut for the gui app and selected "Run as Administrator" and SQLPlus ran just fine. Please turn JavaScript back on and reload this page. If you are experiencing a similar issue, please ask a related question Suggested Solutions Title # Comments Views Activity oracle query 15 64 80d Last record chosen in Oracle Query 3

It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g. Get 1:1 Help Now Advertise Here Enjoyed your answer? Like Show 0 Likes(0) Actions 8.