Data Guard :: Setup - New Installation Of 11GR2 / OS Windows 2008 R2

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


ADVERTISEMENT

Data Guard :: Logical Standby On Windows Server 2008

Sep 8, 2010

Can i create logical_stand_by for windows server 2008, the primary data base is HP UX , both operating systems are 64 bits and data bases are Oracle 10g 10.2.0.1.0.

View 6 Replies View Related

Enterprise Manager :: Configure Data Guard Setup - Oracle 10gR2 And Windows XP

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

Installation :: 11gr2 Setup Shows Error On Virtual Machine

Jun 4, 2013

I have a virtual machine which have Windows Server 2008 R2 Datacentre 64-bit.

When I install Oracle Database 11gR2 and click on "SETUP" file, a message box namely JAVA VIRTUAL MACHINE LAUNCHER and display below error;

_"Could not find the main class. Program will exit."_

Same setup runs successfully on my server with Windows Server 2008 Enterprise.

Is it 11gr2 supports a virtual machine which have Windows Server 2008 R2 Datacentre 64-bit ? or some other?

View 4 Replies View Related

Windows :: Installation Of 10g R2 On Windows Server 2008?

Sep 30, 2010

I want to install Oracle 10g R2 on Windows Server 2008.

View 22 Replies View Related

Installation Of Oracle 11g R2 In Windows 2008

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 2 Replies View Related

Windows :: Oracle 10g Installation - No Configuration Setup

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

Installation :: 11g On Windows 2008 R2 - Unable To Start Oracle Service

Aug 30, 2012

I tried to reinstall oracle 11g on windows 2008 R2 and couldn't complete the installation as i am unable to start the oracle service. The system gives the following error message

Instance created.
DIM-00019: create service error
O/S-Error: (OS 1053) The service did not respond to the start or control request
in a timely fashion.

I try to manually create the service and it gives me the same error.I also tried to start the service using the net start as follows

C:UsersAdministrator>net start oracleserviceprod
The service is not responding to the control function.

Having looked at the event viewer in windows, I noticed three different error messages as followsr

Application popup: Microsoft Visual C++ Runtime Library : Runtime Error!

Program: c:appadministratorproduct11.2.0dbhome_1inORACLE.EXE

R6034
An application has made an attempt to load the C runtime library incorrectly.and then A timeout was reached (30000 milliseconds) while waiting for the OracleServiceprod service to connect.

The OracleServiceprod service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.

View 26 Replies View Related

Windows :: Oracle 11gR2 64-bit On XP - Error While Installation

Aug 9, 2010

I am trying to install oracle 11gR2 64-bit on windows XP 64-bit Operating System, after the completion of the steps where I have to enter the path for the ORACLE BASE and other parameters when I click next and then Finish, I receive an error, you can check in the attachment.

View 11 Replies View Related

Windows :: Installation Of Oracle 11gR2 - Error In Trace File

Apr 8, 2013

I am trying to install Oracle 11g R2(64bit) on Windows 7 64 bit OS. While Creating Database using DBCA. I am getting error. Below is the screenshot.

Below is the error in the Trace file...

oracle.sysman.assistants.util.step.StepExecutionException:
Error in Process: C:Oracleapporacleproduct11.2.0serverinorapwd.exe
Unable to find error file %ORACLE_HOME%RDBMSopw<lang>.msb

View 3 Replies View Related

Server Administration :: Installation Of Oracle 11gR2 On Windows 7 64-bit Fails With ORA-12560?

Apr 15, 2012

I want to install Oracle EE 11gR2 on my Windows 7 Professional 64-bit laptop. Installed memory is 8GB.I need to install 32-bit server since Oracle Warehouse Builder will not run on a 64-bit o/s. Further, I use Toad 9.7.2 which will only recognise client 32-bit.

I had a few failed attempts, especially when the database was being created with the ORA-12560: TNS:protocol adapter error,

So here's what I did:

Changed C:WindowsSystem32driversetchosts so that it contains two lines 127.0.0.1 localhost & ::1 localhost
Changed properties of setup.exe in the installation directory to be Windows XP SP2 compatible and run as administrator
Selected "install database software only" (so I could figure out at what step the installation fails)
Selected "single instance"
Selected "Enterprise Edition"
Selected oracle base "c:app" (instead of default location c:appd_seng)

Copy of files was completed successfully, log file was created in c:program files(x86)oracleinventorylogs & registry entries were added to "HKEY_LOCAL_MACHINESOFTWAREWow6432NodeORACLE" (with keys KEY_OraDb11g_home1, ODP.NET & OracleMTSRecoveryService), and the following services were created:

OracleMTSRecoveryService: Started/Automatic
OracleOraDb11g_home1ClrAgent: Not started/Manual
OracleRemExecService: Started/Disabled

There are no listener.ora & tnsnames.ora yet. Sqlnet.ora is created with the line SQLNET.AUTHENTICATION_SERVICES = (NTS)

Now I went to Start, All Programs, Oracle - OraDb11g_home1, Configuration and Migration Tools, right clicked on "Net Configuration Assistant" and changed the properties to be Windows XP SP2 compatible and run as administrator and ran it. I selected "Listener Configuration", added a listener called LISTENER, TCP protocol, port 1521 and finished. A service called "OracleOraDb11g_home1TNSListener" was created and started in automatic mode. The PATH was updated and listener.ora was created with the lines:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:appproduct11.2.0dbhome_1)

[code]...

Tnsnames.ora is also creaed with the contents:

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)

At the command prompt, lsnrctl.status shows:
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2012 12:42
:19

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSG-HP6555b)(PORT=1521))

STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 15-APR-2012 12:37:54

[code]...

At the command prompt, lsnrctl.services shows: LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2012 12:43:15

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSG-HP6555b)(PORT=1521))
)
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER

The command completed successfully Now I went to start, all programs, Oracle - OraDb11g_home1, Configuration and Migration Tools, right clicked on "Database Configuration Assistant" and changed the properties to be Windows XP SP2 compatible and run as administrator and ran it.

I chose to create a databaseGeneral purpose Global database name ORCL SID ORCL Chose "Configure Enterprise Manager" & "Configure Database Control for local management" and disabled "Automatic maintenance tasks" Used the same password for all accounts

Selected storage type "File System" & "Use Database File Locations from Template" Unchecked Flash Recovery & Archiving Selected "Sample Schemas", "Typical" memory size (1228MB), "Use Automatic Memory Management" Left sizing/character sets/connection mode as default, and Selected "Generate Database Creation Scripts" in C:appadminORCLscripts (if I choose to Create Database, it fails with TNS Protocol Adapter Error).

I now open ORCL.bat in an editor, go to command prompt, create the directories as per the file, set ORACLE_SID=ORCL & path.

Running C:appproduct11.2.0dbhome_1inoradim.exe -new -sid ORCL -startmode manual -spfile gives a message "instance created" & services "OracleJobSchedulerORCL", "OracleVssWriterORCL" (started) & "OracleServiceORCL" (started) are created.

The next step C:appproduct11.2.0dbhome_1inoradim.exe -edit -sid ORCL -startmode auto -srvcstart system give an error "Unable to start service, OS Error 1056" (probably implies services already running), nothing is present in the windows alert logs about this. If I stop the service OracleVssWriterORCL, then this command completes, although no messages are returned.

The next step in the batch file starts sqplus /nolog and calls ORCL.sql.

ORCL.sql accepts passwords for sys, system, sysman & dbsnmp. It then executes host C:appproduct11.2.0dbhome_1inorapwd.exe file=C:appproduct11.2.0dbhome_1databasePWDORCL.ora force=y, which prompts me for the password for sys.

ORCL.sql then calls CloneRmanRestore.sql, which then tries to run connect "SYS"/"&&sysPassword" as SYSDBA

This is when I get the error ORA-12560: TNS:protocol adapter error, which has been haunting me for days.

My gut feel is that the database creation step at sqlplus is unable to recognise the listener...or probably it does not recognise the modified registry location (with Wow6432Node), the file oracle.key in C:appproduct11.2.0dbhome_1BIN shows the string SOFTWAREORACLEKEY_OraDb11g_home1.

I then changed oracle.key to point to SOFTWAREWow6432NodeORACLEKEY_OraDb11g_home1, restarted the listener and ORCL service, but connecting as sys returns the same error.

View 30 Replies View Related

Windows :: Unable To Start DBCONSOLE After Initial Installation Of Oracle 11gR2?

May 29, 2013

unable to start the DBCONSOLE immediately after installing Oracle 11G R2 onto my Windows 7 box. Here is what I have ran from the command line:

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:Userssandifer>emctl start dbconsole
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
C:Userssandifer>SET ORACLE_HOSTNAME=localhost

[code].....

I checked the above listed file path, and sure enough, OC4J_DBConsole_localhost_orcl is missing.

View 7 Replies View Related

Upgrade :: Data Guard Setup From 10g To 11g

Jun 23, 2013

We have dataugard set up on linux with oracle10.2.0.1.0 and now we want to upgrade that complete setup (primary, standby, dataguard broker) to 11.2.0.3.0.

View 1 Replies View Related

Installation :: Oracle Database 11gR2 On Virtual Box on Windows 32bits Machine

Oct 31, 2013

I have an issue during the database configuration using DBCA at 85% it blocs, then it displays an error asking to reconfigure ORACLE_UNQNAME.

View 6 Replies View Related

Server Administration :: Oracle 11g R2 Installation On Windows 2008 64 Bit Server

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

Data Guard :: Setup/ Archive Destination Configuration

Mar 28, 2011

We have a request to configure data guard for databases on the production server. Here is my situation:

We have a backup strategy in place where the backups are being taken on a regular basis. Archive logs are deleted as soon as they are backed up.

My question now is , is there a way of configuring the Data guard in such a way that there would be no change to existing backup strategy (RMAN) and still duplicate the archive logs to another destination and not delete the archive logs by RMAN backup process on that destination while the first destination is deleted.

We will be deleting the logs in the second archive destination using a script which checks if the logs were applied.

View 2 Replies View Related

Data Guard :: Setup Physical Standby Without RMAN?

Jul 1, 2012

Can i setup physical standby without RMAN? I want to create a fresh single physical standby without RMAN .. If i copy all files in another system and take the controlfile from primary as alter database create controlfile for standby ... and fill all the gaps with archives.. Should it work ? i am on 10G Rhel 4 linux.. and both machines would have same config

View 12 Replies View Related

Data Guard :: Setup Disaster Recovery Site

Aug 25, 2012

1.What are the basic things we need to analyze before we recommend the business to go for oracle Dataguard for DR setup?

2. Do you know any technology that will replicate the schema from one datacenter[one primary database ] to another datacenter [secondary or replication database]?

3. What are the various option to configure the disaster recovery plan at schema level?

View 3 Replies View Related

Data Guard :: How Much Bandwidth Required For Active Setup

May 25, 2013

How much bandwidth required to setup Active data Guard? How to measure bandwidth requirement from primary site? Any ML or doc would be great.

View 1 Replies View Related

Data Guard :: Data Files Locations On Oracle 11gR2

Jun 15, 2012

I have set up a cross platform (Microsoft Windows IA (32-bit) -> Linux x86 64-bit) data guard and it worked fine.Then I did a switch over (which again worked) and found out the data is not getting replicated at all.. checked the data files available from the new primary database and found out they are in the windows format as below..

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
D:ORACLEAPPADMINISTRATORORADATAMFSSYSTEM01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSSYSAUX01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSUNDOTBS01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSUSERS01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSRMANRMAN_TS01.DBF

and physically they were created at '/home/app/oracle/product/11.2.0/db_1/dbs/' and as

D:ORACLEAPPADMINISTRATORORADATAMFSREDO02.LOG
D:ORACLEAPPADMINISTRATORORADATAMFSREDO03.LOG
D:ORACLEAPPADMINISTRATORORADATAMFSRMANRMAN_TS01.DBF

View 5 Replies View Related

Data Guard :: How To Disable REAL TIME QUERY In DG 11gr2

Dec 11, 2012

With 11gr2, by default, on STARTUP, the standby database is open
-> in READ ONLY mode
-> with Intended State: APPLY-ON

so the ACTIVE DATAGUARD option is in use ....

is there a way to deactivate REAL TIME QUERY permanently, so whether on STARTUP or STARTUP MOUNT, the standby stay only mounted with Intended State: APPLY-ON

The only way i found is to do the following :

SQL> startup
DGMGRL> edit database 'PHNXENT' set state='APPLY-OFF';
then
SQL> startup mount
DGMGRL> edit database 'PHNXENT' set state='APPLY-ON';

View 10 Replies View Related

Backup & Recovery :: Transfer Database From Windows 2003 32 Bit To Windows 2008 64 Bit

Mar 30, 2011

I want to Transfer Oracle Database 11g Release 11.1.0.7.0 on windows 2003 32 bit server to Windows 2008 server 64 bit I have Cold RMAN backup. and directory structure of both server are same Do i need to do anything to change datafile to 64 bit or do i need to apply any change to any object

View 6 Replies View Related

Windows :: Unable To Install Oracle 10g Client On 64bit Windows 2008

Jul 16, 2008

We have a .NET application on windows server 2008 32bit using the stored procedures on an Oracle 10g environment. We are trying to deploy the .NET application onto a 64bit x86 Windows server 2008.

We face an error trying to install the x64 version of the Oracle 10g client on windows 2008. The error we get is Problem signature:

Problem Event Name: APPCRASH
Application Name: javaw.exe

Is the x64 version of the Oracle 10g client certified for Windows 2008? Has anyone successfully installed the 64bit version of the oracle client on win2008?

We have a workaround in place with 32 bit version of the client running with the 32 bit version of the .NET application on x64 win2008. However to maximize the infrastructure we need to use the 64 bit version or we would have to turn to MSSQL Server .

View 4 Replies View Related

Windows :: Installing 10g Database Software On Windows 2008 Server?

Sep 28, 2010

I've tried to install Oracle 10gR2 (10.2.0.4.0) on Windows server 2008 (64 bit). I just click on installer and a message appears:

Checking Operating system version: must be 5.0,5.1,5.2 or 6.0

Actual 6.1

FAILED <<<<

Exiting Oracle Universal Installer

Press any key to Exit.

View 12 Replies View Related

Setup Oracle 11gR2 Single Node At Linux?

Jan 11, 2011

I need to setup Oracle 11gR2 single node @ Linux RHat 5 64-bit for long performance tests, huge loads, high speeds, a lot of transactions, having a good scalability, etc.

It's not a production server, but for strong system/volume tests.

CPU
Motherboard
Memory
HDD
Network

View 2 Replies View Related

Data Guard :: Installation In Oracle 10g Database?

Sep 14, 2010

I am planning to use Data Guard facility in Oracle 10g database.

1) I would like to have a standby database, which can be used if the primary goes down and also for reporting and other queries (read-Only).
2) What is the difference between Physical and Logical standby database. I have to explain non-technical users (management) regarding this.
3) What is Sync and Async redo log apply?
4) When i manipulate data (Insert,Delete,Update) in logical standby database, will these changes reflect in Primary database synchronously?
5) Which type of REDO APPLY is better: Managed Recovery Process(MRP) or Real Time Apply(RTA)?
6) can the redo data be deleted if its obsolete or is it deleted automatically by oracle?
7) If i want to take backup, should i take it from primary or standby database? If standby, then the database should be in which mode (Read-only or Recovery Mode)

View 1 Replies View Related

Enterprise Manager :: Data Guard Installation At Grid

Jul 11, 2012

I configured EM grid control(11g) and install agent.when I configured standby database by data guard I got error messages.examine and correct the following error(s), then re-try the operation.

Remote Operation Error - install_driver(Oracle) failed: Can't load '/home/oracle/Oracle/Middleware/agent11g/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: /home/oracle/Oracle/Middleware/agent11g/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied at /home/oracle/Oracle/Middleware/agent11g/perl/lib/5.10.0/x86_64-linux-thread-multi/DynaLoader.pm line 203. at (eval 14) line 3 Compilation failed in require at (eval 14) line 3. Perhaps a required shared library or dll isn't installed where expected at
[code]....

View 1 Replies View Related

RAC/ASM Clusterware Installation :: Oracle 11GR2 Rac Installation In Vmware

Aug 28, 2013

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.

View 15 Replies View Related

Data Guard :: Windows To Aix (logical)

Oct 18, 2010

I have a Windows 2003 server with Oracle 10.2.03 database residing in one datacentre, with Dataguard configured to a physical standby in a similar location (proven process that works great).

I now have a requirement to transfer and synchronize the same live database to a database in a different country (AIX box), purely for data purposes not failover etc. I can transfer an export of the Database and have this up and running as a logical database of the live on AIX, but is it then possible to configure dataguard on the Windows server to also send updates to this logical database on the AIX system? Thus keeping them in sync with each other?

View 1 Replies View Related

Data Guard :: Physical Standby On Windows 2003?

Feb 6, 2013

Is it possible to set a physical standby between 2 servers with same OS but different level ? I mean primary has windows 2003 SP1 and Standby has windows 2003 SP2. I want to know if it will work properly or not.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved