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

Unable to Ping ESXI 5.5 Host

while i am continue working on my  Lab and configure ESXI i faced another problem and took 2 days to solve it maybe someone faced this issue but this will help other people as well.

The problem description like this :- after assigned IP to the server i want like normal people connect to this server using my laptop but simply when trying to ping :-

“Detestation unreachable” 

I thought at first it was my network card issue and maybe it’s not supported By ESXI, But this is not valid option because the weirdest part in this issue was when restart the server and ESXI loading the services i was able to ping without any problem then the message appeared again.

as you see from the above screenshoot ping then not ping !!!!!
The solution very simple i start missing with BIOS options and found new option there called “Network Stack” all you have to do is enable this option and link to IPV4.
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

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

NQSError 46036 Oracle BI Administration Tools Client

when trying to open oracle bi administration tool client, You can download oracle bi administration tool client from here.

Cause :-

Most probably this error related to version mismatch between OBIEE Server and Administration Tool Client in my case OBIEE Version 11.1.1.7.1 and Administration Tool client 11.1.1.7.0

Solution :-

1- Download Upgrade Patch 17530796 From http://support.oracle.com depend on operating system
2- Patch contain multiple file search for this one :- p17463403_111170_Generic.zip
3- inside this zip file browse

17463403\files\clients\biserver\

4- you will find two files biee_client_install_x64.exe Or biee_client_install.exe depend on version.
5- Install One of this file to upgrade Administration tools, Use Repair Option.

Thank you
Osama Mustafa

No Backup !!! Think Again

While I was drinking my coffee yesterday in the office, A Customer Called me complaining that Non Production Database Is not working and Database Administrator quit his job without any Handover the situation was so creepy, This database hold Fusion middleware Repository and configuration, The development team use it before deploy anything on Production Database ( No Backup configured !!!! ),  

Trying to Recover Database and Open it with Resetlogs will lead to this error :-

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: ‘/u01/app/oracle/oradata/NPDB/system01.dbf’

This Error is only apart of the problem, To solve it :-

Recover database using file name (Redolog) to get the current filename :-

SQL > Startup mount ;

 SQL > select member from v$logfile lf , v$log l where l.status=’CURRENT’ and lf.group#=l.group#;

 MEMBER
——————————————-
/u01/app/oracle/oradata/NPDB/redo03.log

SQL > Recover database using backup controlfile until cancel ; 

 Specify log: {=suggested | filename | AUTO | CANCEL}

 /u01/app/oracle/oradata/NPDB/redo03.log ( From the Above Query ).

Log applied.
Media recovery complete.

 Trying to open database :-

SQL > Alter database open Resetlogs ;

Failed !!!! with Another Datafile which is UNDO.

 ORA-01110: data file 4:’/u01/app/oracle/oradata/NPDB/UNDOTBS01.DBF’

SQL  > Create Pfile from Spfile ;

Modify the pfile and add the hidden parameter :-

_allow_resetlogs_corruption=True  

But this Not Solved the problem either.

Again Edit Pfile But this Time :-

undo_management=manual
undo_tablespace=UNDOTBS1 

SQL> select name from v$datafile; 

NAME
——————————————–
/u01/app/oracle/oradata/NPDB/SYSTEM01.DBF
/u01/app/oracle/oradata/NPDB/UNDOTBS01.DBF
/u01/app/oracle/oradata/NPDB/SYSAUX01.DBF
/u01/app/oracle/oradata/NPDB/USERS01.DBF
……………………

SQL > alter database datafile ‘/u01/app/oracle/oradata/NPDB/UNDOTBS01.DBF’ offline drop;

ERROR at line 1:
ORA-01548: active rollback segment ‘_SYSSMU11$’ found, terminate dropping tablespace

Check Segment that Needs Recovery :-

SQL>select segment_name,status,tablespace_name from dba_rollback_segs where status=’NEEDS RECOVERY’; 

SEGMENT_NAME STATUS TABLESPACE_NAME
—————————— —————- —————–
_SYSSMU11$ NEEDS RECOVERY UNDOTBS1
_SYSSMU12$ NEEDS RECOVERY UNDOTBS1
_SYSSMU13$ NEEDS RECOVERY UNDOTBS1 

Add the following line to pfile:

_corrupted_rollback_segments = (‘_SYSSMU11$’,’_SYSSMU12$’,’_SYSSMU13$’);

SQL > Startup mount pfile=’/u01/osama.ini’;
SQL > drop rollback segment “_SYSSMU11$” –> Drop all the above Segments ;

Drop the Undo And Recreate it again.

SQL > Startup ;

SQL> create undo tablespace UNDOTBS2 

datafile ‘/u01/app/oracle/oradata/NPDB/UNDOTBS02.DBF’ size 1G;

Remove All Hidden Parameter and restore UNDO_Managment Parameter to AUTO and UNDO_TABLESPACE=UNDOTBS2 then :-

SQL> create spfile from pfile; 

first Advice  Enable RMAN Please

 Thank you
Osama Mustafa

Reference :-
1- Doc ID 94114.1
2- Doc ID 1295294.1
3- Doc ID 28226.1