Oracle 11g X64 Setup On Windows 2008r2 Server
May 6, 2013
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?
View 8 Replies
ADVERTISEMENT
Jun 29, 2012
we are having problem installing oracle 10g on windows 2008r2 64 bit on a HP ML110 G7 machine.
we have 10203_vista_w2k8_x64_production_db.zip
downloaded from oracle site.
View 3 Replies
View Related
Jan 24, 2002
Cannot run Oracle Developer 6i setup. Windows error message:
AppName: orainst.exe
AppVer: 0.0.0.0 ModName: oibknd32.dll
ModVer: 0.0.0.0 Offset: 0000ad41
View 11 Replies
View Related
Jan 4, 2013
i want to use Oracle database client 10g ODBC driver but i don't have it.
I want the driver for setup.
View 0 Replies
View Related
Feb 6, 2013
I have installed oracle 10g in D drive . The installation says it is successful, without asking the database name or the password . I have followed the steps given in the attached file .
However it is not asking the database name or password ( no configuration set up is appearing for the user to interact with the system ) . So, after installation I can not give the username and password .
View 4 Replies
View Related
Oct 8, 2013
I have one problem when i try to setup ODTwithODAC121010 for connect from Visual Studio 2012 express to Oracle database 10g R2.When i setup ODTwithODAC121010 on Windows 7, can connect from visual studio to oracle database, but when i setup on Windows server 2012 Standard Evaluation x64 can't connect to oracle database through Visual studio 2012 express.
I check in registry of windows server 2012 x64 can't show Oracle folder in registry.how to connect from Visual studio 2012 express on windows server 2012 Standard evaluation x64 to Oracle database 10g.
View 3 Replies
View Related
Jul 5, 2010
I am trying to install Oracle 11g R2 on my Windows 7 Ultimate 64 bit. When I execute setup.exe as Administrator the command window flashes and exits. I could not even see what the message is. Also tried command prompt.
View 12 Replies
View Related
Sep 5, 2012
I'm trying to setup ODBC connection for my Oracle client while installing BO. Following are the steps I followed.
1. Downloaded the Oracle Client from the link [URL] . From that downloaded two zip files. “Instant Client Package – Basic Lite" and “Instant Client Package – ODBC”. Extracted the Zip Files to the folder I created under C: as C:Oracleinstantclient_11_2.
2. Since I'm setting up in ODBC in windows 2008 64-bit R2. I was advised to install 32 bit . So in cmd prompt, from the location C:Oracleinstantclient_11_2, ran odbc_install.
3.Created the Environment variables as
i) *TNS_ADMIN - C:Oracleinstantclient_11_2*
ii) *Oracle_Home - C:Oracleinstantclient_11_2*
iii) *Edited the PATH variable with ;C:Oracleinstantclient_11_2*
4. Created the tnsnames.ora file in C:Oracleinstantclient_11_2. Its content are as follows.
clarity_dev =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = claritydev.vip.its.ebay.com )(PORT = 1521))
)
(CONNECT_DATA =
(SID = clarity)
)
)
5. From the folder %windir%sysWOW64odbacd32.exe, Opens ODBC Data Source Adminsitartor. In that I found my Oracle in instantclient_11_2 and added following details.
Data Source Name : claritydev.vip.its.com
TNS Service Name : clarity_dev
User Id: clarity1
When I test connect it, I get error *ORA-12154:*
* TNS:could not resolve the connect identifier specified*
I've seen FAQs for this error, but couldn't find anything which solves. Is there any steps I'm missing? I've checked in DB properties. It uses SID not the Service Name.
View 3 Replies
View Related
Jan 18, 2011
i want to configure my present Data Guard Setup with Enterprise Manager...and on the Enterprise Manager grid control page i am not seeing any Data Guard option.....i am using oracle 10gR2 and Windows XP.
How to use enterprise manager for configuring Data Guard.
View 9 Replies
View Related
Jun 8, 2011
We are planning to have new installation of 11GR2 and would like to create data guard for this system. I have one server in Houston and other in Austin TX. the OS will be Windows 2008 R2.
How can i set up data guard and what is the requirements?
View 2 Replies
View Related
May 30, 2013
We have a requirement to connect from 9.2.0.8 database on AIX to MS SQL 2008R2 .
Source :
----------
Oracle : 9.2.0.8 (64 bit)
OS : AIX - 4.3.3.0/5.3.0.0 (64-bit)
Target :
----------
MS SQL : 2008R2
OS : Windows 2008 (64-bit)
1] Can we use - Database Gateway for SQL Server for the above set up ? If so , does this require a separate license ?
2] Where Do we need to install the "Database Gateway for SQL Server " -- soruce or target server ?
3] Is there any other solution apart from using "Database Gateway for SQL Server " ?
View 1 Replies
View Related
Apr 8, 2010
My manager is asking to create a SQL scrip, which will provide following information.
Our database is 9.2.0.7.0 on Windows 2000 Server
-How many records Insert / Update or Delete daily in my Oracle database?
- Check Archive log / Redo Log switching information?
-Check database growth ?
View 10 Replies
View Related
Jan 11, 2011
i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.
"The image file D: is Valid, but is for a machine type other than the current machine."
View 1 Replies
View Related
Jun 27, 2012
I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).
All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.
View 3 Replies
View Related
Jan 17, 2012
working on setting up connection between a Windows 2008 server and a pair of Oracle 11g DBs in a RAC Cluster. One Database (let's say DatabaseA) is in one data center, and the other (DatabaseB) is an a secondary, backup database. The RAC Cluster is all set up, working fine, etc. However, I Need to set up the machine.config file on my Windows Server, to go only connect to DatabaseA, unless it fails, in which case, we want it to connect to DatabaseB. Think we could do this if the host app server was Linux/Unix, but it is windows, and I just don't have the background as to the parameters to set up in the machine.config file. They are similar, but different, and we want a very specific behavior (use DatabaseA, unless fails, then DatabaseB). Application is .NET 4.0 app.
View 6 Replies
View Related
Apr 19, 2011
I want to install Oracle 11g R2 in windows 2008 64 bit server. How can I know whether my server is ready to install Oracle ie is all components are available in server or any patch is to be applied etc.
View 3 Replies
View Related
Jan 27, 2011
setup REMOTE DATABASE (or provide me a good link, which tells step by step procedures).
View 4 Replies
View Related
Mar 14, 2012
when i try to install Oracle 10g (10.1.0.2) 64- bits on windows server 2003 enterprise edition 64 bits service pack1 and i try for windows server 2003 standard edition 64 bits on a pc,i am getting the below error.
the image file E: is valid, but it is for a machine type other than current machine
i need to install it as soon as possible .
View 3 Replies
View Related
Jan 7, 2011
Oracle 11g R1 or R2 is availble for Windows Server and If YES then any link for the same.
View 2 Replies
View Related
Apr 26, 2012
I have oracle XE installed on my machine and it was working absolutely fine for the last year or so. Today there was an trojan intrusion which caused some issues with my windows xp OS like hiding some files, desktop etc. After everything was cleaned up and things back to normal. I am having issues with XE.
1. I can start and stop XE with out any issues
2. When I use the run sql command line, I can connect using - connect sys/sys as sydba.
3. I can also run a query to see all the users and see the HR user also.
However,
1. When I connect to my hr user using connect hr/password@xe, it just hangs
2. I tried the- go to Oracle XE admin page but it just hangs for a long time and returns page cannot be found.
3. I can tnsping the xe instance.
Is a fresh install the only option? or is there any way to correct this using the sys/sys user?
View 9 Replies
View Related
Aug 26, 2013
We wish to configure an Oracle 11g RAC with ASM setup for the internal employee training purpose. The requirement is as follows
1. Operating system Linux, Software Oracle 11g Release 2
2. Need to build total 5 individual clusters.
3. Each cluster with 2 Node
4. Need to configure ASM as a shared storage with real hardware. (No virtualization, Openfiler, NFS)
5. Need to configure RAC database.
provide me the hardware details for configuring Shared storage. Is there any specific Storage which we can use to configure ASM as a storage.
View 2 Replies
View Related
Oct 7, 2010
I'm installing Oracle 10g (10.2.0.4) RAC on Windows enterprise Server. Am able to install cluster ware (10.2.0.4). While installing ASM (10.2.0.3)/ DB its going to restart both the servers automatically. Is there any problem with this Versions (OS and Oracle) combination. Is it compatible or Not?
View 4 Replies
View Related
Feb 18, 2013
I have oracle database server set with Windows NT authentication. How can I get rid of this kind of authentication as this is holding up additional Windows Domain with its own PDS and so on. Or is it possible to move Oracle Database server to a different Domain and authentication to be coming from new domain?
View 4 Replies
View Related
May 21, 2010
I already succeded to setyup Oracle 10 G on my machine , when trying to connect by system/system it does not connect.The listener is OK and instance ok.
View 10 Replies
View Related
Apr 11, 2012
I'd like to know if it's possible to install a client with Windows 7 (64bits) can be installed with Oracle 11gR2 (32 bits) when the server is still with Oracle 10.1.0.2 ?
View 1 Replies
View Related
Jan 28, 2011
I have installed an application suite (AppX) on Windows 2008 Server which has both Windows applications and a web GUI element (ASP.NET running through IIS 7.5).
The Windows apps are in both VB and .NET and compiled specifically for x86 (due to COM component dependencies). I have installed the "Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4)Enterprise/Standard Edition for Microsoft Windows Vista, Windows Server 2008, Windows 7" Oracle Client on the Windows 2008 Server.
After installation AppX windows modules all worked fine with the Oracle Db but the Web Application was getting the following error:
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
After a bit of research I found a few articles suggesting setting up the ORACLE_HOME directory in the Windows Environment variables. So I tried setting up the ORACLE_HOME environment setting and had some success as the AppX web application worked fine! However, the Windows apps of AppX were now broken and returning the error:
System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.
at System.Data.OracleClient.OciHandle..ctor(OciHandle parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags)
at System.Data.OracleClient.OciEnvironmentHandle..ctor(MODE environmentMode, Boolean unicode)
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
[code].........
So I am struggling to get both the Windows and Web App both working on the same Windows 2008 Server.
View 2 Replies
View Related
Dec 24, 2011
How to install oracle 11g in Window Server 2008 R2.
View 6 Replies
View Related
Apr 22, 2013
i have a question about oracle database 9i in windows server 2003 R1 X86 . I set the parameter of pga_aggregate_target=1000M and 500M sometimes i found after few days that error message appear to client
ORA-12500 TNS:listener failed to start a dedicated server process
when i try to connect from the server sometimes logon and sometimes another message appear
ORA-12560: TNS:protocol adapter error
i think the problem in pga_aggregate_target value
View 10 Replies
View Related
Sep 28, 2011
My question is that can i want to make setup or installer in Oracle to deploy in clients machine like other tools did.
View 6 Replies
View Related
May 25, 2013
I am using 11gR2 on windows server. This is the query that runs many times a day and effect badly the performance of database. I don't have much idea about this query.
SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') AS curr_timestamp, COUNT(username) AS failed_count
FROM sys.dba_audit_session
WHERE returncode != 0 AND TO_CHAR(timestamp, 'YYYY-MM-DD HH24:MI:SS') >= TO_CHAR(current_timestamp - TO_DSINTERVAL('0 0:30:00'), 'YYYY-MM-DD HH24:MI:SS')
View 1 Replies
View Related
