Home > Error 6 > Error 6 Initializing Sqlplus Oracle Client

Error 6 Initializing Sqlplus Oracle Client

Contents

Like Show 0 Likes(0) Actions 7. Photoshop's color replacement tool changes to grey (instead of white) — how can I change a grey background to pure white? How many users are expected? LIBPATH is required to include the directory of the instant client libraries. http://axishost.net/error-6/error-6-initializing-sqlplus-oracle.php

The installation was done in a difference Oracle Home however I get this error when running sqlplus for the Oracle 11.2.0.1 instance: Error 6 initializing SQL*Plus SP2-0667: Message file sp1.msb not EdStevens Dec 30, 2009 1:48 AM (in response to 367117) ordba wrote: EdStevens wrote: rmmangin wrote: Other than instantclient-sqlplus-linux32-11.2.0.1.zip and instantclient-basic-linux32-11.2.0.1.zip and instantclient-sdk-linux32-11.2.0.1.zip I've never tried to install instant client on Manjit Raja replied Jul 10, 2014 For multiple Oracle homes on the same server, we set the path so the Oracle home we want to use is at the beginning of Re: sqlplus with Instant Client? check it out

Error 6 Initializing Sqlplus Windows

The average person thinks he's above average! Using the DB server install, can you also run tnsping and sqlplus and give us the results? You're now being signed in. Report message to a moderator Re: Error 6 initializing SQL*Plus [message #596803 is a reply to message #596791] Thu, 26 September 2013 07:05 shekhar.salunkhe Messages: 154Registered: January 2008

Sundararasu Chinnathambi replied Apr 21, 2012 Dear All, Please help me on the same issue. 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 RMAN> Top White Papers and Webcasts Popular Best Practices for SMB BI Related HP ProLiant Gen8 Servers: SMB Impact Assessment Using Virtualization to Balance Work with TCO Lab Validation Report: IBM Sqlplus Sql Developer In your case, that would be: E:\oracle\PROD\apps\tech_st\10.1.2\ If this does not work, or if your ORACLE_HOME is set correctly, you need to examine the security settings on the path containing the

Report message to a moderator Re: Error 6 initializing SQL*Plus [message #596782 is a reply to message #596774] Thu, 26 September 2013 05:38 shekhar.salunkhe Messages: 154Registered: January 2008 Sqlplus Error 6 Initializing Sql*plus All rights reserved. yes - Did you check group membership of the installing user? http://stackoverflow.com/questions/18321283/sqlplus-fails-to-start-wants-msb-files jrajasekhar_mca replied Apr 23, 2012 Hi Sundar, This could be problem with .msb files misisng at ORACLE_HOME path.

Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the Toad Oracle Client 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. Good judgement comes from experience. Train and bus costs in Switzerland Are there any saltwater rivers on Earth?

Sqlplus Error 6 Initializing Sql*plus

Again, thanks all. When I run sqlplus it errors out with "SP2-0667: Message file sp1.msb not found". Error 6 Initializing Sqlplus Windows Not the answer you're looking for? Sqlplus Oracle Download rmmangin Dec 29, 2009 10:30 PM (in response to 662100) Thanks everyone for the suggestions.

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 http://axishost.net/error-6/error-6-initializing-sqlplus-crontab.php Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... kevinedba replied Jul 22, 2014 type in --> which sqlplus when it gives you the path to sqlplus ensure that all of your Oracle environment variables are using the same path http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ape.htm#CHDJCDFA Hope this help. Sqlplus Oracle_home

I've definitely seen it happen in Unix when someone got too vigorous in trying to do security lockdowns. Ie: ORACLE_BASE=/home/jimmy/app; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/client_1; export ORACLE_HOME Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Why don't you do the client install on a separate server? (app server) Hope this helps Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be http://axishost.net/error-6/error-6-initializing-sqlplus-instant-client.php 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

Browse other questions tagged windows oracle oracle11g or ask your own question. Sqlldr Oracle Client After installation, set all the environment variables then tried to run SQLPLUS and received an error: Error 6 initializing SQL*Plus SP2-0667: Message file sp1.msb not found SP2-0750: You may need to MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...

The instantclient-sqlplus package does not have any *.msb files in it.I've never tried to install instant client on a *nix platform, but going to the download page I see this: Instant

Re: sqlplus with Instant Client? More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 Previous Next 15 Replies Latest reply on Mar 16, 2013 12:25 AM by waldyd sqlplus rjngh2005 replied Jul 10, 2014 Please run the following command on the user account env|grep ORACLE and post the message Top Best Answer 0 Mark this reply as the best answer?(Choose Error 6 Initializing Sqlplus Windows 7 Home | Invite Peers | More Oracle Groups Your account is ready.

All product names are trademarks of their respective companies. Michel BRANDELIK replied Jul 15, 2014 On client software install, TNSPING gives you a message similar to sqlplus.... Join our community for more solutions or to ask questions. this contact form Did you typo ORACLE_HOME here, or is that what you actually used?

share|improve this answer answered Jun 18 '14 at 13:03 Gandolf989 97737 add a comment| up vote 1 down vote I was able to resolve this issue by copying the contents of SP2-0667: Message file sp1.msb not found Nate Himmons asked Jul 9, 2014 | Replies (14) On a Linux server already running an Oracle 11.2.0.3 with ASM. wants *.msb files up vote 2 down vote favorite 1 Installed sqlplus from oracle downloads. Re: sqlplus with Instant Client? 367117 Dec 29, 2009 7:17 PM (in response to rmmangin) Can you please post the output of env | sort Is NLS_LANG set ?

Define the TNS_ADMIN environment variable to point the .ora files directory for OCI. All rights reserved. -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list Spacewalk-list redhat com https://www.redhat.com/mailman/listinfo/spacewalk-list Follow-Ups: Re: [Spacewalk-list] SP2-0750: You may need to set ORACLE_HOME toyourOracle software directory Env variables in profile: ORACLE_BASE=/home/jimmy/app ORACLE_HOME=$ORACLE_BASE/product/11.2.0/client_1 ORACLE_HOME_LISTNER=$ORACLE_HOME/network/admin TNS_ADMIN=$ORACLE_HOME/network/admin LD_LIBRARY_PATH=$ORACLE_HOME/lib PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME /OPatch Join this group Popular White Paper On This Topic Beginner's Guide to ERP 14Replies Best Answer 0 Mark this reply sqlplus will find the .msb files and it will start running.

no errors - Are you starting the SQLPLUS session as the installing user? Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... 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. Join Now For immediate help use Live now!

share|improve this answer answered Aug 29 '14 at 12:56 HSeb72 111 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign Is this 11g which you are working on. 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 Once it is created it was running fine.

The average person thinks he's above average! You're now being signed in.