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


ADVERTISEMENT

Server Administration :: Restoring The Oracle Services In Windows 2008 Server

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

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

Server Administration :: How To Migrate Database From Windows 2003 To 2008 Server

Oct 31, 2012

I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .

View 22 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 :: ORACLE 11g R1 Or R2 For Server 2008 R2

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

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

Oracle 10g RAC On Windows 2008 Enterprise Server

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

Windows :: How To Install Oracle 11g In Server 2008 R2

Dec 24, 2011

How to install oracle 11g in Window Server 2008 R2.

View 6 Replies View Related

Windows :: Accessing Oracle 7 Database From Server 2008

Jan 11, 2013

We have been upgrading our servers to Server2008 and are getting..

[ORA-3134: Connections to this server version are no longer supported.]

..using the drivers we used to use in XP and Server2003 to access a legacy Oracle7 db. Connections to this db are needed for typical CRUD functionality by multiple applications, some written in Classic ASP and some in C# .NET 3.5 & 4.0. I have tried ODBC drivers (System.Data.Odbc) and also ODP (Oracle.DataAccess.Client) to no avail.

Any existing driver solution to make this connection without have to resort to a custom HLI interface?

I would think we aren't the only ones needing to access Oracle7 from Server2008.

View 7 Replies View Related

How To Download Oracle 10gR2 To Windows 2008 Server R2

Jun 27, 2012

I'm trying to download Oracle RDBMS 10.2.0.5 for Windows Server 2008 R2. But i don't see it on OTN or edelivery....i can't find any link...Have i to request a SR on metalink?

View 2 Replies View Related

Windows :: ORA-12154 - Running 32 Bit Oracle Software On Server 2008 64 Bit

Oct 6, 2011

There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.

Since all the 32 applications will have the path C:Program Files (x86) on 64 bit windows, The PATH variable doesn't recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client. Still the user is facing the same issue.

Oracle Client: 10.2.0.3 32 bit
Windows OS: Windows server 2008 R2 64 bit

I have referred document [ID 334528.1] from the metalink(which states that the bug is fixed in 10.2.0.3 client).

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

Server Administration :: Installation Of 11g On Windows 7 32bit

Feb 10, 2012

I have installed 11g R2 on windows 7 32bit then I uninstall it through deinstall but now again i am installing it it says

Cause - The chosen installation conflicted with software already installed in the given Oracle home.

Action - Install into a different Oracle home.

How can I remove that Oracle Home.

View 8 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

Client Tools :: Oracle Client 32 Bit On Windows Server 2008 R2 64 Bit

Jul 20, 2012

Can i install Oracle 10g Client 32 bit on our Windows Server 2008 R2 64 bit?

View 1 Replies View Related

Forms :: Version 10.1.2.0.2 With Windows Server 2008 64 Bit

Dec 12, 2011

is Forms [32 Bit] Version 10.1.2.0.2 not supported with Windows Server 2008 64 bit ?? i tried to install it and it was failed.!

View 2 Replies View Related

Windows :: How To Schedule Backup On 2008 Server

Jun 27, 2010

On windows 2008, need to schedule task for database backup.

View 4 Replies View Related

Enterprise Manager 11g On Windows Server 2008 R2 X64

Oct 18, 2012

EM displays: Enterprise Manager is not able to connect to the database instance

And yest the Database Instance status show open and the instance is up; Listener status is Up; Agent Connection to Instance status is Succeeded (but no details)

emctl status dbconsole shows ""Oracle Enterprise Manager 11g is running"

emctl status agent shows "Agent is Running and Ready"

I can connect with SQL Developer and see everything in the database.

View 11 Replies View Related

10.2.0.5 Patch On Windows 2008 Server R2 64bit

Apr 28, 2011

I have HP server with Windows 2008 Server R2 64bit. I installed latest 64-bit version of Oracle Database 10.2.0.4 and everything works fine and later installed the patch 10.2.0.5 (64 bits) as the Oracle maintains that with the R2 version of the system it is necessary to correct work.

Now, after uploading the patch database starts and closes after about 15 minutes - an additional log file is changed to the binary version which do not see anything.

how to solve problem? The move to Oracle 11 drops.

This is the link to my alert log file (it's strange after 10.2.0.5 patch installation):

[URL].......

I attached my spfile.ora file too:

[URL].......

View 1 Replies View Related

Server Administration :: Monitoring Script Required For Oracle 9.2.0.7.0 On Windows 2000 Server

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

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

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

How To Migrate Database From Windows 2003 To 2008 Server

Oct 31, 2012

I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server...So far i have just installed the oracle software on 64bit windows 2008 server.how to move the data or migrate from old server to new server..

View 1 Replies View Related

Windows :: Installing 6i Forms On Server 2008 64bit?

Mar 12, 2012

Can I installed 6i forms on windows server 2008 64bit.

View 2 Replies View Related

Apply Patch 13 To 11.2.0.3 Database For Windows Server 2008 R2?

Nov 27, 2012

I want to apply patch 13 to 11.2.0.3 database for windows server 2008 R2. I saw the pre requisites and found that opatch should be 11.2.0.1.9 or later. My optach is 11.2.0.1.7. I downloaded the patch # 11846294 and unzipped under the opatch directory. In one of the step it asked me to run the following command

$ORACLE_HOME/OPatch/oplan/oplan generateApplySteps <bundle patch location>

but then it says oplan is not recognized. I have set the Oracle_home and path variable

my path is C:Oraclegrid_homein;C:Oracledbhome_1in;C:Oraclegridin;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;C:Program FilesArcGISArcSDEora11gexein;C:Program FilesXIVhost_attachin;C:Oracledbhome_1oplan

Note that my database version is 11.2.0.3 with ASM

View 7 Replies View Related

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

Forms :: (32Bit) Version 10.1.2.0.2 Crashed With Windows Server 2008 64bit

Dec 19, 2011

i need to upgrade this version to 10.1.2.3, and i don't have an account in metalink to download the patch.

View 11 Replies View Related

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

Server Administration :: Oracle 11g Installation Error

Apr 22, 2010

I am trying to install oracle 11g on windows 2003 ent with sp2 , where I am getting an error, The java runtime environment was not found at bin/javaw.exe. hence the oracle universal installer cannot be run.

View 4 Replies View Related

Server Administration :: Silent Installation Of Oracle 10g R2

Nov 4, 2010

I want to install Oracle software 10g R2 at linux platform. I want to install it at Silent mode, but not able to find the .rsp(response) file. I have created the .rsp(response file) from oui , hut not able to configure the same.

View 1 Replies View Related







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