Blog at WordPress.com. %d bloggers like this: Skip to ContentSkip to FooterSolutions Transform to a Hybrid Infrastructure Protect Your Digital Enterprise Empower the Data-Driven Organization Enable Workplace Productivity Cloud Security Big This was due to my $PATH settings listing the 11107 bin before the 11202 bin [$ORACLE_HOME was irrlevant]). This is the salient error, the SP-1503 error: SP2-1503: Unable to initialize Oracle call interfaceCause: Indicates a library used by SQL*Plus to communicate with the database failed to initialize correctly.Action: Check Posted on 2012-01-16 Oracle Database 3 3 solutions 1,246 Views Last Modified: 2012-05-12 When connecting to oracle from unix, I am getting this following error. this contact form
please help others. –Mowgli Feb 18 '13 at 14:21 Hi @mowgli, I've already left a couple of answers below... Just e-mail: and include the URL for the page. In the Select Users or Group dialog box, click the user account that you want to add, click Add, and then click OK. Click OK to make the change effective 5. https://community.oracle.com/thread/340426
Also, it's not just SQL*Plus that was affected. Thank you! Click Start, point to Programs, point to Administrative Tools, and then click Local Security Policy. 2. I checked the oracle folder but there is db_1 and oradata folder inside product..but no admin folder..
Chmielu Like Show 0 Likes(0) Actions 6. Son's music tastes Help, my office wants infinite branch merges as policy; what other options do we have? Click on User Account Control settings link. 3. Ora-01804: Failure To Initialize Timezone Information asked 2 years ago viewed 8835 times active 2 years ago Blog Stack Overflow Gives Back 2016 Developers, Webmasters, and Ninjas: What’s in a Job Title?
In the Select Users or Group dialog box, click the user account that you want to add, click Add, and then click OK. 6. 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 I'd probably expect that client to work with that server) but that is the hub of the problem. I think its more a question of wrong/incorrect rights on files or directories.
Reply Karl says: January 24, 2014 at 4:34 pm Thank you so much for this post, What had me confused was this was a non issue running XP. Sqlplus Ora-01804: Failure To Initialize Timezone Information Honour has been the reward for what he gave (clavin coolidge) 0 Kudos Robin Geary Advisor Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a You can invoke sqlplus directly from the machine where Oracle resides. Senior Member yes see this please.
Seems to have resolved the issue for me –Edd May 11 at 14:37 add a comment| up vote 2 down vote accepted Fixed my particular issue... Join & Ask a Question Need Help in Real-Time? Sp2-1503 Unable To Initialize Oracle Call Interface 10g Windows 7 share|improve this answer answered Feb 18 '13 at 19:01 Mowgli 1,228154674 Great tip... Sp2-1503 Unable To Initialize Oracle Call Interface Windows 8 Can Mirror Image still work while being grappled?
Re: SP2-1503 when starting sqlplus (privilege problem) 344605 Feb 27, 2007 5:34 PM (in response to 187433) Thanks a lot, ziarkowski! http://somitek.com/to-initialize/unable-to-initialize-oracle-call-interface-windows.html chmod o+r oracore chmod o+r oracore/zoneinfo/timezone.dat or just type from $ORACLE_HOME directory: 0 Featured Post 2016 Annual Membership Survey Promoted by Experts Exchange Want to help improve the Experts Exchange chmod o+r oracore chmod o+r oracore/zoneinfo/timezone.dat or just type from $ORACLE_HOME directory: 2. Re: SP2-1503 when starting sqlplus (privilege problem) 187433 Dec 24, 2011 12:25 PM (in response to 512462) Tried it, maybe it help you (found it on https://www.administrator.de/Zugriff_auf_OracleDB_(10i)_per_sql_plus_von_WTS_2003_(Servicepack_2).html) Best regards Like Show Sp2-1503 Unable To Initialize Oracle Call Interface Windows 10
Re: SP2-1503 when starting sqlplus (privilege problem) 658086 Jan 27, 2009 8:31 AM (in response to 344605) excuse me, i've added users at "create global object" right but i don't know Expertise: The web designers who are experts in this latest technique have the ability to offer the best services regarding theme and plug-ins customization. Other than that, my $ORACLE_HOME/lib, $ORACLE_HOME/bin, $ORACLE_HOME/oracore and $ORACLE_HOME/rdbms all seem reasonable with sensible permissons. http://somitek.com/to-initialize/unable-to-initialize-oracle-call-interface-10g.html Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson BlogSP2-1503: Unable to initialize Oracle call interface tips Oracle
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. Sp2-1503 Unable To Initialize Oracle Call Interface 11gr2 Guess the sensible rule of thumb is to add my $ORACLE_HOME/bin to the front of the $PATH to ensure mine is found first, despite what else is set by whatever other 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 streams take advantage of branch-prediction? Show 13 replies 1. Starting SQL*Plus works when logged on locally to the Windows server console using the non-Administrator OS account. How To Check Oracle_home In Windows Reply Ted says: July 16, 2010 at 6:41 am Hello Thank you for your HELP!!
This was very helpful Like Show 0 Likes(0) Actions 10. After installation this oracle client is able to connect with the database when we login in as a Administrator into the machine/pc. Related Post navigation He Won…..DAXCAD on Sourceforge 12 thoughts on “SQLPLUS - Windows - Administatoronly….” Márcio Caputt says: January 9, 2009 at 12:30 pm Thanks for help. his comment is here We followed the metalink note 417067.1 to resolve it.
Where should a galactic capital be? 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: Expand Local Policies, and then click User Rights Assignment. 3. Get 1:1 Help Now Advertise Here Enjoyed your answer?
The first lists some sites I found useful in my search. Currently, there is still no patch for the client side." They don't say what the one-off patch is :-( 0 Kudos Robin Geary Advisor Options Mark as New Bookmark Subscribe Subscribe In the right pane, double-click Create global objects. 4. Permissions at the OS level aren't set properly after the Oracle 10gR2 install.
Why is Titanic's Astor asking if Jack is from the Boston Dawsons? Oracle Scripts » Categories » Oracle Errors » SP2-1503: Unable to initialize Oracle call interface                                                 Last update (2012-01-03 20:25:15)                                                                                                                   Date added (2011-12-30 21:53:24) Summary After upgrade from Oracle 10g, or Oracle 11gR1 asked 4 years ago viewed 25533 times active 3 days ago Blog Stack Overflow Gives Back 2016 Developers, Webmasters, and Ninjas: What’s in a Job Title? Click OK.
After installation this oracle client is able to connect with the database when we login in as a Administrator into the machine/pc. In the Local Security Policy Setting dialog box, click Add. 5. N.B: There's a plethora of stuff on-line but, as is often the case, there's a lot of case-specific issues and mainly around different versions of Windows. Additionally, I had no such problems with my previous Oracle install (10.2.0.7).
I'll report back any sensible findings. 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 Grateful Like Show 0 Likes(0) Actions 12. thanks!
Snowman Bowling What is the cheapest way to get permanent flying for a party lower than level 11? Connect with top rated Experts 17 Experts available now in Live!