TNS Protocol 12560 Error?
Aug 7, 2013
I have toad on my machine and it connects to oracle fine using TNS but when I open sqlplus via start, i gives me a TNS Protocol error ORA-12560. Now, when I open up cmd and login like this: sqlplus user/pass@omp1, it logs in, why doesn't it login via the sqlplus program from start menu though?
Here is my tns file: JUNCORA= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=105.68.14.82) (PORT=1521) ) (CONNECT_DATA= (SID=orcl) ) ) OMP1= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=105.1.12.190) (PORT=1521) ) (CONNECT_DATA= (SID=OMP1) ) ) OMP2= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=105.1.12.193) (PORT=1521) ) (CONNECT_DATA= (SID=OMP2) ) ) here is the listener file: # listener.ora Network Configuration File: C:appRpatelproduct11.2.0client_1NETWORKADMINlistener.ora# Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Rpatel-PC)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = C:appRpatel
I tried to change to host to OMP1 but that did not work either
View 7 Replies
ADVERTISEMENT
Nov 15, 2010
I try to mount the database and login as an administrator to open SQLPLUS I get the following error:
C:\>sqlplus
SQL*PLUS release date.... Oracle. ALL rights reserved.
Enter username: system@oracle10 as sysdba
password:.....
ERROR:
ORA-12560: TNS: protocol adapter error
I did as some forums said: oracle_sid=oracle10 & looked in the listener that the SID is written.I made sure that the oracle.exe is running from services but still i continue to have this error.
View 1 Replies
View Related
Jan 3, 2013
While running oracle forms builder 10g,am facing error " ORA-12560: TNS:protocol adapter error ".
View 2 Replies
View Related
Apr 20, 2011
We installed Oracle 11g on solaris machine but some of the configuration failed.
When verified in tracelog we are finding below error message:
PRCT-1003 : Failed to run "getcrshome" on node "localnode"
at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:423)
at oracle.sysman.assistants.util.hasi.HAUtils.getCRSHome(HAUtils.java:546)
at oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:606)
at oracle.sysman.assistants.util.hasi.HAUtils.isHASConfigured(HAUtils.java:347)
at oracle.sysman.assistants.dbca.ui.DBCAWizard.<init>(DBCAWizard.java:452)
[code]....
We then tried to create instance but came up with below error:
ORA-12560: TNS Protocol Adapter Error..We have another database version 10.2.0.3 running on the same server and needs to be continued.
View 3 Replies
View Related
Feb 16, 2010
I am trying to connect via SQLPLUS to the standalone oracle database i have installed details as follows:
Host DT1089.myname.local
Database emrep.myname.local
Instance emrep
In EM database is up and running OK
Tnsnames is located at C:OracleHomesdb10gNETWORKADMIN
[code]...
I try to log on with command line
C:> sqlplus system/***** @ emrep
**** = password for user system
but get the following error:
ORA-12560 Protocol Adapter error
View 7 Replies
View Related
Aug 25, 2010
I'm using Oracle 11. I'm currently having some problem to start my Oracle database after database restore, hence unable to start my SAP application too.
> lsnrctl start
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 25-AUG-2010 23:49:20
Copyright © 1991, 2007, Oracle. All rights reserved.
Starting /oracle/PRD/102_64/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
HPUX Error: 29: Illegal seek
View 3 Replies
View Related
Nov 27, 2010
When connecting to Oracle Db as sysdba the following error message occurs.
-bash-3.00$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 27 00:34:55 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/sys as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
View 5 Replies
View Related
Jan 9, 2012
I installed local database on my laptop that pc is inside a domain when i remove the network cable and connect using the sid defined in the tnsnames sys/sys@ora10g as sysdba it gives me that errors
ORA-12560: TNS:protocol adapter error
to resolve this problem i should connect like that sys/sys as sysdba without the sid but i don't want to connect in this way because i have work must be done from home on that local database so i don't want to connect with network sys/sys@ora10g as sysdba and without network sys/sys as sysdba.
i want to be always connect sys/sys@ora10g as sysdba.
View 14 Replies
View Related
Oct 30, 2012
Getting error ORA-12560: TNS:protocol adapter error
My database is PACKS and user ID is PACKS .
Below tnsnames.ora
# tnsnames.ora Network Configuration File: C:DevSuiteHome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
STOREDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mst009.stc.corp)(PORT = 1521))
(CONNECT_DATA =
[code]...
View 9 Replies
View Related
Feb 7, 2013
In one machine I have windows xp with Oracle 11.2.0.2 database installed and I am able to connect to the database using both sql developer and sql plus.
In another machine I have windows 7. I installed Oracle client 11.2.0.1, then using Net configuration tool, I installed both listener.ora and tnsnames.ora files.
Now, I want to connect to the database which is installed on windows xp from windows 7 using the oracle client. When I tried to connect, I got the following error :
ERROR:ORA-12560: TNS:protocol adapter error
In order to rectify the above error, I was making sure that ORACLE_HOME AND ORACLE_SID were properly set in the regedit file (under HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE). The ORACLE_HOME was set properly. But I found ORACLE_SID missing. So I added ORACLE_SID environment variable in the registry and re-tried connecting to the database. But I am not able to connect. What else should I do in order to connect?
View 6 Replies
View Related
Nov 4, 2010
I installed Oracle 10g (10.1) in Windows Server 2003 and i am able to connect to oracle using using SQL net. But when I tried to connect this using SQL Net from Windows XP, I am getting ORA-12560: TNS:protocol adapter error. But when I tried to connect as SYSDBA user, I am able to login in SQL plus. But for a normal user, not able to log in.
View 1 Replies
View Related
Jan 19, 2011
I have one query on sql connection.
I have 3 database on windows server. I am using oracle 10g. I want to put the one of the DB in No archive mode, for that I have shutdown the database and then set the ORACLE_SID and try to connect through sqlplus sys/password as sysdba and run the db in mount mode and all the required stuff for put in no archive mode.
but when I set the ORACLE_SID and try to connect through sqlplus it gives me error of TNS protocol adapter error. I run this command through cmd prompt.
I resolved this error by change the directory on cmd prompt to $ORACLE_HOME/bin and then run sqlplus. it works for me but don't get the reason why its not working earlier.
View 1 Replies
View Related
Dec 20, 2011
i want to create new database in oracle 10g, i follow following steps.
C:ORACLE_SID=ALI
THEN create passwordfile
orapwd file=orapwdALI.ora password=ali entries=6
then create oracle instance
C:Oradim -new -sid ALI -STARTMODE AUTO
after that i use
SQLPLUS /NOLOG
THEN i write the command to connect to user ali but
CONNECT SYS/ali as sysdba
it display following message.
Error
ORA-1256: TNS: protocol adapter.
i also check the oracle services from "services.msc", where oracle instance is "start".
View 9 Replies
View Related
May 11, 2011
i m using Oracle 10g release 10.2 database and connecting Oracle Devsuite 10.2 but first time it gives the error of oraut.dll not found. Then this error resolved .
Now when i connecting Oracle devsuite 10.2 's sqlplus with Oracle database then it giving the error of
12560 TNS protocol Adapter error
While i have configured the listener.ora of Oracle 10g database and database is fucting well. but while connecting this to Oracle 10 Devsuite then it gives the error.
View 2 Replies
View Related
Jan 2, 2011
i have installed oracle 10g on linux system. and i am using xp as a client when i use this
cmd>conn scott/tiger@database at client side i receive ora-12560 error
while my database is up and listener and tnsping also working at server side.
View 3 Replies
View Related
Mar 14, 2012
I am installing oracle10 10.0.4 in windows server 2008 r2 sp1. while installing it is getting installed and when i start creating the database after accepting the default steps finally . while crating the error i get TNS:protocal adaptor error.
View 3 Replies
View Related
Jun 5, 2010
l oracle 9i database , and then i install oracle 10g forms, and now when i run my form through browser ,it gives me following error message ..
ORA-12560 :TNS: Protocol Adapter Error
View 1 Replies
View Related
Nov 27, 2001
I tried using the sqlldr locally to load data to the server. I received the error message.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [[0]]
ORA-12560: TNS:protocol adapter error
Is there any ora file that I should change or update to be able to use sqlldr from client to load data in the server.
View -1 Replies
View Related
Aug 14, 2010
i have win 2008 server and oracle 10g when im try to install oracle it terminate successfully but when insall domain controller in windows , oracle dont terminate the installation and break in creating data base (2%) and return the error message : ora-12560 tns adaptator protocol error
View 1 Replies
View Related
Nov 28, 2011
Since 13.00 hours, my clients can't connect to the database, and hence cannot access their application.
They get a ORA-12560 error. protocol adapter.
What I have discovered and done so far.
1. I can tnsping dbname -> OK.
2. I have rebooted both application server and databaseserver multiple times
3. I haven't touched tnsnames.ora, sqlnet.ora and listener.ora and they look to be in perfect mint condition.
4. I have full access to access the database instance via web.
5. I can connect to the database instance via sql
6. I have restarted the oracle-services: oracleDBConsoledbname, OracleOraDb20g_home1TNSListener and OracleServicedbname
7. I have rebooted the client computers, and the file server.
8. I don't see any errors in event logs, both on file server, client computer and database-server.
9. When I press down the link Listener, I get Metric Collection Error, which means I might not access it?
10. The only alert I find is that filesystem D: only has 15.62% available space.
They have been using the database for a very long time without any trouble, and suddenly boom.What do I do? How do I check things?
View 22 Replies
View Related
Apr 15, 2012
I want to install Oracle EE 11gR2 on my Windows 7 Professional 64-bit laptop. Installed memory is 8GB.I need to install 32-bit server since Oracle Warehouse Builder will not run on a 64-bit o/s. Further, I use Toad 9.7.2 which will only recognise client 32-bit.
I had a few failed attempts, especially when the database was being created with the ORA-12560: TNS:protocol adapter error,
So here's what I did:
Changed C:WindowsSystem32driversetchosts so that it contains two lines 127.0.0.1 localhost & ::1 localhost
Changed properties of setup.exe in the installation directory to be Windows XP SP2 compatible and run as administrator
Selected "install database software only" (so I could figure out at what step the installation fails)
Selected "single instance"
Selected "Enterprise Edition"
Selected oracle base "c:app" (instead of default location c:appd_seng)
Copy of files was completed successfully, log file was created in c:program files(x86)oracleinventorylogs & registry entries were added to "HKEY_LOCAL_MACHINESOFTWAREWow6432NodeORACLE" (with keys KEY_OraDb11g_home1, ODP.NET & OracleMTSRecoveryService), and the following services were created:
OracleMTSRecoveryService: Started/Automatic
OracleOraDb11g_home1ClrAgent: Not started/Manual
OracleRemExecService: Started/Disabled
There are no listener.ora & tnsnames.ora yet. Sqlnet.ora is created with the line SQLNET.AUTHENTICATION_SERVICES = (NTS)
Now I went to Start, All Programs, Oracle - OraDb11g_home1, Configuration and Migration Tools, right clicked on "Net Configuration Assistant" and changed the properties to be Windows XP SP2 compatible and run as administrator and ran it. I selected "Listener Configuration", added a listener called LISTENER, TCP protocol, port 1521 and finished. A service called "OracleOraDb11g_home1TNSListener" was created and started in automatic mode. The PATH was updated and listener.ora was created with the lines:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:appproduct11.2.0dbhome_1)
[code]...
Tnsnames.ora is also creaed with the contents:
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
At the command prompt, lsnrctl.status shows:
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2012 12:42
:19
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSG-HP6555b)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 15-APR-2012 12:37:54
[code]...
At the command prompt, lsnrctl.services shows: LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2012 12:43:15
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSG-HP6555b)(PORT=1521))
)
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully Now I went to start, all programs, Oracle - OraDb11g_home1, Configuration and Migration Tools, right clicked on "Database Configuration Assistant" and changed the properties to be Windows XP SP2 compatible and run as administrator and ran it.
I chose to create a databaseGeneral purpose Global database name ORCL SID ORCL Chose "Configure Enterprise Manager" & "Configure Database Control for local management" and disabled "Automatic maintenance tasks" Used the same password for all accounts
Selected storage type "File System" & "Use Database File Locations from Template" Unchecked Flash Recovery & Archiving Selected "Sample Schemas", "Typical" memory size (1228MB), "Use Automatic Memory Management" Left sizing/character sets/connection mode as default, and Selected "Generate Database Creation Scripts" in C:appadminORCLscripts (if I choose to Create Database, it fails with TNS Protocol Adapter Error).
I now open ORCL.bat in an editor, go to command prompt, create the directories as per the file, set ORACLE_SID=ORCL & path.
Running C:appproduct11.2.0dbhome_1inoradim.exe -new -sid ORCL -startmode manual -spfile gives a message "instance created" & services "OracleJobSchedulerORCL", "OracleVssWriterORCL" (started) & "OracleServiceORCL" (started) are created.
The next step C:appproduct11.2.0dbhome_1inoradim.exe -edit -sid ORCL -startmode auto -srvcstart system give an error "Unable to start service, OS Error 1056" (probably implies services already running), nothing is present in the windows alert logs about this. If I stop the service OracleVssWriterORCL, then this command completes, although no messages are returned.
The next step in the batch file starts sqplus /nolog and calls ORCL.sql.
ORCL.sql accepts passwords for sys, system, sysman & dbsnmp. It then executes host C:appproduct11.2.0dbhome_1inorapwd.exe file=C:appproduct11.2.0dbhome_1databasePWDORCL.ora force=y, which prompts me for the password for sys.
ORCL.sql then calls CloneRmanRestore.sql, which then tries to run connect "SYS"/"&&sysPassword" as SYSDBA
This is when I get the error ORA-12560: TNS:protocol adapter error, which has been haunting me for days.
My gut feel is that the database creation step at sqlplus is unable to recognise the listener...or probably it does not recognise the modified registry location (with Wow6432Node), the file oracle.key in C:appproduct11.2.0dbhome_1BIN shows the string SOFTWAREORACLEKEY_OraDb11g_home1.
I then changed oracle.key to point to SOFTWAREWow6432NodeORACLEKEY_OraDb11g_home1, restarted the listener and ORCL service, but connecting as sys returns the same error.
View 30 Replies
View Related
Sep 30, 2010
My server was down for Some days. Then we brought up the server and started all databases. When i tried to up my listeners i faced the following errors .
$ lsnrctl start CGSLDOC
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 30-SEP-2010 08:26:46
Copyright © 1991, 2007, Oracle. All rights reserved.
Starting /oracle/app/oracle/product/10.2.0/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
System parameter file is /oracle/app/oracle/product/10.2.0/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/10.2.0/network/log/cgsldoc.log
TNS-01151: Missing listener name, CGSLDOC, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
$ lsnrctl start CGSLMTX
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 30-SEP-2010 08:27:24
Copyright © 1991, 2007, Oracle. All rights reserved.
Starting /oracle/app/oracle/product/10.2.0/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
System parameter file is /oracle/app/oracle/product/10.2.0/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/10.2.0/network/log/cgslmtx.log
Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=inmaadlfaxdb03.eserve.tcseroot.net)(PO
RT=1528)))
TNS-12557: TNS:protocol adapter not loadable
TNS-12560: TNS:protocol adapter error
TNS-00527: Protocol Adapter not loadable
View 5 Replies
View Related
Jun 10, 2013
What protocol is used by RMAN to communicate with the server used for backing up/restoring data? Would it be possible to intercept and modify the calls made by RMAN?
Background: I am developing a proxy that backs up an oracle database to a different store
View 2 Replies
View Related
Feb 22, 2007
i installed oracle 9i release 2 on windows xp professional then i installed form 6i in different home.
i copied tnsnames.ora file from ORACLE_HOME etworkadmin to forms home NET80admin folder....
Once i installed both i can see in the PATH variable both homes then bin directory....
ORACLE_HOME/bin
FORMS_HOME/bin
in these two locations you can find sqlplus.exe file, when i try to login from the command prompt like below
sqlplus "/as sysdba"
it is not going, instead it is coming to command prompt... if i remove FORMS_HOME/bin from the PATH variable i can able to do that...just keep this problem aside.When i try to connect oracle from the forms it is giving error like "ORA-12222 TNS no such protocol adapter...."
View 24 Replies
View Related
Nov 23, 2012
Is there way implement Kerberos authentication protocol with PLSQL? I am consuming web service with utl_http, which implement only basic authentication and I was able to find implementation with PLSQL for NTLM. So I am wondering if there is a kerberos implementation.
View 0 Replies
View Related
Oct 14, 2013
I have oracle forms builder and reports builder 10g installed on my computer. And it is working fine and connected to database properly.
Now I need to work in reports 6i and I installed that without error. I replaced the TNSNames.ora(The same i used for reports 10g) file with my database connections. But When I connect to the database i got the following error.
REP-0501:Unable to connect to the specified database
ORA-12222: TNS : no such protocol adapter
I created a environment variable for TNS_ADMIN in the system variable section as C:Ora10gdsNETWORKADMIN.
But still i am getting the same error while connecting to the database.
Should I not install the 6i while there is reports 10g already exists in my machine?
View 1 Replies
View Related
Sep 4, 2013
While Running Forms 11g i get the following message in web browser,.how to deploy forms 11g in weblogic
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.4.5 404 Not Found
aLSO the error file is attached with this.
View 2 Replies
View Related
Nov 15, 2010
Oracle version - 10.1.0.4 OS - HP-UX
In my alert log I am getting the following error quite repeatedly; My application hangs, and have to restart the instance.
CODEORA-00604: error occurred at recursive SQL level 1
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 6
View 4 Replies
View Related
Aug 6, 2010
error while exporting a job
ORA-39171- job is experiencing a resumable wait
ORA-01652-UNABLE TO EXTEND TEMP SEGMENT BY 128 IN TABLESPACE TEMP.
View 2 Replies
View Related
Jul 23, 2010
im new to Database i have to count no of messages based on the minuties like 1-5, 6-15,16-30,>30 min how to write query
select count(*) from table1
where (
select
( (extract(day from column2)-extract(day from column1))*24*60 +
(extract(hour from column2)-extract(hour from column1))*60 +
extract(minute from column2)-extract(minute from column1)) as Processed_time from table1
) IN (1,5)
getting an error TOO MANY VALUES
View 2 Replies
View Related
