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
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 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.
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'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.
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 have a client program that needs to communicate with another server program. My client program is implemented in PL/SQL using utl_tcp running on Oracle 9 while the server program is a 3rd party software running on Windows server 2003.
Basically my client program needs to send a request to the server, waits for the response (wait for the incoming string which ended /w chr(3) ) and then acknowledge (sending chr(6) ).
My problem is that if I wait for the chr(3) and then acknowledge. My send routine (l_sent := utl_tcp.write_text (g_conn, p_content) will raise a Oracle generic network error. It seems like the connection is closed. I checked /w the vendor and they said it might be I am taking too long to response ( I question timeout is the problem). I have also attempted to change my read routine from read_line to read_raw but it only make things worst. I cannot even read the complete string. At least with read_line, I can read back the entire string.
My current work around is to send out the ack before I receive the chr(3) (which is not recommended by our vendor).
While after connecting to server via my userid( its an externally id) ,after setting ORACLE_HOME and SID, while entering sqlplus / command,its not connecting.Error am getting is:-
ERROR: ORA-01034: ORACLE not available ORA-27123: unable to attach to shared memory segment HP-UX Error: 22: Invalid argument
I have an application in VB6 that connects to an Oracle Database 10g with Oracle native ole db but win7 can not make the connection with a standard user, only makes the connection to a user with administrator permissions. The error that shows the application's rubbish eg @, H, etc.. only rare characters.
how can I connect via ftp to the xmldb-filesystem ?
I tried the instructions from this website [URL] ..... Now I can connect to the filesystem via "win7 shell ftp", but i cannot connect via "win7 explorer" using "ftp://host:port/foo/bar" or filezilla. Everytime i try i got an errormsg like:
filezilla: cannot read filesystem and win7 an error appears : detail: 200 Type set to A. 277 Entering Passive Mode.... see sreenshot -> [URL]
In the recent past we have been observing the DB connection from application to database using ODBC is taking long time. When I fire LSNRCTL SERVICE command, for our instance the ESTABLISHED = count is being shown a huge number like 45000 and even more some times.
When we restart the instance suing shutdown immediate or abort commands. The established connections count is becoming 0 and again getting increased slowly. Once the count is reduced the connections are getting established quickly without any issue.
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.
As per my understanding connections should start to fail from client side after addition of these parameter on server side sqlnet.ora (no changes to client side sqlnet.ora).I am still able to connect to this server without connections getting failed.
I already checked aso is installed on this database.Just to add it is a RAC database with 2 nodes.
I'm going to import a single database using FS to a RAC on ASM both are in same server running oracle 11.2.0.3. So I was wondering if can I use network link mode of impdp without setting up a listener using 10gb Ethernet interface ?
I don’t want to incur the overhead of the tcp network layer because both DB single and Rac are on the same server.
SQLLDR userid=userid/passwd@vpl01 control=OtherType.ctl log=OtherType.log bad=OtherType.bad SQL*Loader: Release 11.2.0.1.0 - Production on Sat Aug 25 13:32:42 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]
If I provide full connection string, it gives syntax error:
sqlldr userid/passwd@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orasrv)(PORT=1526))(CONNECT_DATA=(SID=vpl01))) control=OtherType.ctl log=OtherType.log bad=OtherType.bad LRM-00116: Message 116 not found; No message file for product=ORACORE, facility=LRM
[code]...
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
but it doesn't work if supplied following command:sqlplus userid/passwd@vpl01
SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 25 13:32:14 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
Even tnsping vpl01 gives error: TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 25-AUG-2012 09:14:40 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files:
How to determine number of connections establishing from application server to database server for a particular user and also query the user is running in database.
user -- application user created in database. same user exist in application.
I am trying to create a job that will execute a shell script on a remote server (Server B) when an existing job, on the local server (Server A), completes.
I have spent the last couple of days combing through Metalink, Oracle Documentation, AskTom, and Google. I know this is a relatively "new" feature/ability - released with 11.2 - but this particular error stack is no where to be found. I have attempted to be completely thorough with the information I provided, along with being diligent about masking important configuration information.
While the calling Job is starting the second job, the second job appears to timeout at 60 seconds and the job status is reported as failed with this error stack:
ORA-12537: TNS:connection closed ORA-06512: at "SYS.DBMS_ISCHED", line 4921 ORA-06512: at "SYS.DBMS_ISCHED", line 6853 ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-29261: bad argument ORA-06512: at "SYS.DBMS_SCHEDULER", line 3975 ORA-06512: at line 1
Configuration information:
Server A and Server B OS Version/Kernal Information: Oracle Linux Server release 5.8 x86_64 2.6.32-300.24.1.el5uek
Remote Scheduler Agent version, on both servers is: 11.2.0.3.1
Here is the listener status on Server B for db2:
serverb $$ lsnrctl status listdb2 LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 23-JUL-2013 11:39:27 Copyright (c) 1991, 2011, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=***))) STATUS of the LISTENER
[code]...
I have configured both servers with remote Scheduler agents and both databases have been configured and registered with the agents.
I have executed the shell script on Server B and it performs as expected.
I have the primary job calling the remote job, and that is performing as expected.
I have tested the connection from DB1 on Server A to DB2 on Server B with this
SQL> set serveroutput on SQL> DECLARE 2 versionnum VARCHAR2(30); 3 BEGIN 4 versionnum := DBMS_SCHEDULER.GET_AGENT_VERSION('ServerB.someplace.net');
[code]...
and I have tested the connection from DB2 on Server B to DB1 on Server A with this
SQL> set serveroutput on SQL> DECLARE 2 versionnum VARCHAR2(30); 3 BEGIN 4 versionnum := DBMS_SCHEDULER.GET_AGENT_VERSION('ServerA.someplace.net');
Database Connection failure. Reason: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory
I'm not an Oracle expert, but I have research a little and seems that the SID could be wrong or that the DB is down, in fact I have already checked trhe server but everything seems normal to me.
how many maximum connection, a particular user can have in oracle. and how many maximum connection if user has 'resource profile' as default.and i am using oracle 11.2.0.1.0
My application is using "Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production" and Oracle 11g client v11.1.0.6.0.My application server runs continuously and checks for new requests. But problem occurs when I do not send any request to my server for 40-45 minutes i.e. server is idle or doing nothing except checking new incoming requests for those 40-45 minutes. After that if I try to connect my server by sending some request, it shows following error message and my server crashes:
Message String: ORA-03135: connection lost contact Process ID: 7586034 Session ID: 61
[URL]... says that session memory is maintained in the PGA (unlike shared server) and then gives a calculation for memory usage that I don't understand: it suggests that instead of there being one PGA per session, there is one PGA per pooled server plus a small allocation of 35k per session, but this is not what I see.
It's easy to demonstrate. As sys, exec dbms_connection_pool.start_pool and then launch any number of session with sqlplus scott/tiger@127.0.0.1:1521/orcl:POOLED and you'll see a process called Lnnn launched for each session:
[code]...
There is a mention of a process called the connection broker, but I can't see this in v$process.There is more detail in the OCI developers guide [URL]... which goes beyond my knowledge of application development.
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.
