Configure DBConsole as Active/passive

Sometimes Database Configured as Active/Passive ( Cluster ) Which mean one node working/time and regarding to this if the failover happened on 2nd node the customer will expected that everything will be the same as it was on node 1 include to this Dbconsole.

To do this follow the below steps :-

  • Database should be configured on VIP.
  • Listener should be configured on VIP.
  • Database , Configuration should be installed on Shared Storage
  • inventory Files should be on shared storage as well.
  • ORACLE_HOSTNAME Should be set to VIP Hostname.
Listener example :-

LISTENER  =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VIP-HOST )(PORT = 1521))
)

Don’t forget to set the LOCAL_LISTENER Parameter :-

SQL> alter system set local_listener=’LISTENER’;

Or

SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = VIP-HOST )(PORT = 1521)) ‘;

Now

export ORACLE_HOSTNAME=VIP-HOSTNAME
emca -config dbcontrol db -repos create

Test the failover on node #2

if for some reason when you try to start emctl and the error still asking for oc4j then export ORACLE_HOSTNAME is bash_profile.

It should work

Cheers
Osama 

Dealing with Crontab

Schedule tasks under Linux is an powerful procedure which is used by almost everyone, and to do this using program called cron. more about it here .

Procedure :

make a new text file, and enter this line in that text file like the below :-

crontab myfirstjob

Formatting crontab file :-

what this file contains

Number
Meaning
Allowed range
1
Minutes
0-59
2
Hours
0-23
3
Days
1-31
4
Months
1-12 OR First 3 letters of the Month name
5
Days of the week
0-7 OR First 3 letters of the Day name
6
Name of the program
Any program

Some useful command can be used with cron :-

Show all the task running under cron.

crontab -l

edit the crontab

crontab -e

Some example from crontab file :-

# Minute   Hour      Day of Month       Month                 Day of Week        Command  
# (0-59)     (0-23)     (1-31)             (1-12 or Jan-Dec)    (0-6 or Sun-Sat)              
    0               12           *                             *                         *            /u01/backup.sh

For more example about crontab press here

Cheers
Osama Mustafa

Configure E-mail For Oracle Enterprise manager DB 11gR2

Sometimes you will be not be able to check the database out of the office, sick ….

Regarding to oracle documentation :-

The notification system allows you to notify Enterprise Manager administrators of alerts, policy violations, and the status changes of job executions. In addition to notifying administrators, the notification system can perform actions such as executing operating system commands (including scripts) and PL/SQL procedures when an alert is triggered.

Before Enterprise Manager can send e-mail notifications, you must first specify the Outgoing Mail (SMTP) servers to be used by the notification system. Once set, you can then define e-mail notifications for yourself or, if you have Super Administrator privileges, you can also define notifications for other Enterprise Manager administrators.

For More about E-Mail Notification Read here.

If everything is ready please follow the screen shot :-

Welcome Screen/Login Page

The Main Page, Click On preference on Upper Right :-
Add the E-mail below :-

If you need to schedule any Rule Just add it like the below :-

Cheers
Osama Mustafa

How to add storage to ESXI 5.5

in this post i will show you how to add New Storage to ESXI 5.5 using vsphere client follow the screenshot :-

  1. Login to Vsphere client
  2. Select the host and then choose the Configuration tab –> Storage. like below


  • Storage Type :-

  • Which Storage you want add :-
  • VMFS-3 For our case

  • Storage Name

  • maximum file size and capacity of the database.

  • Press Finish
  • Summary 

Cheers
osama mustafa

Configure NIC/Ethernet On ESXI 5.5

Happy new year and healthy 2015.

During the Holiday I was working on my mini Lab and Upgrading the Server i want to use ESXI 5.5 this time,usually the built-in Ethernet card  Intel or Realtek ( Mine ) while the installation i faced an issue that ESXI 5.5 doesn’t identify my Ethernet card and the installation failed.

To solve this issue the normal ESXI iso will not work, because of this you have to create something called ESXI custom ISO using Software called ESXI customizer.

Download it from here.

You make this software work you need to install the original ESXI ISO.

Download it from here.

and The most important thing which is the driver that you need it for Ethernet Card, the driver usually depend on the PC just like to told you before I am using Realtek and you can download :-

  • net-r8168+r8111e From here.
  • net-r8169 From here.
Now you have all the software,  Original ESXI , Driver and the customizer.
Open the ESXI customizer new GUI screen will be open with three box like the below.
Now RUN Button and Check the output Directory Burn the ISO and This is should solve the issue.
Cheers
Osama Mustafa

Attempt to connect to a data store that has been manually unloaded from R AM

Timesten in-memory Database :-

ttisql DSN_NAME

ttIsql (c) 1996-2005, TimesTen, Inc. All rights reserved.
Type ? or “help” for help, type “exit” to quit ttIsql.
All commands must end with a semicolon character.
connect “DSN=DSN_NAME”;
707: Attempt to connect to a data store that has been manually unloaded from R
AM

The command failed.

This should be easy to resolve. A TimesTen datastore (physical database), which is what a DSN points at, has a property called its ‘ramPolicy’ The default value for this is inUse which means that TimesTen will load the datastore into memory whenever it is being used.

Solution :

ttAdmin -ramload DSN_NAME

Reference :-
1- Oracle OTN Forum here

Cheers

Osama ….

Pool EDNLocalTxDataSource is Suspended, cannot allocate resources to applications..

Connection test failed with the following exception: weblogic.common.resourcepool.ResourceDisabledException: Pool EDNLocalTxDataSource is Suspended, cannot allocate resources to applications..

This Error Appeared on Weblogic Depend on Managed Server, Tuning Connection Pool By Increasing Maximum Capacity parameter in Datasource.

My Case Datasource EDNLOCALTXDatasource as the above error.

Solution :-

Increase depend on your application.
Thank you 
Osama Mustafa


NP_SOAINFRA.WL_LLR_ADMINSERVER Access Failed

 java.sql.SQLException: JDBC LLR, table verify failed for table ‘NP_SOAINFRA.WL_LLR_ADMINSERVER’, row ‘JDBC LLR Domain//Server’ record had unexpected value

The above error appeared when trying to start Adminserver nothing changed on the Domain

Solution :-

  • Goto  domain location –> config folder.
  •  remove this line from the config.xml file, Take backup before you do this.


    wlsbjmsrpDataSource
    AdminServer,osb_server1
    jdbc/wlsbjmsrpDataSource-jdbc.xml
 

Thank you
Osama Mustafa 

the version of the data that you are trying to import is not compatible with current dac version

This Error Appear On DAC Server when trying to Import Data  from the following :

Tools –> DAC Repository Management –> import

This error appears :-

the version of the data that you are trying to import is not compatible with current dac version

After trying to many Solution with no luck , i discover new Solution for this error and it’s simple :-

export from tools ( Empty files ) will generate 3 folder in DAC Folder Leave this folder without any copy or replace.

Now in my case i installed BIAPPS Copy the folder without Replace the old one.

after start copying the windows will ask dont replace these three folders DON’T REPLACE IT.


Start Import successfully.
Now The Import is done,
Thank you 
Osama Mustafa

weblogic.socket.MaxMessageSizeExceededException

I recently encountered below error,Adminserver.log Indicate to :-

weblogic.socket.MaxMessageSizeExceededException: Incoming message of size: ‘10000080’ bytes exceeds the configured maximum of: ‘10000000’ bytes for protocol: ‘t3’.
weblogic.socket.MaxMessageSizeExceededException: Incoming message of size: ‘10000080’ bytes exceeds the configured maximum of: ‘10000000’ bytes for protocol: ‘t3’
        at weblogic.socket.BaseAbstractMuxableSocket.incrementBufferOffset(BaseAbstractMuxableSocket.java:230)
        at weblogic.rjvm.t3.MuxableSocketT3.incrementBufferOffset(MuxableSocketT3.java:351)
        at weblogic.socket.SocketMuxer.readFromSocket(SocketMuxer.java:989)
        at weblogic.socket.SocketMuxer.readReadySocketOnce(SocketMuxer.java:920)
        at weblogic.socket.SocketMuxer.readReadySocket(SocketMuxer.java:897)
        at weblogic.socket.EPollSocketMuxer.dataReceived(EPollSocketMuxer.java:215)
        at weblogic.socket.EPollSocketMuxer.processSockets(EPollSocketMuxer.java:177)
        at weblogic.socket.SocketReaderRequest.run(SocketReaderRequest.java:29)
        at weblogic.socket.SocketReaderRequest.execute(SocketReaderRequest.java:43)
        at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)
        at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)

to fix this error follow the following steps :-

From Environment, Press on Adminserver  :-

Chose the tab like the below picture :-

Add the following parameter in arguments box, Save usually there is no need to restart :- 
Or if you would like change MaxMessageSize Directly from the console follow the below screen :-

Option #2 :- 
From the navigation tree :- 

Click on Module-FMWDFW

After choose the above tab, 3 options will be appear, press on each of them and Uncheck on Enable Watch  :-