I am starting work in creating database application using oracle with vb.net I install Oracle XE 11g R2 , it work very well , but i need to connect oracle with vb.net , I download '' ODTwithODAC1120320_32bit'' but when I try to install it I get this message ' ODAC for oracle server 11.2.0.3.0 can only be installed over an existing oracle database server 11.2.0.3.0 ' what should I install ?
View 11 Replies
I want to connect to oracle in windows server2008-64 bit by Microsoft OLE DB provider for oracle..is 64-bit Oracle Data Access Components (ODAC) possible for oracle9i?
View 3 Replies View RelatedMy company brought Oracle10g server some years ago. I've noticed that ODAC support Linq and could be used to connect Oracle 10g.
Can we use ODAC 11.2 Release 4 (11.2.0.3.0) with Oracle Developer Tools for Visual Studio for commerical use due we already purchased Oracle 10g server?
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?
I am getting "ORA-03114: not connected to ORACLE" while installing "Oracle Database 11GR2" on "Oracle RAC 11R2" cluster setup. I am getting this error at the time of "Oracle Database Configuration Assistant" configuration reaches till 39% on HP-UX 11.31 IA64 platform.
View 25 Replies View RelatedMy question is; I've been reading the Oracle database 11g R2 documentation at this link [URL]...
I passed a couple of days learning about all installation configuration parts including the desktop class and server class.As I was learning, So I had already downloaded Oracle Database Express 11g R2 for win32.
So as i had finished the installation guide I thought it's time to install the oracle now. I did it, and what I found was that there was not any option during installation that i read in above documentation. While trying to find about this difference i reached on documentation[URL]...
That is for express version only.
My question here is, Express edition, we use for learning purpose, But it doesn't look like it has all the stuff that we should learn during installation And what documentation I should follow from my above given two links?
I am trying to install Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox/Mac OS.But getting problem to set network & ip setting and yum is not able to reach oracle repository.
if anyone tried installing Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox on intel based Mac OS.
I am installing RAC 11GR2 in VMWARE on OEL 6.3. Everything went smooth but when i tried to configure ASM , I get below messages.
[oracle@RAC1 ~]$ /etc/init.d/oracleasm configure-bash: /etc/init.d/oracleasm: No such file or directory.
I downloaded the 11G 64bit for windows and unzipped the files into one folder and ran the setup.exe as an administrator. It opened up the java screen and I chose, create and configure a database. Next screen I chose, Desktop Class, when I click next it dies. It does not show me teh next screen. I went to the appdata folder and saw this error but not sure what to do EXCEPTION_ACCESS_VIOLATION (0xc0000005).
View 10 Replies View RelatedI want to install Oracle Grid software 11g R2. What is the Latest Oracle Grid software 11g R2 version available?Is it 11.2.0.1 or 11.2.0.3?If it is 11.2.0.3, is it available in metalink download, because I see only 11.2.0.1 version in metalink download?
View 2 Replies View RelatedAm planning to install oracle RAC 11g on linux server. Have doubt on installation of clusterware or grid infrastructure first .?I think grid infrastructure covers clusterware and ASM both and then oracle 11g software to be installed. But how to download grid insfrastructure software. Will it come with oracle 11g software..? or need to download it seperately.? Because when i try to download oracle RAC 11g which gives link to download the 11g software not grid.
View 4 Replies View RelatedWhen i am trying to install oracle database 10g, it is giving following error.Error in writing to directory :
c:Users:
ensure that this directory is writable and has atleast 55MB of disk space ,installation cannot continue.
Today I am installing oracle 10g on Enterprise linux 4.5 . I am having some problem while running OUI. Having much confusion with Oracle installation .....
See Error message shows
================
Checking operating system requirements ...
Expected result: One of redhat-3,redhat-4,SuSE-9,asianux-1,asianux-2
Actual Result: redhat-4
Check complete. The overall result of this check is: Passed
Installing OEL but shows actual result was redhat-4
--------------------------------------------------------------------------
CODEChecking for libaio-0.3.96; found Not found.Failed <<<<
Checking for shmmni=4096; found shmmni=-2147483648.Failed <<<<
Checking for libaio-0.3.96; found Not found.Failed <<<<
Check complete. The overall result of this check is: Failed <<<<
here showing -ve value many times i changed values . Still error is here ....
My question is
1) by default OEL having all required RPM's but why it requires LIBAIO.
2) Installing OEL but shows actual result was redhat-4
I have update from Oracle 11.1 to 11.2 - but i cant see the new version
when i type: `Select * from v$version` in pl/sql developer
i still see the old version.
My business requirement is to in stall ORACLE 10.3 on IBM AIX 6.1 .
View 4 Replies View RelatedI want to install oracle 10 g on win 8 , i found way for setup at this link
[URL].......
reach till step 5 and stop as i do not found any file with this name databases tageprereqdbrefhost.xml and databasestageprereqdb_prereqsdb refhost.xml. in oracle source do not know if shall i download them and then update or what ,
I have installed the Oracle 10g at the following location : -
C:oracleproduct10.2.0client_1NETWORKADMIN
But I was trying to ping Oracle Client from Command Prompt. See Below : -
c:Oracle>tnsping SONIA
ERROR IS COMING no listener
MINE tnsnames.ora File : -
# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0client_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
SONIA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sonia)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SONIA)
)
)
What this error means? connecting to the ORACLE 10g. I have studied on the net that for Oracle to connect three ora files need to be there. But in my ADMIN Folder two files are created by Oracle Configuration Tools names SqlNet.ORA , TNSNAMES.ORA. LISTENER.ORA file is not created.
I am setting up a RAC cluster in Oracle 11.2.0.3 on two Windows 2008R2 nodes.I have completed all the pre-installation tasks would like to verify this by running:cluvfy comp sys -p database -n allusing the standalone download of cluvfy - I haven't installed any Oracle software as yet. This completes successfully on the remote node but fails on the local node (whichever one I run it from).
There is a lot of output but these seem to be the key problems: [1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [WindowsSystem.deleteService:876] _WS_ deleteService2: node PRDAT217 Service OracleRemExecService result: 0|Access is denied.[1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [NativeResult.<init>:91] NativeResult: The String obtained is0|Access is denied.[1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [NativeResult.<init>:99] The status string is: 0[1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [NativeResult.<init>:112]
[code]...
I am using newstart cluster software. currently I have two blade servers in my system and I have configured cluster as well. right now I have one issue. I am using the ip address of 10.34.14.0/28 network for cluster but this can not be accessed from all network so I want to use different range of IP of 10.68.1.0/28 network in the same blade servers. Can I configure two different floating (cluster) IP? the first IP range is for signalling and second IP range 10.68.1.0/28 network is for OMM. I need to use both IP in two blade servers.
View 1 Replies View RelatedI am facing strange problem, I installed 9i and 11g on same machine which is running windows server 2003 service pack 2. I set ORACLE_HOME and PATH of both versions different and both are installed properly.
But when i try to create new database using oracle 9i DBCA after reaching step 8 DBCA becomes unresponsive whereas i am able to create new database using Oracle 11g DBCA. After searching the entire net i am not able to troubleshoot the problem. Moreover in both version i am able to access using CMD and i got the connectivity.
I configure the listener for both on different port but when i run oracle 9i the screen shows first connectivity of oracle 11g sql* plus after that it is going to connect to oracle 9i this is my second issue. My system RAM is 1GB total is this is also be the reason for the above problem.
I am going to do the SAP-BO Setup in our landscape, how to do the following....
1. How to do the Oracle installation for BO in AIX (UNIX)? Is it a normal installation? or different? BOE-Application will be installed on Windows. So the DB suppose to communicate with the Application.
2. How to do the sizing of database?
3. How to create a database schema in oracle with proper parameters? I need to create 7 schema.
4. What are the parameters we have to maintain in Oracle - init.ora file which is required for BO ?
The steps for the subject line mentioned. and pre-reqs or post-checks if any.
View 3 Replies View RelatedI m getting error while installing ORACLE 10.2.0.1 client on windows error is as follows :"The path is more than 1023 character....."
------------------------------------------------------------------------------
my PATH variable contains following value
D:\oracle\product\10.2.0\client_1\bin;C:\Program Files\CA\SC\CAWIN\;E:\oracle\product\10.2.0\db_1\bin;C:\Program Files\Common Files\NetSarang;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\PROGRA~1\CA\SC\CAM\bin;C:\Program Files\CA\DSM\bin
i need to make RAC database setup ,so where can i get the operating system Rpm like bleow
compat-gcc-7.3-2.96.128.i386.rpm
compat-libstdc++-7.3-2.96.128.i386.rpm
compat-libstdc++devel-17.3.3.96.128.i386
compat-gcc-c++7.3.296.128.i386
send me link for the above require rpm for linux AS4.
Oracle 11g installation problem in Oracle VM VirtualBox (Linux)
I've attended the training on 11g admin i in my school and still confused about installation. My tutor asked me to copy the ".vdi" file from my school and import into my home pc for practice. He said in order to practice at home, have to do the following.
1. Grid Infrastructure
2. Oracle Software
3. Oracle Database
I already installed Oracle VM Virtual Box and imported the ".vdi" file (In Linux). Does this vdi file include all the 3 items above? My vdi file size about 30G. Currently, i can't access Enterprise management, dbconsole.
I am an expert Oracle Form developer in 6i and 10g. Now a days I am having database connection problem in Forms 6i, in Forms 10g it does not deploy in all machine/web browser. I have tried to deploy forms 10g with jre. It works perfect in my Laptop. but when I try the same procedure in Other machine it does not work any way.
No clue what is the problem some frm-92095 is the error. Then I have heard form one of my friend that forms 11g works fine for all machine and web browser. But it is almost proved to be impossible for me to install it. I have gone through all oracle documentation to install it. But I can't instal it myself.
SQL>startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initora11g.ora'
Unfortunately I can not find initora11g.ora
[oracle@localhost db_1] cd dbs
[oracle@localhost dbs] ls
hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora
so create pfile from spfile='/home//oracle/product/11.2.0/db_1/dbs/spfileora11.ora will not work
[oracle@localhost dbs]$ ls
hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora
I don't see initora11g.ora file - as shown above in oratab also - it showed sid as orcl but I changed into
I have set oracle_sid = ora11g in .bash_profile as well
I try to install th a oracle 10gR2 database to a SuSe Linux 11.4.
I try to install to tha local machine, not to a remote host. But when I start the installation every time I get the next error message:
CODECan't connect to X11 window server using '' as the value of the DISPLAY variable.
Unable to start an interactive install session because of the following error:Can't connect to X11 window server using '' as the value of the DISPLAY variable. The DISPLAY environment variable should be set to <hostname or IP address>:<screen>, where the <screen> is usually '0.0'.
Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:
- For csh: % setenv DISPLAY 192.168.1.128:0.0
- For sh, ksh and bash: $ DISPLAY=192.168.1.128:0.0; export DISPLAY
Use the following command to see what shell is being used:
echo $SHELL
Use the following command to view the current DISPLAY environment variable setting:
echo $DISPLAY
- Make sure that client users are authorized to connect to the X Server. To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:
% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 basedprogram that comes with the native operating system such as 'xclock':
% <full path to xclock... see below>
If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance. Typical path for 'xclock': ''
I think that I don't need the x server when I install the product to the local machine. But every time I get this message.
I have installed oracle form developer10g. without installing the oracle database. Oracle developer 10g can run independently.
I get the Error TNS: Protocol Adapter Error
My listener has the following:
# listener.ora Network Configuration File: D:DevSuiteHome_2NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = ORCL)
[code].......
tnsnames.ora has following words:
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
install the ORACLE 9i & 10g in Windows 7.Whenever time i install the both Oracle ver in Win.7, the some java error comes, and installation is not completed properly.install the Oracle both ver in win 7
View 5 Replies View Related
