Oracle/Database/Oracle 11gR2 Windows Server Install

From Omnia
Jump to navigation Jump to search

Oracle 11gR2 Windows Server Install

http://www.oracle.com/technetwork/database/enterprise-edition/overview/index.html

Server Installation

Enterprise Manager Database Control URL - (orcl) :
https://oracledb:1158/em

Your database configuration files have been installed in C:\app\Administrator while other components
selected for installation have been installed in C:\app\Administrator\product\11.2.0\dbhome.  Be
cautious not to accidentally delete these configuration files.



Database Configuration Assistant

Database creation complete.  For details check the logfiles at:
  C:\app\Administrator\cfgtoollogs\dbca\orcl.

Database Information:
  Global Database Name:        orcl
  System Identifier(SID):      orcl
  Server Parameter File name:  C:\app\Administrator\product\11.2.0\dbhome\database\spfileorcl.ora

The Database Control URL is https://oracledb:1158:em

Management Repository has been placed in secure mode wherein Enterprise Manager data will be
encrypted.  The encryption key has been placed in the file: C:/app/Administrator/product/11.2.0
/dbhome/oracledb_orcl/sysman/config/emkey.ra.  Please ensure this file is backed up as the
encrypted data will become unusable if this file is lost.



Note: All database accounts except SYS, SYSTEM, DBSNMP, and SYSMAN are locked.  Select the
Password Management button to view the complete list of locked accounts or to manage the
database accounts (except DBSNMP and SYSMAN).  From the Password Management window,
unlock only the accounts you will use.  Oracle Corporation strongly recommends changing the
default passwords immediately after unlocking the account.

Oracle Client

NOTE: Based on the LindonLabs:Planview project requirements.

The Oracle client should be installed with the following options enabled:

  • SQL*Plus
  • Oracle Net
  • Oracle ODBC Driver
  • Oracle Services for Microsoft Transaction Server
  • Oracle Data Provider for .NET
  • Oracle Providers for ASP.NET

32bit and 64bit client

Installed 32bit client first. Installed 64bit client second. Ran into this error: 

Oracle Client Installer

Error while creating service.  The service OracleMTSRecoveryService already exists.

Does not appear to affect anything.

tnsnames.org

ken32 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracledb)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

Issues

Enterprise manager configuration failed

At end of installation: 

Database Configuration Assistant : Warning

Enterprise manager configuration failed due to the following error -
Listener is not up or database service is not registered with it.  Start the
Listener and register database service and run EM Configuration
Assistant again.
Refer to the log file at C:
\app\Administrator\cfgtoollogs\dbca\orcl\emConfig.log for more details.
You can retry configuring this database with Enterprise Manager later by
manually running c:\app\Administrator\product\11.2.0
\dbhome_1\bin\emca script.

Cause:

  • ? - maybe slow VM

Solution:

  • Recloned W2K8r2 VM, re-decompressed DB zip files and reinstalled DB.

Possible References:

keywords

Retrieved from "https://aznot.com/index.php?title=Oracle/Database/Oracle_11gR2_Windows_Server_Install&oldid=2131"