After installation this oracle client is able to connect with the database when we login in as a Administrator into the machine/pc. Regards Raffi Join this group Popular White Paper On This Topic Big Data and the CMO: An Introduction to the Challenge and the Opportunity 2Replies Best Answer 0 Mark this reply Before you try accessing Oracle from a client, try accessing Oracle from the server itself. SQL*Plus should be working now. $sqlplus [email protected] See if that helps. this contact form
The user account that is used to run the program does not have the "Create global objects" user right. I didn't know about "create globals" earlier, so I ended up in running the program as Administrator as a workaround. Also, it's not just SQL*Plus that was affected. 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
Click OK. 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. ODBC Error , sqlstate=im004 , SQL_HANDLE_ENV , sqlallochandle Reply Ramesh says: October 8, 2010 at 2:16 pm Thanks for your post It's working …….
In the right pane, double-click Create global objects. 4. In the Select Users or Group dialog box, click the user account that you want to add, click Add, and then click OK. 6. i run again utlu1121.sql in the client side...I didn't find any error there. Sp2-1503 Unable To Initialize Oracle Call Interface Windows 10 Then, you can look at accessing sql*Plus from a SQL*Net client.
Assign the "Create global objects" user right to the non-Administrator account. 1. Sp2-1503 Unable To Initialize Oracle Call Interface 10g Windows 7 When hiking, why is the right of way given to people going up? 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. http://www.orafaq.com/forum/t/153290/ 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
Script help needed Blog Articles Catastrophic CICS - pronounced 'KICKS' The 60's - IBM & the Seven Dwarves Flames in the mailbox Companies Oracle Toolbox for IT My Home Topics People Ora-01804: Failure To Initialize Timezone Information Therefore, you can easily devise your special settings for your website. Reply wordpress developer says: July 24, 2013 at 5:58 pm In addition to it, the complete SPAM protection of your weblog is guaranteed. Hope this helps someone.
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: weblink SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly Thanks Kumar Gautam Thursday, November 06, 2014 7:16 AM Reply | Quote All replies 0 Sign in Thursday, November 06, 2014 9:07 AM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. I found the same error again when i want to open sqlplus. Sp2-1503 Unable To Initialize Oracle Call Interface Windows 8
what shud i do to make it work... Like Show 0 Likes(0) Actions 8. Verify experience! http://somitek.com/to-initialize/unable-to-initialize-oracle-call-interface-windows.html 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.
Like Show 0 Likes(0) Actions 7. Sqlplus Ora-01804: Failure To Initialize Timezone Information I just right-clicked on the shortcut for the gui app and selected "Run as Administrator" and SQLPlus ran just fine. Action Check that the Oracle environment or registry entries are consistent and correct.
Please don't test any post on production servers until you are sure. Re: SP2-1503 when starting sqlplus (privilege problem) 699068 Apr 30, 2009 3:40 AM (in response to 536042) In control panel, search UAC and turn it off. Cause The issue is related to a Windows Security configuration. How To Check Oracle_home In Windows Can I disarm and immediately grapple with Tavern Brawler?
The workaround is to unset the variable and then call sqlplus again $unset ORA_TZFILE $sqlplus "/ as sysdba" sql> If you use Oracle E-Business Suite 11i or R12 then you have But when i try to run sqlplus from command prompt...It retrns error.. But it was not working. Then I stumbled on your post and was able to run my program without admin rights and now both SQL*Plus and my PB app.
Browse other questions tagged oracle windows-8.1 or ask your own question. I do not have access to MetaLink, and thought I could get a quicker response from here than our DB team. Report message to a moderator Re: oracle 10gR2 in Windows 7 ultimate [message #435922 is a reply to message #435914] Sat, 19 December 2009 01:13 Michel Cadot Messages: Second law of thermodynamics doubt Sever-sort an array How to select a good sleeping bag liner In 4/4 time can I insert a half sized bar in the middle of the
The problem is caused by a security policy called "Create Global Objects". I've been involved in delivering lectures and technical workshops on Oracle in various colleges and universities in Pakistan. Please type your message and try again. In the Local Security Policy Setting dialog box, click Add. 5.
Listener and database service is started.. Click OK to make the change effective 5. You can not post a blank message. Sorted!
Your solutions worked for me in windows 7 for oracle 10g. Click Start, point to Programs, point to Administrative Tools, and then click Local Security Policy. 2. Pakistan View my complete profile Powered by Blogger. In the right pane, double-click Create global objects. 4.