Error validating database 121 sql error opening connection
Hello Tom, I have installed oracle 11g R2 client on windows server 2008, i have added tns entry for BAST database in file.added entry in file as tnsnames.file entry: BAST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 18.104.22.168)(PORT = 1522) ) ) (CONNECT_DATA = (ORACLE_SID = BAST) ) ) file entry: SQLNET. DIRECTORY_PATH= (TNSNAMES) But when doing tnsping BAST i received below error: C:\Users\sa_oracletnsping BAST TNS Ping Utility for 64-bit Windows: Version 22.214.171.124.0 - Production on 13-FEB-2 012 Copyright (c) 1997, 2010, Oracle. Used parameter files: G:\oracle\tns_admin\TNS-03505: Failed to resolve name C:\Users\sa_oracletnsping "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 126.96.36.199)(PORT = 1522)))(CONNECT_DATA =(ORACLE_SID = BAST)))" TNS Ping Utility for 64-bit Windows: Version 188.8.131.52.0 - Production on 13-FEB-2 012 Copyright (c) 1997, 2010, Oracle. Attempting to contact (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(H OST = 184.108.40.206)(PORT = 1522)))(CONNECT_DATA =(ORACLE_SID = BAST))) OK (0 msec) C:\Users\sa_oracle February 13, 2012 - am UTC is your in c:\oracle\tns_admin SQLNET.Thanks, Arvind DEAR tom while starting up database, i am grtting following error ERROR: Error while trying to retrieve text for error ORA-12560 version : 9i OS : Linux i verified home , path variables .. // *Action: Add files to the tablespace using ADD TEMPFILE command. If the installer actually succeeds then there are these issues with setup, the bottom of the protocol stack and a host of others. install on windows server with firewall disabled *don't allow other services on the machine to share port with it. On 11g, run the installer first without creating a starter database, run NETCA and finally DBCA. also, always start listener immediately after setting SID before other things. sqlplus scott/tiger i got following errors errors: The procedure entry point longjmp couldnot be located in the dynamic link library ORA-12560: TNS:protocol adapter error even after restarting pc, stoping and restarting Oracle Service ORCL even every service which start with Oracle plz help me in this regard Your service name (oracle) is not started properly. Start oracle Service DBTEST my service name is dbtest.they have been set properly and listenr is up could you please help me to resolve the issue Thanks Alihey Tom, when i get enter user name scott and pass tiger to Oracle 9i i get the ORA - 12560 TNS protocol error. March 22, 2010 - am UTC hopefully you installed it on an operating system at least as old. that is a very generic error meaning 'you didn't set it up'. I am an architect and have spent hours completely wasted on this ridiculous product. ERROR: ORA-12541: TNS:no listener I understand what you guys are passing through as regard TNS error. 4 if you are using client OS like XP/VISTA/WIN7,follow case 3 and immediately go to services before you turn off your computer after installation and change all oracle services to start manually. If you properly restart your service, then problem will be solved. Thanks check if db listener is running; seems like database is up but listener is not.// *Action: Verify that you entered the service name correctly.
ORA, // an Oracle Names server, or a native naming service.
I am getting error ora-12560 when configuration assistant part of installation starting.
I have installed loopback adapter and tested it by ping command. Thanks, Arvind Hello Tom, When we install Oracle on windows it automatically start the windows services.
It is dropping vowels left and right - you should get that fixed because otherwise it makes you look like a 12 year old kid trying to be cool on the internet. Errors are as follows: Problem 1: has encountered a problem and nees to close Problem 2: The Oracle Hi, I installed Oracle 10g Database on My laptop. S is Windows XP SP2 and I downloaded Oracle software from OTN. The type of error is "ORA-12560: TNS:protocol adapter error". The instance of oracle was running well, but I have to change the archive's directory, affter that, my oracle starts to show this "Ora-12560. I have no problem in connecting my database using "@" string in the server itself.
But whenever I am trying to connect the Linux database server from any Windows client I am getting this error "ORA-12560 TNS:protocol adapter error" (my Linux server and database is up and running fine). # Network Configuration File: C:\oracle\product.2.0\client_1\network\admin\# Generated by Oracle configuration tools. DIRECTORY_PATH= (TNSNAMES) But still I am getting the TNS protocol adapter error. Hi Tom, Yes I can ping the server IP from the windows client command prompt successfully but couldn't able to tnsping it as the commands end with the error TNS-12560: TNS:protocol adapter error. June 22, 2011 - pm UTC I would think that either a) the configuration is not what you think it is (there is a TNS_ADMIN environment variable set or something that is pointing to a different location or the files you are looking at are not in the right location) b) the software installation is incorrect on the client.