Home > Error 6 > Error 6 Initializing Sqlplus Windows

Error 6 Initializing Sqlplus Windows


I installed oracle as a user named oracle, so I tried putting the variable in /home/oracle/.bash_profile . For most folks, they don't know, what they don't know. Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM SET ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\ server You can lead some folks to knowledge, but you can not make them think. Check This Out

Whats wrong ppl? Regards Syed Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... If possible find the similar home in your servers list and copy SQLPLUS folder from source ORACLE_HOME to the target (problem server) ORACLE_HOME. Please help!! http://stackoverflow.com/questions/28482661/oracle-home-error-6-initializing-in-windows

Oracle Error 6

I am not sure if they are both started TNS-12541: TNS:no listener This error would suggest that you haven't checked that they have both started. 90% of users' problems can be If the user attempting to run SQL*Plus does not have read permission on this directory, any part of the path, or on the files themselves, you will also have this sort Join our community for more solutions or to ask questions. Experience comes from bad judgement.

Home | Invite Peers | More Oracle Groups Your account is ready. Use the 11g listener! Kevin Closson's Oracle Blog: Platform, Storage & Clustering Topics Related to Oracle Databases How Many ASM Disks Per Disk Group And Adding vs. Error 6 Initializing Sql*plus Linux What would happen if I created an account called 'root'?

template. Sqlplus Error 6 Initializing Sql*plus Note I'm using oracle 11g on WIN server 2003 ERROR DESCRIPTION: Error 6: Initializing sql*plus Message File sp1.msb not found Sp2-0750: you may need to set ORACLE_HOME to your oracle Directory Privacy Policy Site Map Support Terms of Use Skip to content My Previous Experience More information you Share, More information you Get. learn this here now Is it permitted to not take Ph.D.

Volume Serial Number is 189B-D4C6 Directory of C:\oraclexe\app\oracle\product File Not Found note: now the second command like 'dir ORACLE_HOME' C:\Windows\system32>dir ORACLE_HOME Volume in drive C has no label. Sp2-0667 Windows Syntax Design - Why use parentheses when no arguments are passed? Thanks. What should I do?

Sqlplus Error 6 Initializing Sql*plus

Thanks Report message to a moderator Re: Error 6 initializing SQL*Plus [message #596762 is a reply to message #596761] Thu, 26 September 2013 04:17 John Watson Messages: 6429Registered: Reply With Quote 03-02-13,12:01 #10 yunqhero View Profile View Forum Posts Registered User Join Date Mar 2013 Posts 8 Now, the TNS: protocol adapter error is showing up. (I CANT WIN) Oracle Error 6 Browse other questions tagged oracle sqlplus or ask your own question. Sqlplus Oracle_home Pull up command prompt: echo %PATH% You want the path to your 10g bin as the very first thing in PATH.

Promoted by Experts Exchange Engage with tech pros in our community with native advertising, as a Vendor Expert, and more. http://axishost.net/error-6/error-6-initializing-sqlplus-crontab.php If you want to login to the 11g database (from command prompt): set PATH=;%PATH% echo %PATH% ==> This should now have the path to the 11g BIN Is this what's causimg the problem? Do I need to water seeds? Error 6 Initializing Sqlplus Sp2-0667 Sp2-0750

set ORACLE_HOME=D:\app\RafiAlvi\product\11.2.0\dbhome_1 set PATH=%ORACLE_HOME%\bin;%PATH% set ORACLE_SID=ORCL sqlplus "/as sysdba" Oracle 10g: Pre-requistics step: Make sure you are started services for Oracle 10g listener and Database in your machine. Set LIBPATH to include the directory where the instant client is stored. Become Oracle Apps DBA Atul's Blog Posts on onlineAppsDBA.com José Oracle DBA's Blog Oracle Learning Library (OLL) Murali valath's Blog Summersky RAC Notebook Navdeep Practical Apps DBA Ashish Agarwal - Freelance this contact form I have worked on that 2 days.

When I start sqlplus promt, I get the following error $ sqlplus Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle Error 6 Initializing Sql*plus Unix Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Identifying a Star Trek TNG episode by text passage occuring in Carbon Based Lifeforms song "Neurotransmitter" Was any city/town/place named "Washington" prior to 1790?

Thanks, Luan.

The average person thinks he's above average! Tenant claims they paid rent in cash and that it was stolen from a mailbox. Reply With Quote 03-02-13,11:09 #6 anacedent View Profile View Forum Posts Registered User Join Date Aug 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Answers: Sp2-0667 Sp2-0750 Windows What's the last character in a file?

Unzip the ODBC Instant Client package, then execute the odbc_update_ini.sh script with Driver Manager installed directory as a command line argument. (For complete syntax, please run "odbc_update_ini.sh" without any command line Good judgement comes from experience. Awesome Inc. http://axishost.net/error-6/error-6-initializing-sqlplus-oracle.php Related 1650How do I install pip on Windows?2Windows could not start DBConsole for new database instance0SP2-0750: You may need to set ORACLE_HOME0Trouble setting Enivronment variable ORACLE_HOME2Oracle XE 11g (windows 8) I

Ravinder Top Best Answer 1 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Oracle Apps Blog SOA Upgrade -> Applications DBA Arena RMAN failure after BP#11 upgrade Rakesh Soni - DBA 11g DBA Certified. Not the answer you're looking for? No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers

MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Ask a Question Ask Connect with top rated Experts 14 Experts available now in Live! sorry. How to challenge optimized player with Sharpshooter feat Using -njo and -cxjo for family members Did Umbridge hold prejudices towards muggle-borns before the fall of the Ministry?

We have to migrate to 11gr2 for all environments and due to Gov't IA restrictions, we cannot have passwords in our load processing scripts, ETL scripts, any script basically. What feature of QFT requires the C in the CPT theorem? [email protected]:> su – oracle /u01/mts/Pl-sql   [email protected]:> oraenv ORACLE_SID = [root] ? Having the devotion,passion and dedication to learn & Work in Oracle field mail me @ [email protected]"Knowledge grows when it is shared".

You're now being signed in. Good judgement comes from experience. PATH is used by Windows to launch programs. Reply With Quote 03-02-13,11:02 #5 yunqhero View Profile View Forum Posts Registered User Join Date Mar 2013 Posts 8 Albeit, can you offer a proper suggestion that I (the problem) can

I dedicate this Blog to MY WIFE,LOVELY DAUGHTER & Oracle Experiments,Interviews & Practices. SQL> (Not sure what to do here to go further) Reply With Quote 03-02-13,12:40 #13 yunqhero View Profile View Forum Posts Registered User Join Date Mar 2013 Posts 8 I tried Best regards, Rafi. you need to set its value as "..server", or "...92" –Tyler Feb 12 '15 at 17:14 could you tell me please step by step what i should do exactly

Error 6: Initializing sql*plus Umair Mustafa asked Jun 22, 2011 | Replies (9) Hello World, required a little help on a issue and i'm not able to solve it on my Can Homeowners insurance be cancelled for non-removal of tree debris? In order to have this work, SQLNET.AUTHENTICATION_SERVICE = (NTS) needs to be in the sqlnet.ora file.