Like this:c:\users\john> c:\users\john>echo %ORACLE_HOME% c:\app\oracle\product\12.1.0\dbhome_1 c:\users\john>echo %PATH% c:\app\oracle\product\12.1.0\dbhome_1\bin;C:\app\oracle\product\12.1.0\dbhome_1\bin;C:\app\oracl in\bin;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\ tem32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL SDK\2 Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files\Sony\VAIO Improvement;C:\Program Files (x86)\Sony\ am Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Managem For example on Linux to set NLS_LANG: setenv NLS_LANG JAPANESE_JAPAN.JA16EUC share|improve this answer answered Dec 15 '14 at 14:20 Pascal 211 Why do you think that the OP wants He has installed Oracle XE 11.2 on Fedora 18. Syntax Design - Why use parentheses when no arguments are passed? http://axishost.net/error-6/error-6-intializing-sql.php
I m getting below error: Error 6 initializing SQL*Plus Message file sp1
Join our community for more solutions or to ask questions. Featured Post Do You Know the 4 Main Threat Actor Types? 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. Sundararasu Chinnathambi replied Apr 21, 2012 Dear All, Please help me on the same issue.
Does anyone have any insight on how to fix this error? Also your current path has three versions of Oracle behind E:\oracle\PROD\apps\tech_st: 10.1.2, 10.1.3, and 11.1.0. Notices Welcome to LinuxQuestions.org, a friendly and active Linux Community. Error 6 Initializing Sqlplus Unix Whenever I go to command line and invoke ./sqlplus hr, it comes back with the following error: Error 6 initializing SQL*Plus Message file sp1
Enter user-name: /as sysdba Connected to an idle instance. Last edited by sag47; 01-05-2015 at 11:21 PM. You must learn to use your operating system. Configure RMAN to purge archivelogs after applied on standby Applicable: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 GOAL: We need RMAN to automatically purge archivelogs from ...
share|improve this answer answered Dec 15 '14 at 13:52 Pascal 211 add a comment| up vote 1 down vote And sometimes following Oracle documentation solves quite some hassle. Sp2-0667 Windows Are you new to LinuxQuestions.org? All rights reserved. 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
If ORACLE_HOME is not set, then looks in current directory for tnsnames.ora. Get More Info Re: SQLPLUS Error 6 Initializing SQL*PLUS lnim-Oracle Mar 6, 2009 8:35 AM (in response to Peter Gjelstrup) You normally get this message if your ORACLE_HOME is not set. Error 6 Initializing Sql*plus Windows Not the answer you're looking for? Error 6 Initializing Sqlplus Sp2-0667 Sp2-0750 Problem is occured when I restart my machine..
So the issue is that whenever i try to run SqL Plus this error shows up in CMD. If you need to reset your password, click here. 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 Perhaps someone else feels able to assist. Error 6 Initializing Sql*plus Unix
You should not adatp the problem to your solution :-) –miracle173 Dec 15 '14 at 14:31 add a comment| Your Answer draft saved draft discarded Sign up or log in Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows Tenant claims they paid rent in cash and that it was stolen from a mailbox. Find More Posts by sag47 View Blog 01-02-2015, 03:34 AM #3 santosh0782 Member Registered: Nov 2013 Posts: 132 Original Poster Rep: the complete path for sqlplus is: Code: barza_uat_app1
Standard way for novice to prevent small round plug from rolling away while soldering wires to it How do hackers find the IP address of devices? Sp2-0667 Sp2-0750 Windows You can reproduce this on your UNIX by running the command as a user that does not have Oracle related profile setup. [[email protected]]# sqlplus / as sysdba Error 6 initializing SQL*Plus Is a comma needed after an italicized thought as it is with a quote?
syed ali replied Apr 23, 2012 Check the registry. santosh0782 View Public Profile View LQ Blog View Review Entries View HCL Entries Find More Posts by santosh0782 01-02-2015, 01:33 AM #2 sag47 Senior Member Registered: Sep 2009 Location: All product names are trademarks of their respective companies. Sp2-0750 Oracle_home In Windows All rights reserved.
They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own. unSpawn View Public Profile View LQ Blog View Review Entries View HCL Entries Find More Posts by unSpawn View Blog 01-03-2015, 07:52 PM #5 sag47 Senior Member Registered: Sep Go to Solution 3 Comments LVL 3 Overall: Level 3 Oracle Database 3 Message Expert Comment by:Yogesh_Yadav2005-10-10 Hi, Here is cause of this problem and the possible solution: New Speed and Velocity in German Can two different firmware files have same md5 sum?
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 Visit the following links: Site Howto | Site FAQ | Sitemap | Register Now If you have any problems with the registration process or your account login, please contact us. Thanks, Luan. Are there any saltwater rivers on Earth?
And now you use SMS-speak at me. Only trial and error will tell. What are the drawbacks of the US making tactical first use of nuclear weapons against terrorist sites? Success!
You're now being signed in. Photoshop's color replacement tool changes to grey (instead of white) — how can I change a grey background to pure white? Set LIBPATH to include the directory where the instant client is stored. You mention 9.2 in your PATH, but your oracle home mentions 11.2.
Solved Error 6 initializing SQL*Plus Posted on 2005-10-10 Oracle Database 1 Verified Solution 3 Comments 39,921 Views Last Modified: 2012-06-21 Hi Experts, Recently I installed oracle on an AIX machine.