Server Administration :: Error / Network Adapter Could Not Establish The Connection

Jan 27, 2010

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

View 10 Replies


ADVERTISEMENT

Client Tools :: IO Error - The Network Adapter Could Not Establish The Connection

Oct 1, 2012

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

View 1 Replies View Related

Network Adapter Could Not Establish The Connection In SQL Developer

Aug 25, 2010

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".

View 2 Replies View Related

Enterprise Manager :: Network Adapter Could Not Establish Connection

Feb 25, 2011

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

View 2 Replies View Related

Networking And Gateways :: Network Adapter Couldn't Establish Connection

Oct 7, 2011

im failing to connect im this error- status:failure-lo exception:The network adapter could not establish the connection.

View 8 Replies View Related

Server Administration :: TNS Protocol Adapter Error

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

Server Administration :: ORA-12560 - TNS Protocol Adapter Error

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

Server Administration :: ORA-12560 / TNS / Protocol Adapter Error

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

TNS-12560 Protocol Adapter Error / Connection Closed

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

Server Administration :: Unable To Connect To Database / ORA-12560 / TNS / Protocol Adapter Error

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

Utl-tcp Connection - Oracle Generic Network Error?

Aug 26, 2010

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).

View 5 Replies View Related

Server Administration :: Oracle Database Connection Error

Mar 5, 2013

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

Attaching output session.

View 16 Replies View Related

OLE DB :: Establish Connection To Oracle With Application In Win 7?

Jan 11, 2013

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.

View 7 Replies View Related

Cannot Establish Ftp Connection To Xmldb-filesystem?

Aug 29, 2012

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]

View 2 Replies View Related

Login To Database - Connection Establish Quickly When Count Reduced

Aug 27, 2012

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.

View 9 Replies View Related

Server Utilities :: SQL*Loader-704 - Protocol Adapter Error

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

Networking And Gateways :: ORA-12560 - TNS - Protocol Adapter Error In Windows Server 2003

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

Server Administration :: Set-up Network Encryption

Sep 9, 2010

I am trying to set-up network encryption.I have added following parameters to my server side sqlnet.ora file:

SQLNET.ENCRYPTION_SERVER = REQUIRED
SQLNET.ENCRYPTION_CLIENT = REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER =RC4_256
SQLNET.ENCRYPTION_TYPES_CLIENT =RC4_256
SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED
SQLNET.CRYPTO_CHECKSUM_CLIENT = REQUIRED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (MD5)
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (MD5)

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.

View 4 Replies View Related

Server Utilities :: Exclude View In IMPDP Using Network Link Giving Error

Jan 14, 2011

I am using below command to import a schema using network link. Command is :

impdp system directory = IMP_DIR schemas = XYZ network_link = PQR remap_schema = XYZ:XYZ exclude=view: "= 'XYZ.VW_ACCEPTDETAILS'"

This command is giving below error

LRM-00116: syntax error at 'view:' following '='

When I have tried Like in place of '=' sign i.e. EXCLUDE = VIEW:"LIKE '%VW_ACCEPTDETAILS%'" , it gives me below error:

UDI-00014: invalid value for parameter, 'exclude'

View 4 Replies View Related

Export/Import/SQL Loader :: Impdp Network Mode Can Use Bequeath Connection?

Feb 12, 2013

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.

View 4 Replies View Related

Server Utilities :: SQLLDR Connection Error?

Aug 25, 2012

The SQLLDR fails with connection error:

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:

[code]...

View 4 Replies View Related

Enterprise Manager :: Error / Server Connection Failed

Sep 14, 2013

I have configured OEM and is up and running but, I am getting below error message when open the OEM URL.

Error Message:

Secure Connection Failed / an error occurred during a connection to rhel6:1158.

The page you are trying to view can not be shown because the authenticity of the received data could not be verified.

View 2 Replies View Related

Server Administration :: Number Of Connection For A User

Aug 27, 2013

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.

View 15 Replies View Related

Server Administration :: ORA-12537 / TNS / Connection Closed

Jul 23, 2013

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

Database Version, on all databases, is:

Oracle Database 11g Enterprise Edition
11.2.0.3.0 - 64bit

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');

[code]...

View 12 Replies View Related

Server Administration :: Database Connection Failure - Oracle Not Available

May 28, 2010

I'm getting the error messaage:

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.

View 3 Replies View Related

Server Administration :: Maximum Number Of Connection Of Particular User?

May 2, 2012

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

View 1 Replies View Related

Server Administration :: ORA-03135 - Connection Lost Contact

Oct 11, 2010

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

View 9 Replies View Related

Server Administration :: Database Resident Connection Pooling?

Jan 3, 2011

[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.

View 3 Replies View Related

Tns Protocol Adapter Error

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

ORA-28547 / Connection To Server Failed - Probable Oracle Net Admin Error

Jul 7, 2012

DB 10.2.0.4

After running shut abort it is giving below error while trying to connect sqlplus.

ORA-28547: connection to server failed, probable Oracle Net admin error

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved