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 RepliesWe 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.
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
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?
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.
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 RelatedI 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.
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.
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.
While running oracle forms builder 10g,am facing error " ORA-12560: TNS:protocol adapter error ".
View 2 Replies View Relatedl 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
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
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
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.
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]...
I have installed oracle 10g XE on my machine. And my machine's ip address is 10.10.50.50.
username:system
password:xxx
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.50.50)(PORT =1521))
[code]....
I was able to connect to the above server from my machine.But when i was trying to connect the above server from my neighbours system i am getting an error Network adapter could not establish the connection.
Note:when i ping the ip address 10.10.50.50 from my negihbours system in the command prompt
Reply from 10.10.50.50:bytes=32
Reply from 10.10.50.50:bytes=32
Reply from 10.10.50.50:bytes=32
Reply from 10.10.50.50:bytes=32
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
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...."
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?
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
I am getting the following error when trying to connect from sql developer, I can connect through command prompt and sqlplus to scott schema.
Error :
-------
An error was encountered performing the requested operation.
IO Error : The Network Adapter could not establish the connection
Vendor code 17002
Login details used in sqldeveloper
----------------------------------
Host name : 192.168.2.2
Port : 1521
service name : orcl
While creating the index we are getting the error "ORA-00603: ORACLE server session terminated by fatal error".
We have the space in tablespaces and also in the file systesm.
It's been 2 days from now that I'm bugging with this kind of error in my manual dB creation. I used DBCA first but we had a default directory settings, that's why I resorted to create the db manually. The dB was already created and currently has a status of STARTED.. I cannot mount it due to this error:
SQL> startup nomount
ORACLE instance started.
Total System Global Area 247463936 bytes
Fixed Size 2235856 bytes
Variable Size 177840688 bytes
[code]....
Got following error while droping user
DB:9.2.0.8.0 OS:Windows 2003
SQL> drop user custom cascade;
drop user custom cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-21700: object does not exist or is marked for delete
I try to alter the SGA it give me error The Steps which I do show sga
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
[code]...
While connecting to one of the dev database I am getting following error:-
ORA-00257: archiver error. Connect internal only, until freed.
But when i am checking as sys user there is no archive desination defined in the db.I mean log_archive_dest locations have not been given any value.Where can I check Archive destination in this scenario.Is there any default place where oracle stores archive logs incase log_archive_dest is not given any value.
I have created a database in Oracle10g which is working fine. Now when I try to create another the system gives the following error.
ORA-12560: TNS protocol adapter error.
I am trying to install oracle 11g on windows 2003 ent with sp2 , where I am getting an error, The java runtime environment was not found at bin/javaw.exe. hence the oracle universal installer cannot be run.
View 4 Replies View RelatedI have upgraded my database from 10.2.0.4 to 10.2.0.5. however while upgrading database using DBUA I am getting this error.table or view does not exist ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1579 ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1596 ORA-06512: at line 1The WMSYS.OWM_MIG_PKG is warped package and I can't understand what it means. How can I understand what view or table is absent in my database?
View 6 Replies View RelatedI start my database and suddenly got this error:
ORA-00371: not enough shared pool memory, at least 72102521958 bytes
How to fix? I use startup command only and shutdown when shutdown the database.