Networking And Gateways :: Oracle Net Services Configuration Failed

Jul 10, 2008

when iam running netca on oracle llg iam getting the following error..[wstdba@ora11g ~]$ netca

java.io.FileNotFoundException: /oraeng/app/oracle/product/11.1.0/app/oracle11g/cfgtoollogs/netca/netca_OraDb11g_home1-0802284PM3437.log (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
at oracle.net.ca.NetCA.main(Unknown Source)

Oracle Net Services configuration failed. The exit code is -1...All my services are up and running..

View 2 Replies


ADVERTISEMENT

Networking And Gateways :: Oracle Heterogeneous Services

Mar 13, 2010

I have following file setup for Oracle heterogeneous services for MS Access. I also need to add one more dsn for MS Excel.

# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = MyConn
HS_FDS_TRACE_LEVEL = 0

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

Note: MyConn is for MS Access that I cretaed.

Can we use like this

HS_FDS_CONNECT_INFO = MyConn1, MyConn2,etc.

View 3 Replies View Related

Networking And Gateways :: Connect To SQL Server From Oracle Using Heterogeneous Services?

Mar 11, 2011

I was trying to connect to SQL server from Oracle using Oracle heterogeneous services (HS).But I found that I do not have HS installed on my system. It was mentioned in Oracle website that we need to run 'caths.sql' script under the path $ORACLE_HOME/rdbms/admin.

But I do not have any such folder(rdbms) in my $ORACLE_HOME.What does it mean? And how can I install HS alone on my system(Since I already have oracle)

View 4 Replies View Related

Networking And Gateways :: Listener Support No Services

Jan 24, 2012

i have created a listener for my db and register the service to it some 2 years back now i have checked it and it display as follows

LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 24-JAN-2012 13:49:44
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date 24-JAN-2012 13:45:44
Uptime 0 days 0 hr. 3 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
[code]....

now i have stop and then restart but same status? so how can i manually register it again or anyother solution as i cant run netmgr

View 14 Replies View Related

Networking And Gateways :: Multiple Home Listener Configuration?

Jul 29, 2011

I have installed Oracle 10g in windows 2003 two times with two different homes. (D:oraclehome and E:oraclehome).Databases db01 and db02 created in these homes respectively. how to configure listener and tnsnames to aceess these databases.

View 7 Replies View Related

Networking And Gateways :: Shared Or Dedicated Server - Configuration

Feb 6, 2012

I've below questions about my raised topic.

1. How would I know whether I'm running Shared Server or Dedicated Server?
2. How to configure Shared Server?
3. How to configure Dedicated Server?
4. How Can I use both these connection types with one database?

I mean one session with dedicated and one with shared at the same time.

View 5 Replies View Related

Networking And Gateways :: Stand Alone 11gR2 Database - Listener Configuration

Sep 10, 2013

I have stand alone 11gR2 database. Do I need to configure the listener and have the tnsnames.ora file entries under Grid home and start the listener from Grid home or do I need to start from Oracle database home?

View 5 Replies View Related

Networking And Gateways :: Ora-12546 Tns Permission Failed?

Feb 15, 2010

I am installing Oracle 10g using windows 7 but i am facing problem Ora-12546.

View 6 Replies View Related

Networking And Gateways :: TNS-03505 / Failed To Resolve Name

May 21, 2012

I have 2 virtual machines, in that two vitual machines oracle servers are there.

machine 1 environment file (ofdb.env):

TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=ofdb; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM

[code]....

machine 2 environment file (.bash_profile):

TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=DB11G; export ORACLE_SID

[code]....

Now i want to connect from "DB11G (client)" to "ofdb (server)"

ofdb (TNSNAMES.ora) :

TO_OFDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1523))

[code]....

DB11G (listener.ora) :

ofdb =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

[code]....

in both server & client i had set "TNS_ADMIN = $HOME" (see the above environment files) so,

my listener file is in server home directory

my tnsname file is in client home directory

i was started listener in server (ofdb):

$ lsnrctl start ofdb

listner started successfully then came to client side (DB11G) :

$ tnsping TO_OFDB

"TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 21-MAY-2012 10:11:27

Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name"

View 9 Replies View Related

Networking And Gateways :: Listener Error - Failed To Start

Sep 23, 2011

after creating database i try to start listener i have copied listener.ora and edit according to db created i have folling issues.

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 23-SEP-2011 15:02:05

Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

Starting /u01/app/oracle/product/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
System parameter file is /u01/app/oracle/product/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.1.17.43)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00305: the specified path name does not exist

Listener failed to start. See the error message(s) above...

View 16 Replies View Related

Networking And Gateways :: Listener Start Failed After Configuring?

Nov 2, 2011

i could not able to add and open listener to install Oracle database 11g R2 on window 7 ( 64 bit OS).

Steps :

1) i installed Oracle 11g R2 Software Only.

2) Started DBCA to configure Database

3) I got a message that i need to configure Listener first.

4) I opened NETCA and add a listener ( default name LISTENER)

5) Then re-opened DBCA to start Database configuration and found the same message configure listner.

6) I went to control panel-> Services -> i found no listeners there

7) i started NETMGR and add a listner and its location as well I started DBCA and found the same message add listener

9) i opened LSNRCTL and typed the command to START LISTENER and i found no listener error

10) When i am trying to add listener using NETCA ,during it's last step listener adding completion i found the below message :

Oracle Net Services Configuration:
Stopping Oracle Net Listener:
Running Listener Control:
d:apporacleproduct11.2.0dbhome_1inlsnrctl stop LISTENER
Listener Control complete.
Listener stop failed.

[code]....

View 4 Replies View Related

Networking And Gateways :: Clients Connections Failed Intermittently?

Jul 16, 2012

have some problem between my database and the listener Sometimes I have connection errors: The error occurred intermittently

Oracle 11.2.0.2.0 on RHEL 5
My listener:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
LISTENER =

[code]...

The listener starts and stops normally
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
>lsnrctl start
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 16-JUL-2012 17:51:09
Copyright (c) 1991, 2010, Oracle. All rights reserved.

Starting /opt/oracle/product/EE_11.2.0/bin/tnslsnr: .

[code]...

But there is an error when the database register into the listener (in listener.log):
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
Started with pid=4029
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx)(PORT=1521)))
Listener completed notification to CRS on start

[code]....

View 2 Replies View Related

RAC & Failsafe :: Failed To Upgrade Oracle Cluster Registry Configuration?

Sep 18, 2008

The installation of CRS is successfull & at end it ask to execute 2 scripts on both nodes i.e. orainstRoot.sh and root.sh

When the scripts are executed,the execution of orainstRoot.sh is successfull , but root.sh give following error:

[root@rac2host crs]# ./root.sh
WARNING: directory '/home/oracle/product' is not owned by root
WARNING: directory 'home/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.

[code]....

Is this concerned with permissions on OCR, Voting Disk.

the ./cluvy shows the cluster is valid.

View 1 Replies View Related

Networking And Gateways :: How To Set Oracle Gateways 11g For Mssql

Feb 21, 2010

I want connect mssql in oracle by orale Gateways 11g

my environment:
windows Wista
oracle 11.1.0.7.0
Oracle Database Gateways 11.1.0.7.0
SQL SEVER2008

these soft in one computer.

my steps :

1. set initdg4mssql.ora
2.set listener.ora
3. set tnsnames.ora
4.start lsnrctl
5.use SYSTEM/ORACLE@DZCDB

logined. create dblink and test.

but it's error. i want to know where is the error.

View 1 Replies View Related

Networking And Gateways :: MS Access To Oracle DB

Jul 13, 2010

I have an Access DB which I'm using to connect to an Oracle DB at work. There are several Oracle DB's that I can connect to using Access but this one I'm not able to connect to. I get the Oracle error ORA-25153 Temporary Table Space is empty.

I don't have the ability to make changes to the Oracle DB only to read and query.

View 1 Replies View Related

Networking And Gateways :: ISP Concept In Oracle?

May 29, 2012

what is ISP concept in Oracle10g???

View 2 Replies View Related

Networking And Gateways :: Two Oracle Installs 10G And 11G

Jun 6, 2011

We're deploying a new product release however this build uses Oracle 11G. We want to perform a side by side install for testing purposes. These are low usage systems so installing another Oracle build will not hinder the system.

We intend to test for a couple of weeks and migrate data, then uninstall the 10G. I'm in the process of installing 11G now, the 10G is up and running. I don't want to impact the 10G install. I'm installing 11G in /home/oracle/oracle11G directory. I would like to use 1 Listener.ora file. I've broken down the install bellow.

10G
SID "processing"
Oracle home /home/oracle/oracle10g
/mnt/Oracle/Oracle10GData
/mnt/Oracle/OracleRedoLog

11G
SID "processing11G"
Oracle home /home/oracle/oracle11g
/mnt/Oracle/Oracle11GData
/mnt/Oracle/Oracle11GRedoLog

I've copied the listener.ora file bellow.

LISTENER_PROCESSING =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST= X (PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.2)(PORT = 1521))
[code].......

LISTENER_PROCESSING2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = X (PORT = 1522))
[code]......

Do I need to specify the databasename for Processing2? Also the front end boxes (managers) are two different servers so Processingweb1 and processingweb2.

View 1 Replies View Related

Networking And Gateways :: Oracle Gateway For MS SQL Server

Mar 11, 2013

I want to connect ORACLE-11gR2 that is on linux with an MS sql server. DO i need to use some third party drivers like easy soft ? Can i configure the database gateway without any third party drivers ?

Secondly if my oracle is on linux, can i configure the gateway on a seperate windows machine(that will connect to linux oracle and ms sql server) as i have found the gateway installation setup only for windows version.

View 3 Replies View Related

Networking And Gateways :: Does Oracle 10.2.0.4.0 Supports Ipv6

Sep 15, 2012

We have Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit on AIX 5.3.Just want to know few things mentioned below

1.Compatibility status of 10.2.4 with ipv6?

2.Next Version supporting IPv6 (in case current version doesn't support).

3.Prerequisites/dependencies for implementation of IPv6 (this may be some specific functionality required from NW, specific OS version etc.)

4.Tasks to be done for the implementation of IPv6.

5.Procedure to change from ipv4 to ipv6.

View 2 Replies View Related

Networking And Gateways :: Port Forwarding In Oracle 10g

Sep 8, 2012

i want to online my oracle 10g database but when i make connection string then i don't know what the port i set. I set default port 1521 but it not work on client site .

View 4 Replies View Related

Networking And Gateways :: Connecting Two ORACLE Servers

Aug 8, 2006

I know how to create a database link between two oracle servers, but problem is that SID is same for both servers, Is there any other way to connect two servers without using only 'SID' ..here are TNSNAMES.ORA FILE i HAVE

D.w=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL = TCP)
(HOST=ff.ffc.pic.com)
(PORT = 1521)
[code].......

Is there any other way rather that this

Create database link a connect to username identified by password using 'SID';

Any alternative like using SID.A.w or how I can differentiate these two SID s.

View -1 Replies View Related

Networking And Gateways :: Listener For Oracle HS Not Starting?

Mar 16, 2011

I am done with my configuration for oracle HS to connect to SQLserver. When I tried to start my listener, it is giving the following errors.

-----------------------------------------------------------------
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is D:oracleproduct10.2.0db_1
etworkadminlistener.or
a
Log messages written to D:oracleproduct10.2.0db_1

[code]..

Contents of my listener.ora file are below
--------------------------------------------------------------
LISTENERSQLODBC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=

[code]...

View 1 Replies View Related

Networking And Gateways :: How To Increase Oracle SQL*Net Performance

Nov 25, 2011

One of my MOD_PLSQL based Oracle APEX Application is running on the web. I have almost 1000 web users to access the Application where at least 250-300 users are always on line. In Oracle EM web interface When run ADDM I see suggestions "Investigate the cause of SQL*Net more data to client" or something like this. and I am getting complains about poor server response. Here are my configuration of the system:

Database Server Host: DBServer (Oracle Database 10.2.0.3)
HTTP Server Host: OraHTTP (Oracle Companion CD 10g)

DADS.conf HTTP Server configuration
MOD_PLSQL database access for web clients.

How can I increase database connection performance?

View 6 Replies View Related

Networking And Gateways :: Connecting A Client To Oracle?

Aug 15, 2010

Im trying to connect a benchmarking application (benchmark factory) from my windows 32bit laptop to Oracle on my linux desktop.

When connecting I am supplying the following details: (im getting the error: ORA 12170 : TNS connect timeout occurred)

User/Schema : matt
Password: ****
Host: 192.168.1.9
Port: 1521
SID: orcl
Connect as : SysDBA
Connect Using: Instant Client (selected from a drop down)
----------------------------------------------------

when i use the following command:

tail -100 /home/matt/app/matt/diag/tnslsnr/localhost/listener/alert/log.xml

i get these results:

[matt@localhost ~]$ tail -100 /home/matt/app/matt/diag/tnslsnr/localhost/listener/alert/log.xml
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:26:29 * service_update * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:26:36.708+01:00' org_id='oracle' comp_id='tnslsnr'

[code]....

I have been told client is not getting to the listener because listener is only listening on 127.0.0.1.

unless & until DB server is configured with a routable IP#, no remote client will succeed.

View 7 Replies View Related

Networking And Gateways :: Using Oracle Connection Manager

Dec 4, 2011

I was trying to connect to a remote database from my client machine. Client machine runs a jsp code to connect to the database and execute a query. I have got oracle jdbc on my machine but still unable to connect to the database.

When checked in Google, i found that oracle connection manager has to be used to connect to the database from jdbc if the web server and database reside on different physical servers. But couldn't gather any further information regarding download and installation.

I do not have oracle connection manager on my system. I read in internet that it is shipped along with oracle 11g software. But i am not sure if that was the case in earlier version as well.

My question is where should i install oracle connection manager? (on database server or client machine) and is it possible to download and install only the connection manager as a stand alone so that i can connect to database from application?

View 3 Replies View Related

Networking And Gateways :: ORACLE Disconnect Every 5 Mins

Jul 11, 2012

Recently I came across a problem that 'ORACLE Client Side Disconnect every 5mins in app server' these days.

Situation: We have 3 APP servers, which was configured the same OS and ORACLE Client version and 1 DB server. 2 app servers ORACLE Client Side Disconnect every 5mins.but it's ok in another App server.

1. both Oracle SQL PLUS and PLSQL have this problem.
2. SQLNET.EXPIRE_TIME is the same for 3 APP
3. 2 APP server are virtual machine and balance server
3. APP servers : OS: 2003 Server ORACLE 9i
DB server : ORACLE 11g
4. I don't think it's DB server problem because one App server hasn't this problem

View 5 Replies View Related

Networking And Gateways :: Access Remote Oracle DB / VB-10G?

Jul 30, 2012

I'm using Vb and DB Oracle 10G.

What are the steps for connect oracle DB through internet.

View 10 Replies View Related

Networking And Gateways :: Connectivity Between MS-Access And Oracle SQL

Feb 3, 2011

I am currently using Oracle 10.2.0.1 version, in a single PC (test server) and MS-Access (2003) in it.

I was trying to use the logic of HS ODBC connectivity, but when i try to select the table from the MS-Access i am getting the following error.

"ORA-12154: TNS:could not resolve the connect identifier specified".

to create the successful connection between the MS-ACCESS and ORACLE. I just need to read some data from MS-ACCESS on a monthly base from a particular table.

View 1 Replies View Related

Networking And Gateways :: Mysql Oracle Integration

Sep 25, 2013

I need to created DB link between oracle (10g on linux) and mysql 5.0 to configure a job to fetch data after every hour. I need solution that does not involve:

ODBC Connection
Oracle GateWay
Golden Gate

View 2 Replies View Related

Networking And Gateways :: Connection Between Oracle And Mssql?

Jul 11, 2013

i have 2 instances (one on Oracle 11g and the otherone Mssql) i was asked to make a link between both.

btw i need excecute a procedure from Oracle against Mssql tables.

View 3 Replies View Related







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