Friday, October 11, 2013

[WLS] Quick Silent-mode Installation Guide

Situation
You need to install Oracle WebLogic 10.3.6 but you don't have GUI access.

Solution
Do a silent install.

Instructions
1. Create a silent.xml with a similar content:
<?xml version="1.0" encoding="UTF-8"?>
   <bea-installer> 
     <input-fields>
       <data-value name="BEAHOME" value="/u01/app/oracle/Middleware" />
       <data-value name="WLS_INSTALL_DIR" value="/u01/app/oracle/Middleware/wlserver_10.3" />
       <data-value name="COMPONENT_PATHS"
        value="WebLogic Server/Core Application Server|WebLogic Server
/Administration Console|WebLogic Server/Configuration Wizard and Upgrade 
Framework|WebLogic Server/Web 2.0 HTTP Pub-Sub Server|WebLogic Server/WebLogic 
JDBC Drivers|WebLogic Server/Third Party JDBC Drivers|WebLogic Server
/WebLogic Server Clients|WebLogic Server/WebLogic Web Server Plugins
|WebLogic Server/UDDI and Xquery Support|WebLogic Server/Server Examples|Oracle Coherence/Coherence Product Files" />
       <data-value name="INSTALL_NODE_MANAGER_SERVICE" value="yes" />
       <data-value name="NODEMGR_PORT" value="5556" />
       <data-value name="INSTALL_SHORTCUT_IN_ALL_USERS_FOLDER" value="yes"/>
   </input-fields> 
</bea-installer>
2. Execute the following command:
java -jar wls1036_generic.jar -mode=silent -silent_xml=./silent.xml
3. Wait until it finish and verify the MW_HOME.

Extra
If you want to upgrade instead of install then the silent.xml has to be like this:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<domain-template-descriptor>
<input-fields>
<data-value name="BEAHOME" value="/u01/app/oracle/Middleware" />
</input-fields>
</domain-template-descriptor>

Reference
Oracle® Fusion Middleware Installation Guide for Oracle WebLogic Server 11g Release 1 (10.3.6). Running the Installation Program in Silent Mode.

Wednesday, October 2, 2013

[RAC 11g R2] How to add DNS server and change domain name on HP-UX Itanium

It's been a while... 

So..... recently, I was installing a Oracle RAC 11gR2, for this version you need to configure on the DNS Server  3 IP Addresses for the SCAN (Single Client Access Name). You will need to configure the DNS address and the domain name on you server, and that's the mission of this post.

First you will need to log in with root user, then...

1. From the prompt execute the next command:

# sam

Once you execute the command above, you will see a menu like the following, 
Select n (Networking and Communications)






Thursday, June 6, 2013

[OEM12c] Change SYSMAN password

It's time to change SYSMAN password! First of all you need to know that this will require downtime from the Oracle Management Server (OMS). Secondly that is required to do it from the terminal. But relax, it is an easy process.

These are the steps you need to follow:

Thursday, May 23, 2013

[Cloud Control 12c] Discovery EBS R12 fails with java.lang.NullPointerException

Trying to discover an EBS System with Cloud Control, discovery ends on error:

java.lang.NullPointerException
oracle.apps.fnd.oam.em.util.job.CommandException
Caused By: oracle.apps.fnd.oam.em.sdk.targetData.discovery.AppsDiscoveryException: Error while attempting to discover EBS on : 0000( oracle_database ) using schema: em_monitor
Caused By: java.lang.NullPointerException

This error appears in the Discovery Job Run page. (Enterprise > Job Activiy > Job Run DISCOVERY <instance> [Date])

At first look, it seems like is a missing plug-in, so, according to "Troubleshooting Oracle E-Business Plug-in 12.1.0.1 [ID 1537431.1]", Step 2, yo need to check if you have all the necessary plug-in installed on the agent, that EBS System requires to work.

Friday, March 15, 2013

[RDBMS] List All Schemas

This post will provide information about Oracle schemas. First, its definition and then the correct SQL query to list the availables schemas.

Definition
An Oracle schema is a set of all objects owned by a user. Consequently, an schema is equivalent to a user account.

How-to
If you are interested in listing all schemas connect to the instance using a user with SYSDBA privileges. Then query the following SQL:

[RDBMS] How To Change Oracle Installation Owner

Applies to:
          Oracle Database 10g
          Oracle Database 11g
          Oracle Enterprise Manager 11gR1 and Cloud Control 12c

OS: Linux x86, Linux x86_64, Solaris (Tested). (It should work on all UNIX based systems)

Note: Before to proceed you need to stop all the services running on the Oracle Home (databases, listeners, oms, agent)

1. If you don't have the user that will be the new owner of the ORACLE_HOME created, create one. I'll use oraoem.

2. With all the services stopped, change the ORACLE_HOME's owner:

         chown -R oraoem $ORACLE_HOME/

Saturday, March 9, 2013

[RDBMS] Enabling and Disabling Database Vault in RAC 11g R2


1. You need to stop all the databases and listeners (if there is more than one) running on the Database Oracle Home. With the next commands you can stop this proccesses:

srvctl stop listener
srvctl stop database -d mydb

2. Enable Database Vault in the Oracle Home (remember that we are using 11g R2 and Database Vault is bundle with the installation, you don't have to install it like older versions)

chopt [ enable | disable] db_option

Values for db_option are described in the following table:

dm                    Oracle Data Mining RDBMS Files
dv                    Oracle Database Vault
lbac                  Oracle Label Security
olap                  Oracle OLAP
partitioning          Oracle Partitioning
rat                   Oracle Real Application Testing
ode_net               Oracle Database Extensions for .NET 1.x
ode_net_2             Oracle Database Extensions for .NET 2.0

You will need to run the following commands in every RAC node:

chopt enable lbac
chopt enable dv

Thursday, March 7, 2013

[E-Business Suite] Error running txkrun.pl deploying a New Forms EAR File


Scenario:

You have a Shared Applications Filesystem  configuration in your E-Business Suite environment like the following:

To have this configuration you need to have your CONTEXT_FILE configured to work that way, how? (well that's will be a topic of other post, but I'll give you a brief).


Tuesday, March 5, 2013

[RDBMS] Transparent Data Encryption 11g R2


This is a procedure to configure Transparent Data Encryption (Basic) on a RAC 11gR2 environment.

First you need to add to the $ORACLE_HOME/netowrk/admin/sqlnet.ora the following lines, or alter them if they already exists, in every RAC node:



ENCRYPTION_WALLET_LOCATION=  
  (SOURCE=(METHOD=FILE)(METHOD_DATA=    
   (DIRECTORY=/u01/oracle/product/11.2.0/dbs/encryption_wallet)))

There is a default path,($ORACLE_HOME/admin/$ORACLE_SID/wallet)but you can change it to the one you want your wallet to be.