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)
I have a requirement wherein I need to access the MS ACCESS database table from Oracle Client.I have created ODBC data source and have configured tnsnames.ora and listener.ora for the same. As a next step I am trying to configure HS init file for hsodbc connection but couldn't find the directory hs in $ORACLE_HOME (<ORACLE_HOME>hsadmininit******.ora). Any patch that needs to be applied for hsodbc connection in the server.
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..
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
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.
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
Do I need to specify the databasename for Processing2? Also the front end boxes (managers) are two different servers so Processingweb1 and processingweb2.
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.
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 .
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
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=
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?
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) ----------------------------------------------------
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?
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
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.
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:
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.
Restarting oracle services through services.msc is faster then manual (In command prompt).
Even If we have heavy transaction on the oracle database But we can restart the database within minutes by using services.msc But It will take more time in command prompt(sql>shu immediate). So shall we assume here that services.msc is using shut abort command while restarting the database?
Currently we are loading data from oracle to sql server through oracle 11g gateway. during running scripts most of the queries takes a long time to complete. Because of this performance issue, we want to configure oracle golden gate to move data from oracle to sqlserver. whats the difference between oracle gateway & oracle golden gate? both are performing same functionality?
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
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';
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
# 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.
# 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.
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.
We are having oracle 9i as database and migrating to sql server 2008. Our oracle 9i database connects to another oracle databases and these databases are having different oracle version(9.2.0.8.0, 9.2.0.7.0,10.2.0.5.0,11.2.0.2.0,9.2.0.6.0,10.2.0.4.0,8.1.7.4.0 )
I do have two queries :
1) how to connect from Sql server 2008 R2 to different Oracle databases
2) How will other oracle databases connect to Sql server 2008 R2 database