Oracle 11g on linuxdestination : ms sql server 2005 i need to create the db link from oracle to ms sql server to view the tables , is it posibble without configuring the gateways( as looks like it is licenced product)
I have installed unixodbc 2.3.1, postgres odbc driver (psqlodbc-07.03) and dg4odbc 11.2..On querying : select sysdate from dual@dblink_postgresql, the following error occurs:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a' : file not found {01000} ORA-02063: preceding 2 lines from DBLINK_POSTGRES
Similar error appears in the trace file as well.
[unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a' $ isql -v postgresql postgres postgres@2012 [01000][unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a' : file not found [ISQL]ERROR: Could not SQLConnect
However the file is present in the location and has no permission related problems.
$ pwd /oracle/psqlodbc/lib $ ls -lrt total 2952 -rwxr-xr-x 1 oracle oinstall 663 Mar 25 15:28 psqlodbc.la -rw-r--r-- 1 oracle oinstall 731419 Mar 25 15:28 libpsqlodbc.a -rw-r--r-- 1 oracle oinstall 12215 Mar 25 22:11 win_md5.o -rw-r--r-- 1 oracle oinstall 18100 Mar 25 22:11 options.o [code]....
I am using oracle 11g express edition and MY Sql database How to establish database link between them using ODBC gateway. I am using ODBC gateway Mysqlodbc connector.
select from the postgre databse works just fine (however when i select data column alone it returns as date, if i select it together with som condition in where clause it returns varchar).
-- this runs ok select t."idbill", t."idpoint" from "crm"."bills2points"@dl_carecloud t ,"crm"."bills"@dl_carecloud brg where 1=1 and t."idbill" = brg."idbill" and t."idbill" = 9685; [code]....
I am trying to configure HS for Excel file. I am getting following error:
SQL> select table_name from all_tables@ODBCEXCEL; select table_name from all_tables@ODBCEXCEL * ERROR at line 1: ORA-28513: internal error in heterogeneous remote agent ORA-02063: preceding line from ODBCEXCELHeres my setup: [code]....
I am working on oracle and pl/sql since some time. so just a novice. I don't know much about sql server or transact sql, etc..I have a requirement to create an interface between Oracle and sql server.
we have a database on oracle and another on sql server. my requirement is to create an interface between oracle and sql server and see how can I update one (or more) tables (I am guessing using pl/sql) on sql server.
Oracle Corporation --- TUESDAY AUG 21 2012 11:17:46.685
Heterogeneous Agent Release 11.2.0.1.0 - 64bit Production Built with Oracle Database Gateway for ODBC
oracle server NLS_CHARACTERSET is UTF8 and mysql server Character set is UTF8, how should i configure the parameters HS_LANGUAGE(initsid.ora) and CHARSET(odbc.ini)? now i configure the CHARSET = UTF8 and HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15,but the sql query reslut like this:
SELECT "id","name" FROM "accounts"@LNMYSQL _______________________________________ xy-20120712-00016728 é士焱
we have microsoft sql server, oracle gateway server (11G) and database server (10.2.0.5) we already make the full setup, and it's working.
we create materialized view into oracle server to read a data from sql server, but the refresh of MV take long time so we are planing to create the materialized view into oracle gateway server.
create MV into oracle gateway server?i mean i don't want to download oracle database instance for only one MV.
Oracle 11gR2 Linux 6.x Sybase 12 (on Windows) unixODBC 3.2.x Sybase Client 12 ------------------------
Given the following files or structures that are important to the proper operation of the ODBC Gateway connecting to a remote Sybase database:
listener.ora tnsnames.ora initmydblink.ora ( my version of the initdg4odbc.ini ) dblink (not a file but the dblink in the Oracle database) odbc.ini odbcinst.ini
What files (and what properties within those files) may/must be changed if the remote Sybase db and system is different (i.e. the Sybase database source has been changed to something 'new')? For example, I can that the odbc.ini file is going to have to be alterer to point to the new database server IP address, database port, database name?
i have created the DB LINK from Oralce 11gR2 to MS Sql Server 2005,able to access the view of Sql Server from Oralce,but the Columns which have Datatype nvarchar(max) in Sql Server am not able to access through DB Link.
Now I have a question : I had Application ERP (use Oracle 10g) and another Application PLM(use MSSQL) , I want to integrated this two application,but I do'nt know how to begin ? is this any document can study? Beside , Is Oracle 10.2.0.1 transparent Gateway for MSSQL is free?? or charged? if free , where to download?
I would like to develop a system with Oracle 9i as the database and PHP 4/5 as the front end. I am not able to establish the connectivity to the database. What should I do now ?
We have a 2 node RAC installation on IBM AIX 5.3 with Oracle Standard Edition. We need to create a manual standby database (becoz Standard Edition does not allow Dataguard confign). Can we do this on a different platform (eg: Linux/Windows). This is to make use of existing servers for the standby environment.
we have a database available in UNIX machine A which can be connected from client in UNIX machine B through port 1521. If we give ping command from UNIX machine A to B or B to A, 0% packet loss, means connection established properly through firewall in port 1521.
Now we are setup one more UNIX machine C and installed a client here. This machine is available in different group, means if i give ping command from machine C to A, 100% packet loss. But from machine A to C, connection established with 0% packet loss.Because of this, when we tried to connect to a database from client in Machine C to database in Machine A, we got "time out" error.
My query is: 1. Is this because of not opening of port 1521 through firewall? 2. If so, is it enough to open port 1521 through firewall when we connect from machine C to A? 3. Any additional setup is required in firewall apart from opening of ports?
need to know how to connect remote database (ie my office oracle database) from my personal laptop. Using TOAD Software. me with the step by step procedure, and what software's I have to download.
we have a production database 'X'. Now i have created a test database 'T' and did'nt configured another listener to it! The issue is when i cam connecting to oracle through sqlplus i am directly connecting to Test database 'T' but not the production database 'X'----ofcourse i can login to production DB afterwards. but initially i want to access the production database 'X'.
I am having a application which is on Widows NT Operating system.I am using Oracle 10g Database, Developer suite 10g And 10g Application server.
My application uses Run_report_object to generate reports.Run_Report_Object is called in forms and Report server is configured in the same Application server where FMX are placed.
The report generation was working fine as long as oracle default login was used. When i created a form to handle login on my own, Report server is throwing "Unable to connect to database" error. My login forms takes the parameters from user and calls default logon command in on_Logon trigger.
I am setting up a new production Oracle 11gr2 database on Windows 2008r2 server. I will have SAN(HP 3PAR) attach to the physical server. Here is my plan for diskLUN allocation:
1. 2 SAS disk in Raid1 for OS. 2. 2 SAS disk in Raid1 for Oracle database binary file. 3. 1 LUN for data file. (system, application, user table space) 4. 1 LUN for log file. 5. 1 LUN for temp. 6. 1 LUN for backup.
is this configuration OK? Does UNDO table space on separate LUN or it's OK to put it on data LUN?
I am building the Oracle on RHEL 5(on Virtual machine with fixed disk space). I could install, after configuring and tried to connect to the database using "sqlplus system" on the command prompt(logged in as root), I get the following error message:
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory
after connecting to database using username and password , i get below error message connection is established and able to work asusal,
Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options select 'Welcome to database: ' || name from v$database * ERROR at line 1: ORA-00942: table or view does not exist
i have a database nd only 10 users must allowed to access db at any point of time and sessions per user must be 1.that is only 10 users must be able to access the database.
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:
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.
We've got a 32 bit .Net windows application which uses ODAC 10g (1.x) to connect to a 10g database on the backend. Things work fine in this deployment.
We're in the process of setting up a new development machine. This machine has ORACLE 11g (64 bit) installed on it. We're running into issues connecting the the database.
This is the code block we're using to connect to the database: ======================================= string dataString = "user id=xxx;password="xxx";data source=localhost:1521/ORCL"; using (OracleConnection oraconn = new OracleConnection(dataConn)) { oraconn.Open(); Oracle.DataAccess.Client.OracleCommand cmd = new OracleCommand(sOraSQL, oraconn); [code]........
We get an exception on the "oraconn.Open()" command.
The output window in VS2010 shows this: ----------------------------------------------------------- A first chance exception of type 'Oracle.DataAccess.Client.OracleException' occurred in Oracle.DataAccess.dll
The oraconn variable looks like: ------------------------------------------- - oraconn {Oracle.DataAccess.Client.OracleConnection} Oracle.DataAccess.Client.OracleConnection + base {Oracle.DataAccess.Client.OracleConnection} System.ComponentModel.Component {Oracle.DataAccess.Client.OracleConnection} ConnectionString "user id=xxxxx;password="xxxxxx";data source=localhost:1521/ORCL" string ConnectionTimeout 15 int DataSource "localhost:1521/ORCL" string [code]........
The details of the exception are: --------------------------------------------- - ex {""} System.Exception {Oracle.DataAccess.Client.OracleException} + [Oracle.DataAccess.Client.OracleException] {""} Oracle.DataAccess.Client.OracleException + Data {System.Collections.ListDictionaryInternal} System.Collections.IDictionary {System.Collections.ListDictionaryInternal} HelpLink null string [code].........
To reiterate, in our original deployment (10g database with 10g (1.x) ODAC, we can connect fine with the database. It's with the new setup (11g database with 10g(1.x) ODAC) that we are having issues. We've previously been able to deploy on client machines which were using ORACLE 11g. To accomplish this, we had to make sure that the password was inclosed in quotes (").
What is going on here? What should we be looking at? How do we go about debugging fixing this?
