Please can you tell me where am i going wrong. Again, thanks! And i want to configure pl sql to use tnsnames.ora. I would like to be able to centrally do all my EXP from one server. Check This Out
This should take care of your schema based recoveries 100%. Craig says: February 10, 2010 at 7:47 am Easy to understand -as an Oracle newbie it was very usefull.Thx I followed your tutorial and I'm connected..the Q&A from users also insightful. ORACLE_HOME -- should point to RDBMS 4. 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
One is Class B type and other is Class C network. PATH -- should include RDBMS ORACLE_HOME before instant client 2. i'm sure I,m missing something obviously stupid!!!
The content of tnsnames.ora is as shown: MYDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = poulpi6srv)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = POULPI6) ) ) 6. It is too much trouble to debug my system setup. SaludosValora esta respuesta0Comentar Duda incluir subconsulta en set y whereJdbc oracle12c Enviar a un amigoOtras secciones relacionadas con OracleCursosBiblioteca de TemasCódigo FuenteChatGeneral RSS del foroExpertosTus mensajesRecomendar Seguir a @lwp_ Información y Error 6 Initializing Sql*plus Message File Sp1
Much appreciated! Error 6 Initializing Sqlplus Sp2-0667 Sp2-0750 Most errors on your machine are caused by uninstalling programs, installing new ones and accidentally deleting important files. your post is excelent. see here In 10g and up it's best to use expdp / impdb as it's run by the server process instead of client.
My database am trying connect remotely is 184.108.40.206 and my client is 220.127.116.11.Will that be an issue? Sp2-0750: You May Need To Set Oracle_home To Your Oracle Software Directory Thanks again. 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) SID_LIST_REMOTE_LISTENER2 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /home/Roman/app/Roman/product/11.2.0/dbhome_2) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = /home/Roman/app/Roman/product/11.2.0/dbhome_2) (SID_NAME = ORCL) ) ) REMOTE_LISTENER2 =
Use the up/down arrow to move the 10gr2 home to the top, putting the 11gr2 database on the bottom. Anu says: October 19, 2010 at 6:41 am Hi Vitaliy, I have oracle client 18.104.22.168 installed in my local pc.when i try to connect to remote server, sometimes connection fails with Error 6 Initializing Sql*plus Linux From the Vm,Every thing seems to be fine. Error 6 Initializing Sql*plus Unix All rights reserved.
finally a solution. his comment is here Error 6 Initializing Sqlplus Aix is usually caused by a corrupted registry entry. Chris jaywink says: January 21, 2010 at 11:12 am Thank you, this helped a lot, I was stuck on the NLS error Of course Oracle's own pages offered no help… 😛 Typically you'll call it /etc/init.d/dbora … This script should be able to process stop|start|restart parameters. Sqlplus Error 6
I tried that one alot of time. It was really helpful. Thank you very much to explain the tnsnames.ora file clearly…….. this contact form Any chance you can help me with this?
yuga says: November 11, 2012 at 1:56 am mine is windows7 64 bit huakun says: January 17, 2013 at 12:29 am thanks,非常感谢 Mack says: January 21, 2013 at 5:48 am Years How To Set Oracle_home DBA/admin stuff is very different (scripting etc..). Thanks for the info.” Your Name Your Email Comment Sqlplus Error 6 Initializing Sql Plus Windows There are millions of things that sqlplus error 6 initializing sql plus windows your
Background first. Also I added variables for "ORA_HOME" and "ORACLE_HOME" pointing to the same folder as the TNS_ADMIN variable. I just randomly chose 11R1. How To Set Oracle_home In Linux Then I unzip them to c:\instantclient and run sqlplus, then tried to login sqlplus but failed for ORA-12560: TNS:protocol adapter error.
On a side note, I am able to connect to the database using the SQL Developer tool on the same machine. Database and listener are started on the server side. Simon Filiatrault says: November 6, 2009 at 2:39 pm My thoughts also… Thanks, Bikash says: November 17, 2009 at 1:40 am Hi Vitaliy Mogilevskiy, i am new in oracle i try navigate here Sreekar says: July 29, 2011 at 4:51 am Hello Vitaly, Im working as an IT Professional in an org.
On Linux these scripts read /etc/oratab file where you specify which SID:ORACLE_HOME should be automatically started or shutdown. If there is a value for ORACLE_HOME, then: setx ORACLE_HOME "" That will set ORACLE_HOME to nothing. MVE says: January 7, 2010 at 7:54 pm @Rob No problem -- I am glad you sorted it out! Some errors to put thing printernational COMBOFIX Skip to complete and lockups kick "OK". 2.
Rob says: January 7, 2010 at 3:12 pm Sorry, my TNS_ADMIN had a space in front of the "C:\…". Thanks again. This does not work if you say have a web site running on the NETWORK SERVICE account, because you cannot log on to the account and add user variables. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters.
Visitor Comments 8 Comments for "Want to Fix Error 6 Initializing Sqlplus Aix?" Kelvin - Today “This fixed the Error 6 Initializing Sqlplus Aix message. Start a new thread here 2567673 Related Discussions Expdp Utility From Command Line Internet Explorer Error windows7 and vista crash oracle installation Error JREW.EXE stopped working while installing oracle 9i on The employee has admin access to the system and we have made everything fine but the prob stil exists. In order to have this work, SQLNET.AUTHENTICATION_SERVICE = (NTS) needs to be in the sqlnet.ora file.
Now question is, is it feasible to deploy this kind of architecture? ERROR: ORA-01031: insufficient privileges Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus What you want to centralize is your RMAN scripts and RMAN backup-set destination -- not the actual RMAN utility.