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.
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.
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.
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
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.
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
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.
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 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.
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
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
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?
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
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
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.
On my PC I have installed Oracle 10g & Oracle Forms & Reports 6i .My PC is on LAN ,to avoid problem of dynamic ip address & tns 12514 as PC get connected & disconnected from LAN regularly I have just installed Loopback Adapter.As my PC on LAN so it have old NETWORK CONNECTION which have specific ip address,subnet mask, default gateway,preferred DNS server , alternate DNS server.
How loopback adapter going to work & what I have to do after installing LOOPBACK ADAPTER? Can I give the same ip address,subnet mask, default gateway,preferred DNS server , alternate DNS server on my new network connection (generated after installing Loopback Adapter) as it is on my old network connection & delete or disable old Network Connection. And come in my original LAN with same settings on new Loopback Adapters newtwork connection. Or I have to keep both network connection .
I have installed oracle 11g in my personal laptop, when i open the sql developer and try creating the new connection. am getting "The network adapter could not establish the connection".
I am trying to create a secure connection and getting the following error. I have tested the password via sqlplus and it works just fine.
oracle[/u01/app/oracle] emctl config emkey -repos -sysman_pwd TZ set to US/Eastern Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
enter repository password..Invalid Password caught Exception java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
I have just installed Virtual Box 4.2.16 for Windows hosts to my Windows 7 laptop. I created virtual machine and installed Oracle Linux 6.4. Now I want to have this virtual Linux OS on the existing network. My Windows 7 is part of this network.
Let's say, my Windows 7 machine's IP address is 10.11.5.46. I want to set 10.11.5.201 to this virtual Linux OS and make it ping able from both way (host - guest). To do this, I used Bridged Adapter. I selected Intel(R) 82567LM Gigabit Network Connection. I believe this is LAN adapter of my actual host machine. Then also I setup network to the virtual Linux OS, such as static IP address, subnet mask, and default gateway. Then I rebooted the virtual machine.
Now, any machines on the network, including my Windows 7 host machine, can ping to my virtual Linux OS (10.11.5.201), but from virtual Linux OS can't ping to any machine on the network, except for default gateway. Also from virtual Linux I can't get to the Internet via Fire Fox browser.
In 4.2 early adapter 2 there is a packaged application called Incident Tracking. In this application page number 50 is having a region called Tickets. It has a template which is numeric.
I could not find the template under the application theme. Even if I try to create a page with the same page template but when I try to create a region in the region template LOV the numeric template is not displayed.
