Networking And Gateways :: Compare Table Data From Two Different Databases
Jun 1, 20101) how to to compare sybase table data with oracle database table data?
2) how to connect sybase database from oracle database?
ADVERTISEMENT
Networking And Gateways :: Materialized View Data Replication
Jul 9, 2012I have two servers:
10g server 10.1.4.30
11g server 10.1.4.32
I have a table testing_mview on 10g which do not have any primary key. I have created MV log for it:
CREATE MATERIALIZED VIEW LOG ON testing_mview WITH ROWID;
Materialized view log created.
My requirement is
1) if there is an UPDATE/DELETE/INSERT on testing_mview, it should be writen to MATERIALIZED VIEW LOG (this has been achieved)
2) Materialized view testing_mview1 of 11g on server 10.1.4.32 should pull these changes on a scheduled basis ( I have created the database link ORCL10R2 here from 11g to 10 g)
On 11g:
SQL> create database link ORCL10R2 connect to omig identified by pswd using
'(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.4.30)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ICS3)
)
)';
Database link created
SQL> create materialized view testing_mview1 REFRESH FAST with rowid as select * from testing_mview@ORCL10R2;
create materialized view testing_mview1 REFRESH FAST with rowid as select * from testing_mview@ORCL10R2
*
ERROR at line 1:
ORA-04052: error occurred when looking up remote object SYS.DBMS_SNAPSHOT@ORCL10R2
ORA-00604: error occurred at recursive SQL level 2
ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [55916]
ORA-02063: preceding 2 lines from ORCL10R2
Networking And Gateways :: Using A Trigger In OID And Updating EBS Table?
Apr 27, 2011EBS version is 12.1.3. we need to update the e-mail address in per_all_people_f in Oracle EBS based on a trigger that will fire against a column in Oracle Internet Directory (OID). A trigger will be built against table ct_mail, column attrvalue. When a value is inserted or updated this value will use an api on the EBS database to update per_all_people_f.
Q => Is ct_mail the correct table to use in OID for email addresses? or can you confirm a different table?
Q => If Ok to use ct_mail as the table can you see any problems with using a trigger in OID?
Q => Finally is a database link between OID and EBS database the best way for the trigger to work?
Networking And Gateways :: ORA-12504 / TNS Listener Not Given SERVICE-NAME In CONNECT-DATA
Oct 4, 2011I am trying to connect to Oracle 11g using ODBC.I created a data source name from Admistrative Tools->ODBC Data Sources.I selected Oracle in OraClient11g_home1 as the driver. I tested the connection and it was succesful.I tried to connect from visual studio. I used the Data Source as Microsoft ODBC Data SOurce. Selected my DSN from drop down (LORAC). I gave the user name and password and got the followign errors:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
This is my tnsnames.ora located in C:oracleproduct11.1.0client_1
etworkadmin directory.
# tnsnames.ora Network Configuration File: C:oracleproduct11.1.0client_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
LORAC =
(DESCRIPTION =
[code]...
When i do tnsping LORAC, i get OK. When I do tnsping of the other service name i get Failed. However when I try to connect to that service from Visual studio I get a differnt set of errors:
ORA-12154: TNS:could not resolve the connect identifier specified
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
I had assumed that as the test connection from ODBC Administrator had worked I would be able to connec to my database from viusal studio. Is there something wrong in my tnsnames.ora? The content or its directory location?
Networking And Gateways :: ORA-28500 - While Selecting SQL Server Data In Oracle (HSODBC)
Sep 7, 2013I'm facing ORA-28500 error while configuring HSODBC to SQL Server.
Below is the complete information related to listener.ora, sqlnet.ora and tnsnames.ora files. Listener status is showing dg4msql instance successfully started.
I guess I'm facing some issue while creating DB link.
In Oracle 11g Release 11.2.0.1.0 we need to create DB link as below
CREATE DATABASE LINK "DBLNK_ETM_PRODUCTION"
CONNECT TO "USER_NAME" IDENTIFIED BY VALUES 'Password'
USING 'ServerIPAddress:PortNumber/SID';
How to create DB link to SQL Server.
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE11.2.0.1.0Production"
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
---------------------------------------------------------------------------------------------------------------------
$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
[Code]...
CREATE PUBLIC DATABASE LINK DBLNK_1 CONNECT TO "manoj" IDENTIFIED BY "mypassword" USING 'SQLDB' ;
SELECT * FROM MyTable@DBLNK_1 ;
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver][libssclient24]General network error. Check your network documentation.
{08001,NativeErr = 11}[Oracle][ODBC SQL Server Driver][libssclient24]ConnectionOpen (Name or service not known()).
{01000}[Oracle][ODBC SQL Server Driver]Invalid connection string attribute {01S00}
ORA-02063: preceding 2 lines from DBLNK_AVL_CLUSTER2
28500. 00000 - "connection from ORACLE to a non-Oracle system returned this message:"
*Cause: The cause is explained in the forwarded message.
*Action: See the non-Oracle system's documentation of the forwarded
message.
Error at Line: 5 Column: 20
Server Administration :: Modified Objects - Compare Two Users On Different Databases
Oct 2, 2012I want to compare two users on different databases, actaully there are two users one in user a on database a and another user b on database b they have same tables, and everytime when a table or object is created on user a (database a) i will take the table name ,procedure or any other object from user_objects based on ddl_created date and then i need to recreate the same on user b on database b, is there a way to find out tables which are not only created but also i need to check whether if there is any column added or any change in procedure or any other objects.Is there a way to generate the scripts based on list of objects selected from user_objects.
all i want is.
a)Find out the list of objects added along with creation scripts
b)find out the list of objects modified along with creation scripts.
Networking And Gateways :: How To Set Oracle Gateways 11g For Mssql
Feb 21, 2010I 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.
SQL & PL/SQL :: Compare Two Table Data
Mar 5, 2010How to identify the columns which are different between two oracle tables. I have nearly 30 columns in each table comprising of million rows
View 11 Replies View RelatedTable Data Comparisons Across Two Databases?
Oct 4, 2011I want to compare the table contents across the two different databases , one is on netezza and other is on Exadata.
View 2 Replies View RelatedSQL & PL/SQL :: How To Compare Data In Nested Table
Mar 12, 2012create type nesttype as table of clob;
create table emp
(empno number,
ename varchar2(1000),
language_known nesttype
)
I want to check whether language is already there in database or not.
i have written the below query
select * from emp where language_known =nesttype('english','hindi');
i am getting the below error
SQL Error: ORA-22901: cannot compare nested table or VARRAY or LOB attributes of an object type
22901. 00000 - "cannot compare nested table or VARRAY or LOB attributes of an object type"
*Cause: Comparison of nested table or VARRAY or LOB attributes of an
object type was attempted in the absence of a MAP or ORDER
method.
*Action: define a MAP or ORDER method for the object type.
How to compare data in nested table
Networking And Gateways :: TNS Could Not Found
Jun 26, 2013I am working on people-soft, currently i am installing it but i found this error
ORA-12154: TNS:could not resolve the connect identifier specified
/*---------------------------------------------*/
this is listener.ora
# listener.ora Network Configuration File: C:oracleproduct10.2.0db
etworkadminlistener.ora
# Generated by Oracle configuration tools.
HRCS9 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = umhs-86cd1970f)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
SID_LIST_HRCS9 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleproduct10.2.0db)
(PROGRAM = extproc)
)
)
/*---------------------------------------------*/
tnsnames.ora
# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0db
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
HRCS9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = umhs-86cd1970f)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
/*----------------------------------------------------*/
sqlnet.ora
# 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)
/*--------------------------------------------------------*/
Networking And Gateways :: Can Same DB Run On Different Hosts
Oct 8, 2012I have one production server with oracle 11g R2 DB. I have to change Server Hardware and thats why I have to install oracle 11g R2 DB on New hardware and test it. I had installed DB with software only option and copied the cold backup of production server. The hostname and ip address of both the servers are different. I had change the "db_domain" parameter into init.ora with the hostname.Now my question is that can the same db runs on the same network with different hosts. Change of "db_domain" parameter into the init.ora is enough or i have to follow some other procedure.
View 12 Replies View RelatedNetworking And Gateways :: Two Different Listeners In Same Server
Jan 24, 2005I´m working with Oracle 9.2.0 / HP-UX and I need to configure two different listeners for the same server using different IP address.
View 12 Replies View RelatedNetworking And Gateways :: Database Link From 11g To 10g?
Jul 5, 2012I 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.
Networking And Gateways :: How To Change Listerner.ora Name
Dec 12, 2011How to change listerner.ora name ? I want to have something like that application.ora instead of listener.ora.
View 9 Replies View RelatedNetworking And Gateways :: Cannot Connect To Database
Nov 2, 2011I 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)
Networking And Gateways :: Restart Server And Nothing Changes
Mar 28, 2011My client get the error Ora-12514 when he tries to connect to the db.Well;
1) we restart the services: "OracleServiceOrcl" and listener but nothing changes
2) We restart the server and nothing changes
3) We checked the dump and he was done on March,26th. No db export yesterday. Is there any link with the clock change of this week-end (location of the server: France)?
4) The lsnrctl services listener command run successfully but it doesn't mention the instance ORCL.
Networking And Gateways :: License Required To Use OID 11g
Apr 11, 2012Im planning to install OID. I will use it for Oracle Net name resolution and Enterprise User Security.
How is this product licensed? Is it included in a enterprise rdbms license?
Networking And Gateways :: MS Access To Oracle DB
Jul 13, 2010I 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.
Networking And Gateways :: ORA-03114 And ORA-03135?
Jul 5, 2012When I run the below query, the session got the below errors exactly after 1 hour. I checked profile, resource limit, and sqlnet.expire_time. The SQLNET.EXPIRE_TIME value is 10. Except expire time there is time limit in profile and resource. I dont know how this session is losting connection exactly after 1 hour. What could be the issue here and what else need to check it?
14:34:09 SQL> << DELETE query >>
ERROR:
ORA-03114: not connected to ORACLE
DELETE FROM amsoftinstall
[code]...
SQL> select * from V$RESOURCE_LIMIT;
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------------------------ ------------------- --------------- ---------------------------------------- -------------------------
-------
processes 37 49 150 150
sessions 44 56 170 170
[code]...
SQL> select * from USER_RESOURCE_LIMITS;
RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
[code]...
Networking And Gateways :: TNS-12542 / Address Already In Use
Aug 23, 2007I'd got this error, TNS-12542, address already in used on my multithreaded application.
After finding some documents about this error, it happen because other application used same port as my listener. But i'd assured that only my listener, but it didn't happen in the first running process, but after some processes (hundreds of processes).
Networking And Gateways :: ISP Concept In Oracle?
May 29, 2012what is ISP concept in Oracle10g???
View 2 Replies View RelatedNetworking And Gateways :: DBCA Installation Through VPN
Sep 22, 2011I am facing a issue on DBCA Installation, when i tried from off-shore.
a. When Iam connecting a server using production / Model VPN , and try to start Installing DBCA Using X11-Forwarding of putty,
b. DBCA installation Started but its tooo Slow, it takes more than 3Hrs (Started at 9AM and ends at 11.17AM)
c. First time it fails and second time its went to success, Whereas when i take alog of server ping request - I am getting a frequent "Requested time out" due to network fluctuation.
So let me know is the network fluctuation affects the Installation through VPN, if So how to overcome and is any workaround on that ?
Networking And Gateways :: Two Oracle Installs 10G And 11G
Jun 6, 2011We'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.
Networking And Gateways :: Oracle Gateway For MS SQL Server
Mar 11, 2013I 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.
Networking And Gateways :: Connect Time Fail Over?
Mar 12, 2010I would like to implement connect time fail over from my JDBC thin client. The client will try to first connect with dedicated connection mode, if the connection time crosses more than two seconds, then connection will be opened with shared mode. To implement this, I have put the following connection string in my JDBC URL. I am able to connect to database with this URL, however it seems fail over does not work. Is it because, my database listener is not configured with dynamic service registration. If I implement the dynamic service registration, is fail over going to work? Note, I want to fail over in the same database instance but with different listener.
(DESCRIPTION_LIST =
(FAILOVER = TRUE)
(LOAD_BALANCE = FALSE)
[Code].....
Networking And Gateways :: Listener Dynamic Registration
Jan 3, 2012Which parameters are required in init file for 'Dynamic Listener Registration'? (for default port/ protocol). I understand that Local_listener is required only if we are using not default protocol, port.
Also which cases we need listener.ora file? I understand we need it for 'Duplicate Database' using RMAN as well as for 'Data Guard'. what else will need it?
Networking And Gateways :: Deletion Of LDAP Entry
Nov 25, 2010We had an escalation wherein one of team members accidentally deleted an LDAP entry for a database. We use Oracle Net Manager to add/delete the connect descriptor.
Are there any logs using which we can find out as to who deleted the entry.
Networking And Gateways :: HTTP SSL Certificate Causes Errors In IE 6 / 7 / 8
Mar 10, 2012We installed new SSL certificate on Oracle HTTP server and getting an error in IE 6,7,8:
res://ieframe.dll/dnserror.htm#https://...
Examining http headers provide following error description:
ERROR_INTERNET_SECURITY_CHANNEL_ERROR.
How was it resolved?
Networking And Gateways :: ORA-12535 - TNS / Operation Timed Out
Jan 13, 2013I have two related questions:
Scenario 1:
1. I have two remote Windows machines with database on each. One is Win 2003 Server (machine A) and another one is Win XP (machine B)
2. I can ping from A to B.
3. I can ping from B to A.
4. I can tnsping from A to B.
5. I CAN'T tnsping from B to A.
6. Windows Firewall on both machines are off.
What could be possible reason for point# 5?
Scenario 2:Now, the second part:
1. I had an unwanted entry in tnsnames.ora on B which I removed.
2. Then I restarted the listener on B. Actually, I wanted to restart the one on A to check if that resolves issue mentioned in point# 5 above.
3. I tried tnsping from A to B but suprisingly it is also giving "operation timed out" error now. So now tnsping not working from either sides.
I didn't make any changes in listener.ora on B, just stopped it and started again. Only change made was removing unwanted entry in tnsnames.ora on B.
Why does that affected database connectivity from A to B which was working fine previously?
NOTE: The two machines are connected through VPN using LogMeIn Hamachi. Hamachi assigns it's own IP address to each machine. Machine A is Windows Server 2003 and B is Windows XP.