Networking And Gateways :: Database Link Not Working Between Oracle 9i And 11g

May 20, 2011

I'm trying to connect Oracle 11g database from Oracle 9i database, by creating dblink on Oracle 9i database. But my session got hang while i perform this. Here i'm giving the steps i followed on my both the database. Here Oracle 9i database is my source db and Oracle 11g is my target db.

Following steps/setting on Oralce 11g Database

SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE

SQL> alter user SSA identified by SSA;

User altered.

Password File recreted on Oracle 11g Database Server

[oracle1@dev11g dbs]$ orapwd file=/backup/ora11gsoft/odb/OH1/dbs/orapwwbdata
ignorecase=n password=dev entries=5

Following steps performed on Oralce 9i Database

DROP DATABASE LINK "SSA11G.SSA_DB1.WBTEA.COM";
CREATE DATABASE LINK "SSA11G.SSA_DB1.WBTEA.COM"
CONNECT TO SSA
IDENTIFIED BY SSA
USING 'DEVDATA.DEV11G';

Database link created.

SELECT * FROM SSA.SSMASTER@SSA11G;

And the hangs for ever.

View 4 Replies


ADVERTISEMENT

Networking And Gateways :: Database Link Is Not Working

Feb 15, 2010

Database version:10.2.0.3
Operating System:Microsoft Windows XP

I have two database TEST and TEST2 on same windows machine. In TEST database i have created one database link that access one schema in other TEST2 database. but when i passed select command to access object in TEST2 through Database link it is hanging indefinitely.

command that i have used to create Database link: create database link scott connect to scott identified by tiger using 'TEST2'

This is sqlnet.ora Entry:

SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
TNSNAMES.ORA entry:
TEST2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SSIPL-LAPTP-052)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test2)
[code]....

View 3 Replies View Related

Networking And Gateways :: Connecting Oracle To SQL Server Via Database Link?

May 24, 2011

Connecting Oracle to SQL Server via database link.

I am trying to connect from Oracle 10G to a SQL Server database. I have looked at the manual and i will admit that i am finding the documentation quite difficult to follow. There seems to be several options to use but none of the documentation describe how each option works.

As an example, i have been given the following information on the database i need to connect to (i.e. the SQL Server database)

- Username
- Password
- Database Name [lets assume the database name is data_extract]

To connect the above i made the following changes

$ORACLE_HOME/hs/admin/inithsodbc.ora
---------------------------------------
HS_FDS_CONNECT_INFO = data_extract
HS_FDS_TRACE_LEVEL = 0
$ORACLE_HOME/network/admin/tnsnames.ora
---------------------------------------
sqlserver.db =
(DESCRIPTION =

[code]....

Note: In listener.ora, i only added the last SID_DESC entry. I then went on and created the database link as shown below

create database link sqlservdb using 'sqlserver.db';

When i try to access a table i get the following error

sqlplus> select * from TESTTABLE@sqlservdb;
select * from TESTTABLE@sqlservdb
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from ORASQLSERVER

A couple of things i am not sure of:

- Where do i specify the username and password to access the sql server from the oracle db to the sql server db

- Having read around on the internet, i can see some people refering to a DSN datasource. I am told that the information that i have is all i need. Is this correct or do i need something else?

- The sid i specified in inithsodbc.ora and tnsnames.ora is actually the sql server database. Is this correct?

View 10 Replies View Related

Networking And Gateways :: Database Link From 11g To 10g?

Jul 5, 2012

I am trying to create a database link from the 11g database to the 10g database using:

create database link ORCL10R2 connect to <username10g> identified by <password10g> using <db10g>;

It Returns

Database link created.

select sysdate from dual@ORCL10R2 returns error:
ERROR at line 1:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

what changes I need to make to tnsnames and listener at both servers.

View 8 Replies View Related

Networking And Gateways :: Create A Database Link?

Mar 11, 2010

I am trying to create a database link using this syntax:


CREATE PUBLIC DATABASE LINK remote
USING 'remote';

where 'remote' is the service name. It creates it successfully giving the message "External database Created"

Note: I am doing using TOAD

But when i am trying to query something like

select * from scott.employee@remote

it gives an error:
ORA-12154: TNS:could not resolve the connect identifier specified

But the 'remote' db entry exists in the tnsnames.

View 14 Replies View Related

Networking And Gateways :: Database Link Failing With ORA-28500?

Mar 3, 2011

Attempting to create Database Link which talks to SQL Server 2008R2 system

Database: 11.1.0.7 Oracle Standard Edition
Server: Windows Server Enterprise, Service Pack 2 (2008)

I do not have the Oracle Gateway product installed, as this was not configured on my working 10G system.

I tried configuring the link with both the SQL Server ODBC Driver (GMSRES) and the SQL Server Native Client 10.0 (GMSGAS). Returning errors when SQL command is executed.

Everything tests out fine (tnsping, listener configured OK, test connect in Database Link setup). When SQL statement is executed it fails.

Setup:

1. Created ODBC Driver (GMSRES). This tested successfull.
Created SQL Native Driver (GMSGAS). This tested successfull.

2. Created initiGMSRES.ora file C:Oracleproduct11.1.0db_1hsadmin folder.

HS_FDS_CONNECT_INFO = GMSGAS
HS_FDS_TRACE_LEVEL = OFF
HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P15
HS_FDS_CONNECT_INFO = GMSRES
HS_FDS_TRACE_LEVEL = OFF
HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P15

3. Created listener.ora entry:

LISTENERGMS =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=WALL-ALIGN-01.testsystem.com)(PORT=1522))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

[code]....

View 2 Replies View Related

Networking And Gateways :: Testing Private Database Link With Same Name As Public

Oct 13, 2010

We are currently replacing all public database links with private db links in our prod environment. The requirement is

1) private db link name should be same as public
2) Need to create and test out private db links before we can drop public db links.

How can we test out private db links while public db links are still there with the same name?

when I execute SELECT * FROM DUAL@DBLINK from user who created this private db link, which db link it will be using- public or private?

View 9 Replies View Related

Networking And Gateways :: DB Link From SQL Server 2005 (Big5) To Oracle (UTF8)

Mar 18, 2010

We got a big problem that we have a db link to connect to sql server(big 5).

In original setting, there is no Chinese characters in the data. We simply grab the data from sql server and do not have any issue. But now we have data with Big5. When we import the data into our Oracle DB, which uses UTF8, all the text becomes "?

Changing character set in DB is not possible. We need to convert the text into unicode format, or allow oracle/sql server to convert it automatically.

View 6 Replies View Related

Networking And Gateways :: How To Find All The Objects Referring To DB Link

Aug 10, 2012

We have two schemas which earlier used to be separate databases. There were DB links created to access the objects from one schema to the other schema when they were separate databases.

Since now they are just 2 separate schema with in the same Database, we would like to remove the DB Links and create synonyms to access those objects. These DB links were used in code in many places, it is becoming tough to find a way to implement this.

how to find all the objects that are using these objects or all the places these DB likns were being used.

View 1 Replies View Related

Networking And Gateways :: Oracle 10g Client Not Getting Connected To Database

Jun 28, 2006

I am facing difficulty in connecting Oracle 10g client to Oracle 10g database. Both the machines are in windows xp with service pack-2. The following observations are made in server machine

1. The loopback test of the server is successful.
2. One net service name created in the server end.
3. Database connection is successful with above service name.
4. tnsping <server ip address> is successful

The tnsnames.ora file of the server is

# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0db_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.

CONTRACT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 80.0.28.42)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cam)
[code]........

the sqlnet.ora file of the server is

sqlnet.ora Network Configuration File: C:oracleproduct10.2.0db_1NETWORKADMINsqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SQLNET.INBOUND_CONNECT_TIMEOUT = 30

The listner.ora file of the server is

listener.ora Network Configuration File: C:oracleproduct10.2.0db_1NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 80.0.28.42)(PORT = 1521))
)

When I am connecting the 10g database with 10g client I am getting ORA-12170 error.

Attempting to connect using userid: nss
The test did not succeed.
ORA-12170: TNS:Connect timeout occurred

There may be an error in the fields entered,or the server may not be ready for a connection. How to configure this connectivity.

The client side tnsnames.ora file is as given below

# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0client_1NETWORKADMIN nsnames.ora
# Generated by Oracle configuration tools.

CONTRACT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 80.0.28.42)(PORT = 1521))
)
[code]......

The sqlnet.ora file of the client side is

sqlnet.ora Network Configuration File: C:oracleproduct10.2.0client_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

View 13 Replies View Related

Networking And Gateways :: Oracle Database Not Connect From Outside LAN Via Static IP

Nov 17, 2011

I have created two database one for production and another one for test.I created both database in shared_server mode(by using dbca),after than I did not change anything.My problem is when i connect to test database from outside lan through static ip its working well,but when i connect to production database which is not connected. I checked and compared two databases,then I find there are some changes in dispatcher and mts_ dispatcher parameters.And I used this query to check the shared_server status,

ie.select * from v$shared_server,

the output of this query is attached with this post.

View 8 Replies View Related

Networking And Gateways :: Using Putty To Connect To Oracle Database?

Jul 5, 2011

Do I need to install the Oracle client in order to use putty to connect to the database?

View 11 Replies View Related

Networking And Gateways :: Connecting Two Oracle Database In Different Server?

Jul 13, 2012

connecting two oracle database in two different server.I installed Oracle 10g XE in both system.Both system act as Server.I need to connect both server using database link concept.

how to use the tnsnames,ora and listener.ora file for connecting both system.

View 39 Replies View Related

Networking And Gateways :: Configure HSODBC On HP-UX 11.23 For Oracle Database 10g?

May 23, 2011

We want to configure HSODBC on HP-UX 11.23 for Oracle Database 10g R2 in order to establish a DB link from Oracle to Netezza.We have installed the ODBC Drivers too..Currently we have not done any configurations and we go via an AIX box to establish a link.We want to get rid of the AIX box and instead establish directl link towards netezza from HP-UX Box.

Does Oracle support have some guidelines or steps to setup HSODBC on Oracle database 10g r2 residing on HP-UX 11.23 towards Netezza?

View 1 Replies View Related

Networking And Gateways :: Setting Up Connection Between Oracle Developer And Database?

Feb 6, 2011

setup the connection between oracle developer and database.

i found the file called tnsnames.ora however, i cant open it. i dont know if i need to choose a program to open it or download extension for it.

View 12 Replies View Related

Networking And Gateways :: Start Multiple Listeners In One Oracle Database?

Dec 6, 2011

can i start multiple listeners in one oracle database ?

View 7 Replies View Related

Networking And Gateways :: Oracle Database Gateway Installing On Oracle 8?

May 17, 2011

But i do a lot of work-arounds to make sure the installation does not make corrupt my OracleAgent,OracleService and OracleDataGatherer. If i just let the installation do its thing i have problems with my libraries, and can't start anything.

The errors are : Procedure entry point 'BlaBla' could not be located in the Dynamic Link library 'AnyName'.

I notice that i have 2 versions of the libraries in OracleHomeBIN (one version 8, one version 11). The programs that start the OracleAgent,Service and DataGatherer call the old libraries but expect to find values that can be found only in new libraries.

View 1 Replies View Related

Networking And Gateways :: Oracle 11gR2 Database - Performance Difference Between Windows PC And On VMware

Feb 9, 2012

We are having major differences in performance when accessing an Oracle 11gR2 database from two different environments.

I won't sadden you with the gory details of the full application but I will use an indicative example of our problem.

We have SQL Developer in both environments. In each of these SQL Developer instances is a defined a connection to the same database on another machine. So there is the PC looking at a database and a virtual instance looking at the same database.

Selecting the '+' sign next to 'tables' for that connection, on the PC the list of four tables comes back in 4 seconds but on the virtual instance the list of the same four tables comes back in 1 minute and 50 seconds.

This sort of timing issue is repeatable for all accesses to the Oracle database on the third machine.

View 4 Replies View Related

Networking And Gateways :: Maintaining Single Listener In Multi-instance Database Server With 3 Different Oracle Home

Sep 29, 2011

We've been administering a multiple instance production dB server with 3 different versions of Oracle installed.Currently, each of Oracle version had corresponding listener.Oracle 9i had 2 instances, 10g 6 instances & 11g 2 instances also.how I can integrate this 3 listeners into 1.

View 2 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 :: Cannot Connect To Database

Nov 2, 2011

I installed Oracle Express on my Windows 2003 Enterprise server. And right off the bat I cannot connect to it via command line. I have googled and read many sites, but am still getting the same error, no matter what I do. I am newbie again (was a DBA in 1990...when I used to have the same error and fix it in seconds...not sure why this problem still lingers in Oracle) so most likely I am overlooking something. Below are my tnsnames.ora and liserner.ora files

tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myservername.domainname.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
[code]....

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

View 19 Replies View Related

Networking And Gateways :: How Many Listener Supported In One Database

May 30, 2010

How many listener we can have in one database? How many users can be support by one listener?

View 3 Replies View Related

Networking And Gateways :: Controlling Database Access?

Nov 22, 2010

i want to restrict particular ips ,for that i specified

TCP.VALIDNODE_CHECKING= YES
AND
TCP.INVITED_NODES=(IPADDRESS)

in sqlnet.ora file but whenever i connect to database from the particular specified IPADDRESS , the database allows the connection to happen ( doesnot restrict it),

View 1 Replies View Related

Networking And Gateways :: Connect Remotely Database?

Jul 14, 2010

i have a inventory system and trying to connect remote database one by one throught two static ips. If first ip is not ping then go to 2nd ip only when open the login.fmx page

following examples are my tnsnames.ora

IP1.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 117.65.48.12)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))

IP2.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 117.65.48.13)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))

i am not understand what i write the code on-logon trigger

View 8 Replies View Related

Networking And Gateways :: Connecting To Database Outside Network?

Feb 14, 2011

i want to connect to a database that is out side my network and my application is running on forms 6i and database version is 10g .

View 2 Replies View Related

Networking And Gateways :: Unable To Connect To Database?

Feb 1, 2012

I am getting beloww error very frequently in database log and not able to connect to the database.

************************
Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Time: 01-FEB-2012 18:00:34
Tracing not turned on.
Tns error struct:
ns main err 12535

TNS-12535: TNS:operation timed out
ns secondary err 12606
nt main err 0
nt secondary err 0
nt OS err 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.179.1.24)(PORT=65503))
WARNING: inbound connection timed out (ORA-3136)
Wed Feb 01 18:00:44 2012
*****************

View 2 Replies View Related

Networking And Gateways :: Connecting Developer 6.0 To 10G Database

Mar 19, 2010

Can currently connect to a 9.2.0.1 database using Oracle Developer 6.0 with the following connect string:

C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@GMS3B.TEST.COM[/email]

I don't believe it is using the TNSNAMES.ora entry for this, because when I take it out of there it still connects. I create a 10.1.0.5 database and copied the tables,etc to there. But I'm having problem connecting, getting "ORA-12154:TNS Could not resolve service name". Tried the following:

C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@NJZTEST[/email]
C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@NJZTEST.TEST.COM[/email]

I did add the entry for the 10G database to TNSNAMES.ora:

NJZTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = njzainettest.test.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = njztest)
)
)

I new to this, but my guess is the other entry had the full path name..and this SERVICE_NAME does not. But then again I don't believe it looks at the TNSNAMES file. This NJZTEST is the 2nd instance on the NJZAINETTEST machine.

View 6 Replies View Related

Networking And Gateways :: Unable To Connect To Database

Jun 27, 2011

am getting this message when am connecting to a database :

ora-12519:Message 12519 not found;product=RDBMS80 facility = ORA

am not getting this message all the time, sometimes am connected without any problem sometimes i get this message and i have to try again several times until am connected

i searched the net and my database provider guided me to this log URL.....

how to set my ORACLE_HOME environment variable.

View 9 Replies View Related

Networking And Gateways :: Connect Remote Database Without Providing SID?

Apr 5, 2010

i need to connect to a remote database located on a different server using sqlplus without using database name in connect string.

e.g. if mydb1 (located on another database server on network)

sqlplus username/password

i am able to do this on local database but not on the remote database

View 7 Replies View Related

Networking And Gateways :: Client And Database Server On Same Machine?

Mar 26, 2013

I have client and database on same machine, when I will connect to the instance , it will use IPC, suppose If I will use connection string then which process will handle this request?

View 2 Replies View Related







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