regards Amir Anja says: December 1, 2010 at 8:23 pm Dear MVE, very helpful post. If you have any comments or questions, please feel free to submit a message using the form below. But like others I get the 12154 error even though everythign is correct, including TNS_ADMIN and TSNAMES.ora (latter copied from co-worker with working client). Udit says: October 8, 2009 at 11:08 am Hi Vitaliy Mogilevskiy, I am really grateful to this post….. Check This Out
Thank you. which is working pretty well, and I'm also looking at Quest's Toad For Oracle. Please help Regards, Sreekar. It was really helpful. Homepage
What you want to centralize is your RMAN scripts and RMAN backup-set destination -- not the actual RMAN utility. The registry will now be displayed 4. In particular, unless you have been advised to do so, do not manually alter the Oracle home settings. I can get the tnsnames from the server and configure it, but cant install sqlplus!!
Perhaps someone else feels able to assist. Best regards, Vera Darrell says: January 12, 2011 at 6:20 pm Thanks! You can then change your password using the following command alter user system identified by my_new_password; PS: In 11g passwords are case sensitive by default. Sp2-0667 Windows Which version of Oracle 10g client should I install (32 bit client or 64 bit client) on this 64 bit OS?
Click Open - the registry will be restored 7. Error 6 Initializing Sql * Plus Message File Sp1 Lang Msb Not Found Toufik HAMDANI says: December 23, 2011 at 5:49 am Hello, really nice post. You can incorporate dbstart/dbshut into a script which you'll place into /etc/init.d/ (RedHat/OEL Linux). http://www.orafaq.com/forum/t/189652/ 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
If not, I do hope to install Linux. Error 6 Initializing Sql*plus Unix Good judgement comes from experience. following is my tnsnames.oraTOTEMPROD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ttf19.cern.ch)(PORT = 1521)) [code]... For 10g and above look into flashback features.
Regards Syed Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... http://oracledba.bigresource.com/Error-6-initializing-SQLPlus--C9Zpw0Iy1.html Here’s the copy of the writeup I did to install the latest 11g Oracle instantclient basic and instantclient sqlplus on win32: Download Software Go to Instant Client Downloads for Microsoft Windows Sqlplus Error 6 Initializing Sql Plus can you please suggest me on this..and is dis info enough for you to come to an understanding about my issue?? Error 6 Initializing Sqlplus Sp2-0667 Sp2-0750 Dumas Philippe says: September 13, 2011 at 5:10 am Hi, Thanks a lot for your post.
MVE says: October 7, 2009 at 9:27 pm @Nicolas I am glad it helped you out. his comment is here I need to start my Database ASAP! Clear and gets the job done. MVE says: October 8, 2009 at 6:51 pm Udit, in simple terms, the purpose of Oracle Client is to connect you to the Oracle database using SQL*Net. Error 6 Initializing Sql*plus Linux
jrajasekhar_mca replied Apr 23, 2012 Hi Sundar, This could be problem with .msb files misisng at ORACLE_HOME path. Nancy Yuan says: October 17, 2009 at 12:54 pm Vitaliy, I installed 11gR1 Oracle Server software on my Vista. If so, correct the typo and try again? –Boneist Feb 12 '15 at 16:45 @Boneist I installed oracle 11g I didn't understand what typo ?? –cycilia Feb 12 '15 this contact form I can Start the Listerner and this is what i get After i start it.
Type --------------------------- ----- ------------------- DUMMY VARCHAR2(1) SQL> Thank you very much again for helping me the issue. Sp2 0667 Sp2 0750 Windows And i want to configure pl sql to use tnsnames.ora. where should i obtain a username and password from, and why is it giving a no listener error?
All Rights Reserved.Enter user-name: / as sysdbaSYS on test>oradebug helpSYS on test>oradebug setmypidStatement processed.SYS on test>oradebug hanganalyze 12[code]...Now I have got struck how to analyze above results. And now you use SMS-speak at me. I still can't login to sqlplus as SYSTEM directly but I followed your advise login ‘sqlplus /nolog' and then ‘connect / as sysdba' at the sql prompt. Message File Sp1 Lang .msb Not Found but still am facing with error "ORA-12154: TNS:could not resolve the connect identifier specified".
All rights reserved. BTW I wonder how can some1 publish installation like this, without some serious help within installation files. Home | Invite Peers | More Oracle Groups Your account is ready. navigate here And also worked for my TNS connection using Navicat for Oracle.
MVE says: January 9, 2010 at 1:53 pm Toad is great and if the company you work for pays for it -- it's even better! In particular, unless you have been advised to do so, do not manually alter the Oracle home settings. Here's a simpler TNS alias that you can use (example): MY_ALIAS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dbnode.mydomain.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = SERVICENAME.mydomain.com) Did bigamous marriages need to be annulled?
All rights reserved. Umair Mustafa replied Jun 25, 2011 Sorry dear for late reply and thank to both of you Paul and Michael, now I'll will apply the same procedure as you have said Thanks, Simon MVE says: January 11, 2010 at 12:04 pm @Simon - 11g's EXP tool is not designed to export data from older versions of oracle -- it's whole purpose in I have cygwin on my computer, here is the log I entered from my xterm prompt: [email protected] /cygdrive/c/Users/Nancy/Documents/Downloads $ ls instant*.zip instantclient-basic-win-x86-64-126.96.36.199.0.zip instantclient-sqlplus-win-x86-64-188.8.131.52.0.zip [email protected] /cygdrive/c/instantclient/instantclient_11_1 $ ls BASIC_README mfc71.dll ojdbc5.jar orasql11.dll
From your PC, click Start | Run 2. I will re-do installation with Oracle Server software. Thanks Nancy Yuan MVE says: October 12, 2009 at 3:56 pm you are missing "connect / as sysdba" Nancy Yuan says: October 12, 2009 at 4:46 pm SQL> connect / as Want to get my biggest thanx.
MVE says: June 21, 2011 at 1:22 pm @Monjur Yours is a typical setup -- Database Nodes are often protected by a Firewall and sometimes are on a different subnet from The problem that I am having is that apparently port 1521 is always closed from the outside. And there is lots of information out. Gazmend says: September 4, 2012 at 11:34 am Worked like a charm.Cheers m8 arjuna says: September 14, 2012 at 1:07 am Very very useful,thank you very much.Cheers… yuga says: November 11,
Open a CMD window (Start->Run...; enter CMD) and type: echo %ORACLE_HOME% If (as I suspect) it merely returns %ORACLE_HOME%, you need to set the environment variable to the top-level directory where Thanks, MVE says: November 17, 2009 at 10:15 pm Simon, There are two scripts provided by Oracle called dbstart/dbshut. Total System Global Area 841162752 bytes Fixed Size 1339768 bytes Variable Size 566234760 bytes Database Buffers 268435456 bytes Redo Buffers 5152768 bytes Database mounted. It is too much trouble to debug my system setup.
To check whether your oracle_home is set, type path in your command prompt. All in all, not very professional.