Kenneth: /* Oracle Client */

2015-05-06T02:20:25Z

Oracle Client

New page

== Oracle 11gR2 Windows Server Install ==

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

== Server Installation ==

<pre>
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.
</pre>

<pre>
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.
</pre>

<pre>
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.
</pre>

== 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:

<pre>
Oracle Client Installer

Error while creating service. The service OracleMTSRecoveryService already exists.
</pre>

Does not appear to affect anything.

== tnsnames.org ==

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

== Issues ==

=== Enterprise manager configuration failed ===

At end of installation:
<pre>
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.
</pre>

Cause:
* ? - maybe slow VM

Solution:
* Recloned W2K8r2 VM, re-decompressed DB zip files and reinstalled DB.

Possible References:
* Troubleshooting Enterprise Manager - http://www.stanford.edu/dept/itss/docs/oracle/10gR2/em.102/b40103/app_troubleshooting.htm

== keywords ==

[[Category:Oracle]]
[[Category:Database]]

Oracle/Database/Oracle 11gR2 Windows Server Install - Revision history

Kenneth: /* Oracle Client */