Error 6 Initializing Sqlplus Windows
Contents |
[message #596761] Thu, 26 September 2013 04:10 shekhar.salunkhe Messages: 154Registered: January 2008 Location: Pune Senior Member Hi oracle error 6 All, I have created oracle 11 XE .. Once it
Sqlplus Error 6 Initializing Sql*plus
is created it was running fine. I have worked on that 2 days. Problem is occured sqlplus oracle_home when I restart my machine.. I m getting below error: Error 6 initializing SQL*Plus Message file sp1
Error 6 Initializing Sqlplus Sp2-0667 Sp2-0750
ORACLE_HOME to your Oracle software directory I have checked the forum in which it is mentioned that ORACLE_HOME is not properly set. I tried that one alot of time. Even now environment variable shows proper value. Please help me out. Thanks Report message to a moderator Re: Error 6 error 6 initializing sql*plus linux initializing SQL*Plus [message #596762 is a reply to message #596761] Thu, 26 September 2013 04:17 John Watson Messages: 6429Registered: January 2010 Location: Global Village Senior Member Please can you show you current settings for the environment variables ORACLE_HOME and PATH? Then the command WHERE SQLPLUS, and the error? 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 am Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Inte IPT;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\ )\PuTTY;"c:\Program Files\Windows NT\Accessories";C:\Program Files (x86)\Nmap c:\users\john>where sqlplus c:\app\oracle\product\12.1.0\dbhome_1\BIN\sqlplus.exe C:\app\oracle\product\11.2.0\db112\BIN\sqlplus.exe c:\users\john>sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 26 10:16:59 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options orclz>Use a CMD pr
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your
Sp2-0667 Windows
message and try again. More discussions in iSQL*Plus [ARCHIVE] All PlacesOracle CommunityArchived ForumsiSQL*Plus [ARCHIVE]
Error 6 Initializing Sql*plus Unix
This discussion is archived 4 Replies Latest reply on Aug 18, 2011 3:13 PM by wolfeet SQLPLUS Error 6 Initializing SQL*PLUS 681712 sp2-0667 sp2-0750 windows Jan 26, 2009 6:54 PM ok, so up front, let me tell you I have been charged with becoming well versed in Oracle, which I have not used since college (6+ yrs)... I have installed Oracle http://www.orafaq.com/forum/t/189652/ Enterprise Linux 5.2 on a VM, and installed Oracle 11g. 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
not found Error: Error 6 initializing SQL*Plus SP2-0667: Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your http://oracle-solution.blogspot.com/2014/08/error-6-initializing-sqlplus-sp2-0667.html Oracle software director [oracle@bachapp mesg]$ /u01/app/oracle/product/11.2.0/db_1/bin/sqlplus Error 6 initializing SQL*Plus SP2-0667: Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory Reason: ORACLE_HOME and ORACLE_SID not set properly. Solution: [oracle@bachapp mesg]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1/ [oracle@bachapp mesg]$ export PATH=$PATH:$ORACLE_HOME/bin [oracle@bachapp mesg]$ export ORACLE_SID=orcl [oracle@bachapp mesg]$ sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Sun error 6 Aug 31 11:16:34 2014 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter user-name: /as sysdba Connected to an idle instance. Posted by Said Rasel at 22:35 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Database Administration, SQLPLUS problem Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search This Blog Loading... Labels Android error 6 initializing Solution (4) Data Guard (13) Data Pump (10) Database Administration (6) Database backup/restore (5) Linux (33) MS SQL (11) MS SQL Server Database 2008 (2) MS Windows (8) Nagios (6) Oracle (3) Oracle Cloud Control 12c (7) Oracle DB Administration (36) Oracle Forms Developer (4) Oracle RAC (4) RMAN (14) WebLogic 11g (11) Windows 10 Problem (1) Windows 8/10 - Fix This app can't open for Built-in Administrator account (1) Yum configure in Linux (3) Popular Posts The ordinal 12404 could not be located in the dynamic link library mfc90u.dll. Problem: I am getting this error when trying to open Samsung Kies 3 after new installation: The ordinal 12404 could not be located in t... ORA-00980: synonym translation is no longer valid "ORA-00980: synonym translation is no longer valid" is a common error encountered in a development environment. This can happen f... 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