Thank you in advance Top Best Answer 1 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... When I try sqlplus [email protected]:1530/orcl I get the error: ORA-12154: TNS:could not resolve the connect identifier specified When I set ORACLE_HOME to /cygdrive/c/oracle/product/10.2.0/client_1, I get a different error: Error 6 initializing If TNS_ADMIN is not set, OCI will examine an operating system dependent set of directories to find tnsnames.ora. Now pull up command prompt: sqlplus
Which is actually all the instructions tell you to do. Not the answer you're looking for? I did a find and modified the setup.py file so it has elif sys.platform == "cygwin": includeDirs = ["/usr/include", "rdbms/demo", "rdbms/public", \ "network/public", "oci/include", "/lib", "/usr/lib", \ "/lib/gcc/i686-pc-cygwin/3.4.4", share|improve this answer answered Nov 18 '08 at 18:42 MCS 6,352174871 add a comment| up vote 0 down vote The way it worked for me was to remove /cygdrive/d or /cygdrive/c
Physically locating the server In Skyrim, is it possible to upgrade a weapon/armor twice? I'm still working on this problem, so if anyone has information please email me directly. asked 7 years ago viewed 10487 times active 3 months ago Visit Chat Related 0Cannot Connect with TOAD but Can with Other Tools/Apps0Oracle sql*plus and form build5How to install SQLPLUS (Oracle 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
I found the above suggestion on an oracle website. I tried to un-install and re-install gcc using the Cygwin setup program, and noticed that cc1.exe was definitely being installed. I don't see any problem in this either. Sp2-0750 Oracle_home In Windows I checked the env variables before running sqlplus using the echo command.
Join them; it only takes a minute: Sign up connecting to remote oracle via cygwin sqlplus up vote 0 down vote favorite I'm trying to use cygwin sqlplus to connect to Does the string "...CATCAT..." appear in the DNA of Felis catus? 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 https://community.oracle.com/thread/853565 Browse other questions tagged oracle sqlplus or ask your own question.
I have installed Oracle Enterprise Linux 5.2 on a VM, and installed Oracle 11g. Sp2-0667 Sp2-0750 Windows Senior MemberAccount Moderator Quote:You may need to set ORACLE_HOME to your Oracle software directory Did you do that? yes - Did you check group membership of the installing user? Maybe try other languages / character sets.
Also he don't want install a client (neither instance client nor any other one). http://www.orafaq.com/forum/t/154516/ Re: SQLPLUS Error 6 Initializing SQL*PLUS 842417 Mar 2, 2011 1:43 PM (in response to 681712) Hi friends, But in which file we need to set ORACLE_HOME variable. Error 6 Initializing Sqlplus Windows 7 Nate Himmons replied Jul 15, 2014 Did you change installing user for the client software? Sp2-0667: Message File Sp1
Does this operation exist? his comment is here Please check the values of your localization settings, especially - NLS_LANG --> _.AL32UTF8 but check with your DBA - NLS_TZ or NLS_TIMEZONE (can't remember which one is right) Also, check that rjngh2005 replied Jul 15, 2014 chmod 755 $ORACLE_HOME/sqlplus/mesg chmod 644 $ORACLE_HOME/sqlplus/mesg/* Did you try the above? share|improve this answer answered Dec 15 '14 at 13:52 Pascal 211 add a comment| up vote 1 down vote And sometimes following Oracle documentation solves quite some hassle. Sp2-0667 Windows
If you want to login to the 11g database (from command prompt): set PATH=
Senior Member From Oracle FAQ Quote:Sometimes when SQL*Plus is run, you see the error: Message file sp1
You can leave a response, or trackback from your own site. 4 Responses to "SQL*Plusが起動できない" Added by Rhett Henly on 7月 19th, 2010 at 13:15:07 This text is helpfull for me
Just installed Oracle 11G R2 client under a user account. Thanks, Luan. share|improve this answer edited Mar 18 '15 at 14:01 AdrieanKhisbe 1,96641735 answered Mar 18 '15 at 13:07 Sina 1 add a comment| up vote 0 down vote Combining the details from Sp2-1503: Unable To Initialize Oracle Call Interface Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM
Is the sum of two white noise processes also a white noise? Remember you need to close the command prompt and open a new one to have it read the change you just made. 4. If indicated air speed does not change can the amount of lift change? navigate here Install Grid Infrastructure for standalone server + Database and Create database by...
For example on Linux to set NLS_LANG: setenv NLS_LANG JAPANESE_JAPAN.JA16EUC share|improve this answer answered Dec 15 '14 at 14:20 Pascal 211 Why do you think that the OP wants My test script (see below) reported a runtime error when calling connect: Unable to acquire Oracle environment handle ORACLE_HOME is defined and points to the correct place. mth3672 replied Jul 10, 2014 Was the db you are trying to log into created under the new home or the old? Proof of infinitely many prime numbers Why aren't Muggles extinct?
Oracle Client Trials 10.2 Companies Oracle Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow Toolbox.com Toolbox for IT on Twitter Toolbox.com It quits with the following error: Error 6 initializing SQL*Plus SP2-0667: Message file sp1
I installed oracle as a user named oracle, so I tried putting the variable in /home/oracle/.bash_profile . Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...