Home > Error 6 > Error 6 Initializing Sqlplus

Error 6 Initializing Sqlplus

Contents

Please turn JavaScript back on and reload this page. All Rights Reserved. Set any Oracle globalization variables required for your locale. Instead of the above value you give, I would try export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0 share|improve this answer edited Apr 30 '10 at 21:22 answered Apr 30 '10 at 21:17 DCookie 28.7k74765 have a peek here

Then SQLPlus was able to launch. Used MacBook Pro crashing Can Homeowners insurance be cancelled for non-removal of tree debris? If so, is there a reference procedure somewhere? Polar Coordinates in sets more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts

Error 6 Initializing Sqlplus Windows

Define the TNS_ADMIN environment variable to point the .ora files directory for OCI. This search path includes looking in the directory $ORACLE_HOME/network/admin/tnsnames.ora. Is the NHS wrong about passwords? wants *.msb files up vote 2 down vote favorite 1 Installed sqlplus from oracle downloads.

share|improve this answer answered Oct 22 '14 at 16:24 user50802 111 add a comment| up vote 1 down vote I just deployed Instant Client in a directory and after updating LD_LIBRARY_PATH Browse other questions tagged sqlplus or ask your own question. Favorite Blog List Education Notice দেখ, খালি গলায় শালী কি অসাধারণ গান গায়। চোখে পানি চলে এলো ভাই। Oracle DBA - Tips and Techniques « Oracle DBA - Tips and Techniques Error 6 Initializing Sql*plus Linux Let's do the Wave!

copying again Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory Report message to a moderator Like Show 0 Likes(0) Actions 4. asked 3 years ago viewed 1224 times Related 4EXPORT AS INSERT STATEMENTS: But in SQL Plus the line overrides 2500 characters!2Error 6 Initializing SQL*Plus0SQL*PLUS SET Command0SQL*Plus 'crashes' with insert query on http://www.orafaq.com/forum/t/189652/ Oracle Enterprise Manager "EM daemon is not running" dbconsole status (Oracle 10g, 11g) Oracle Enterprise Manager "EM daemon is not running" dbconsole status 1.

The other answered seemed to work. –coderintherye May 3 '10 at 17:47 Thanks for your answer. Error 6 Initializing Sqlplus Sp2-0667 Sp2-0750 Why can't QEMU allocate the memory if the Linux caches are too big? export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 sqlplus / as sysdba share|improve this answer answered Jun 28 '14 at 15:02 karthikeyan 111 add a comment| up vote 1 down vote After installing weblogic and forms server Re: SQLPLUS Error 6 Initializing SQL*PLUS Peter Gjelstrup Jan 28, 2009 1:55 AM (in response to 681712) Hi, That looks a lot like [problem in this thread|http://forums.oracle.com/forums/thread.jspa?threadID=104162&tstart=0] Regards Peter Like Show

Error 6 Initializing Sql Plus

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed http://stackoverflow.com/questions/6013508/error-6-initializing-sqlplus I do no thave a db_1. Error 6 Initializing Sqlplus Windows Now throw in the fact you need to have two oracle_homes, the existing 10gr2 home and now a new 11gr2 home so the dev team can test their ETL scripts against Sqlplus Oracle_home Please type your message and try again.

Not the answer you're looking for? http://axishost.net/error-6/error-6-initializing-sqlplus-crontab.php We altered the bash_profile in a way that the forms_home acts as the oracle home. Unpacked both files instantclient-basic-linux.x64-12.1.0.1.0.zip instantclient-sqlplus-linux.x64-12.1.0.1.0.zip sqlplus fails to start with this 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 I experienced similar problem, in one of my customers, Half of the folders in OraHome had been accidently deleted by the IT Guy. Error 6 Initializing Sql*plus Windows

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 ... Pull up command prompt: echo %PATH% You want the path to your 10g bin as the very first thing in PATH. 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 Check This Out Can my boss open and use my computer when I'm not present?

Does the string "...CATCAT..." appear in the DNA of Felis catus? Error 6 Initializing Sqlplus Unix I installed oracle as a user named oracle, so I tried putting the variable in /home/oracle/.bash_profile . Labels Android 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

Thanks, Luan.

Physically locating the server more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / From command prompt: echo %ORACLE_SID% Same as above, you don't want anything as a value. Has Tony Stark ever "gone commando" in the Iron Man suit? 2048-like array shift What's the last character in a file? Error 6 Initializing Sql*plus Unix How do I debug an emoticon-based URL?

Using -njo and -cxjo for family members What brand is this bike seat logo? Perhaps someone else feels able to assist. Three rings to rule them all Using -njo and -cxjo for family members Is a comma needed after an italicized thought as it is with a quote? this contact form asked 1 year ago viewed 2397 times active 2 months ago Related 1650How do I install pip on Windows?2Windows could not start DBConsole for new database instance0SP2-0750: You may need to

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed How many Oracle installations are on this computer?