Quick tips on Cloning Oracle

Quick tips on Cloning Oracle

Cloning is not cross platform
Clone usually is done in 2 phases - prepare_clone.pl in source and clone.pl in target
Clone does take care of inventory and relink so further patches can be applied on the new cloned home
For Oracle database and CRS, prepare_clone.pl is not required
ORACLE_HOME and ORACLE_HOME_NAME should be specified when clone.pl is run, in 11g, ORACLE_BASE should be specified also
If Oracle inventory is not in default location, before running clone.pl, edit cs.properties and add 

-ignoreSysPrereqs -invPtrLoc <oraInst_path>/oraInst.loc

Make sure to run root.sh after clone.pl is completed

You may need to create oraInst.loc file manually on target if the file does not exists, to do so, just create a file in default location 
   with inventory_loc=<oraInventory_path>

The alternative of running clone.pl is to use runInstaller for cloning, the format would be like this : 

./runInstaller -clone -silent -ignorePreReq ORACLE_HOME="" ORACLE_HOME_NAME="" ORACLE_BASE="" 

(in Windows it would be setup.exe)

If the server has more than one perl installed, it is recommended to set PERL5LIB 

If clone is done on target server which has inventory and the cloned ORACLE_HOME has already been used at somepoint,

first ORACLE_HOME needs to be de-attached using this command : ./runInstaller -detachHome ORACLE_HOME=

This is why it is recommended to clone in brand new directory to avoid any issue.

Clone log in target is created in $ORACLE_HOME/clone/logs

Read More

Virtualization on Oracle Database Appliance (ODA)

Virtualization on Oracle Database Appliance (ODA)

 As you know, Early this year Oracle started supporting virtualization on Oracle Database Appliance which enhances the functionality of ODA. One of the main usage of this virtualization is to utilize ODA for Weblogic as well as database.

I had a chance to test various Weblogic offerings on ODA and I thought to share my findings with readers, hopefully it helps readers with planning and architecting the environment using ODA and virtualization. Basically, the two main versions which can be run on ODA V1 and ODA X3-2 and support virtualization are ODA Version 2.5 and ODA version 2.6. The following shows my findings on Weblogic install for each version:

ODA 2.5

• Oracle Weblogic template on ODA is available on e-delivery for Weblogic 10.3.6 and 12c
• Oracle Weblogic template includes Weblogic configurator which is a new tool (specific to ODA) to automate installation of Weblogic on ODA similar to what OAM does for database.
• Weblogic configurator only installs Weblogic in cluster mode, having non-cluster weblogic is not supported with the configurator.
• Weblogic configurator installs OTD (Oracle Traffic Director) and as of now, there is no way to skip it during installation. However after installation, it can be shutdown if it is not needed.
• Minimum installation with Weblogic configurator includes two Weblogic cluster nodes which installs 6VMs in total (1 VM for Weblogic admin,2 VMs (one per compute node) for Weblogic managed server, 1 VM for OTD admin, 2 VMs (one per compute node) for OTD)
• Weblogic configurator also creates a database for internal work on ODA_BASE.
• Weblogic configurator installs all components as root due to a bug.
• Since 6VMs are the possible minimum configuration and each VM should have at least 2VCPU, there will be total of 12VCPU (6Cores) for minimum installation 

ODA 2.6

• No Weblogic template on ODA is released for 2.6
• No Weblogic configurator for automation of Weblogic is released
• As of now, creation readhat Linux and installing Weblogic manually would be the only approach in this release

Bottom line: 

Although it is recommended to utilize automation on ODA to ensure ODA stays with Oracle standard template and to have less impact on future changes such as patching and upgrade, however Oracle Weblogic configurator looks not to be mature enough to be utilized. First of all, to use it, you end up to stay with 2.5 (not with the latest ODA release ) plus the configurator in 2.5 is buggy (installation of weblogic as root) and it has several shortcomings which are listed above as well as not much flexible. I recommend to wait (if you can) as Weblogic configurator should be out soon or use manual process for Weblogic with the risk that in long run, you may not be able to utilize patch bundle (if Oracle includes weblogic in ODA bundle) or any further automation which may be planned for Weblogic. Also consider that installation of OTD does add complexity to weblogic licensing on ODA.

At the end, I found FAQ pdf file on otn website helpful.

http://www.oracle.com/technetwork/middleware/weblogic-oda/overview/faq-weblogicserver-on-oda-1927929.pdf

 If you have any questions or you want to see more on this topic, please drop me a line.

Read More

Become Golden DBA for GoldenGate environment (Basic)

 Become Golden DBA for GoldenGate environment (Basic)

Become Golden DBA for GoldenGate environment is delivered in OOW2013 and more topics around this will come which include but not limited to the following :

• Golden DBA for 2 way GoldenGate replication
• Golden DBA and troubleshooting GoldenGate
• Golden DBA and advanced configuration on GoldenGate
• Golden DBA and Tuning GoldenGate

For those of you who joined the session or would like to follow up, pdf version of the session is available on https://github.com/shervsh/Presentation/ and it will be available on OOW. 

Please drop me a line if you are interested in upcoming sessions or you would like to have ppt version.

Thanks everyone for joining the session, I will post answers to various questions in upcoming posts.

Read More

GoldenGate DDL replication

GoldenGate DDL replication

I have to setup a DDL replication for a customer and as usual I use include to filter schema which I want to be replicated as below :'

DDL &
INCLUDE ALL OBJNAME "SCHEMA1.*" &
INCLUDE ALL OBJNAME "SCHEMA2.*" &
EXCLUDE OBJTYPE SEQUENCE

 

Interesting enough, I see that GoldenGate does not capture DDL although the filter should work fine. The following is reported in GoldenGate log with my surprise :

 

Oracle GoldenGate Capture for Oracle, ext_test.prm:  DDL operation excluded [not included by any filter]
, optype [CREATE], objtype [TABLE], objowner [SCHEMA1], objname [TAB]

 

 

The same situation does occur using different DDL options such as MAPPED. Further investigation revealed that it is a bug which is reported in Doc ID 1475618.1 and the workaround is not to use " for schema, in other words, the following works with no issue :
 

 

 DDL &
INCLUDE ALL OBJNAME SCHEMA1.* &
INCLUDE ALL OBJNAME SCHEMA2.* &
EXCLUDE OBJTYPE SEQUENCE

 

 

So no " for DDL options when you setup DDL for GoldenGate. Hope this simple tips helps.



Read More

ODA and CPU license

ODA and CPU license

Last week, I was working on a customer with ODA x4-2 which we found 5 CPU licenses are sold for EE deployment. My first reaction was on how to put 5 CPU license (10 cores) in ODA x4-2. As you may know, the multiplier of 4 cores can be activated in X3-2 and above and multiplier of 2 in ODA v1. In this post, I am trying to explain what is the minimum core requirement for various ODA server with virtualized and non-virtualized deployment.

We all know that "pay as grow" is one of the great feature of Oracle Database Appliance. In other words, you could start with as minimum core as possible and then scale up.
However, due to CPU specification on various ODA version, there is some limitation in regards to minimum number of cores which could be setup as it is shown in below :

Min license
	V1	X3-2,3,4
EE	2x0.5=1	4x0.5=2	10 day rule
RACOne	2x0.5=1	4x0.5=2	10 day rule
RAC	2x2x0.5=2	2x4x0.5=4
EE -VM	2x0.5=1	2x0.5=1	10 day rule
RACOne-VM	2x0.5=1	2x0.5=1	10 day rule
RAC - VM	2x2x0.5=2	2x2x0.5=2

---

Couple notes :

• 10 day rule is to have all instances in EE or RAC1 only on one ODA node and without paying license to be allowed to flip over to the second node in case the first node is not available only for 10 days per calendar year.
• Since ODA platform is x86, the contributing factor is 0.5. This is where you can see all multiplier of 0.5 in the table.
• On ODA x3-2 and above odd number of CPU can not be setup unless ODA is setup as virtualized platform.
• Virtualization provides more flexibility in terms of lowering the number of the required CPU specially for EE or RAC1. If you are dealing with small customer, you may end up to go virtualized even ODA is purposed only for database deployment.

Hope this post clarifies some confusion.

Read More

Quick tips on Weblogic

Quick tips on Weblogic

Very often I login to a customer site and I end up to search in document for couple things :

• How to setup NodeManager so the customer could use Admin console for Weblogic startup
• How to make username/password encrypted so the command line does not ask for username/password at time of startup
• Quick and easy guideline for patching
• How to check Weblogic version

Above items are nothing new but I thought to post details here for my quick access.This post is a quick reminder for myself which is copied from Oracle document.

To enable startup scripts and start Node Manager:

1.   Navigate to the following directory

2. MW_HOME/oracle_common/common/bin

MW_HOME is the directory where Oracle Fusion Middleware is installed.

3.   Run the setNMProps.sh script to set the StartScriptEnabled property to true before starting Node Manager:

4. ./setNMProps.sh

This is a one-time action. After you run this script, you can skip this step before starting Node Manager again.

5.   Start Node Manager with the startNodeManager script.

UNIX script: WL_HOME/server/bin/startNodeManager.sh

Windows script: WL_HOME\server\bin\startNodeManager.cmd

To avoid username/password at startup:

To avoid prompts for a user name and password on startup after you start a Managed Server the first time, you can create a boot.properties file in the domain-home/servers/server-name/security/ directory. This file would include the following lines:
username=USERNAME

password=PASSWORD

The boot.properties file will be encrypted the first time that the Managed Server is started.

Patching mechanism on Weblogic :

Basically bsu is the tool to apply the patches on Weblogic install. The following shows an example on how patch is applied and how it is verified.

To apply
copy patch to $MW_HOME/utils/bsu/cache_dir
unzip patch
remove patch zip file (rm p1......zip)
./bsu.sh -install -patch_download_dir=$MW_HOME/utils/bsu/cache_dir -patchlist=FCX7 -prod_dir=$WL_HOME
To verify
./bsu.sh -view -status=applied -prod_dir=$WL_HOME

Checking Weblogic version:

cd $DOMAIN_HOME/bin
[oracle@oracle2qa bin]$ . ./setDomainEnv.sh
[oracle@oracle2qa APEXDomain]$ java weblogic.version

Read More

Documents for Oracle licensing

Documents for Oracle licensing

If you negotiate with Oracle on licensing or design/architect a solution for a customer, the following documents may come handy : 

• Oracle process core factor : http://www.oracle.com/us/corporate/contracts/processor-core-factor-table-070634.pdf
• Oracle software technical support policies : http://www.oracle.com/us/support/library/057419.pdf
• Oracle partition policy : http://www.oracle.com/us/corporate/pricing/partitioning-070609.pdf
• Licensing Data Recovery environment : http://www.oracle.com/us/corporate/contracts/data-recovery-licensing-070587.pdf
• Software investment guide : http://www.oracle.com/us/corporate/pricing/software-investment-guide/index.html
• Oracle support/certification on Vmware :http://www.vmware.com/files/pdf/solutions/oracle/Understanding_Oracle_Certification_Support_Licensing_VMware_environments.pdf
• Oracle VM and hard partitioning : http://www.oracle.com/technetwork/server-storage/vm/ovm-hardpart-168217.pdf

Read More

Oracle Database Appliance - 3 Observations and 3 Resolutions

Oracle Database Appliance - 3 Observations and 3 Resolutions

During last couple weeks, I have been involved in various ODA activities from patching of an existing ODA to latest version to setting up new environments on ODA X5-2
I thought to share some lesson learnt :
 
1)  Patch failure
 
If you encounter in a situation which ODA patch fails and reports the following error 
Unable to get the nodenumber in the chassis
The resolution is to create /opt/oracle/oak/conf/node_num.conf on each compute node and add NODENUM=0 or NODENUM=1.

2) Network issue
 
If you setup new ODA and in the first boot, it should ask for fiber or copper connection and after providing the right option, ODA will keep the appropriate driver and will remove unnecessary drivers. If you do not see it in any new ODA x3-2 onwards when it is booted for the first time, you may see issue with setting up network later. 
To fix the issue, before further progress with deployment and setting up environment, run /opt/oracle/oak/lib/SetupX4Network.pl 

3)  Some oakcli commands fail
You may notice that some oakcli commands fail with the following error:


OAKERR:6000 Exception encountered in Module getMasterNode
OAKERR:6002 No master node was found 

This cause usually could be that the process cannot connect to oakd daemon on ODA. 
You could confirm this with running
oakcli show ismaster
If this command fails, it could be fixed by bouncing oakd using oakcli. As long as oakcli show ismaster does not work well, you may experience failure of some oakcli commands.

 


During last couple weeks, I have been involved in various ODA activities from patching of an existing ODA to latest version to setting up new environments on ODA X5-2
I thought to share some lesson learnt :
 
1)  Patch failure
 
If you encounter in a situation which ODA patch fails and reports the following error 
Unable to get the nodenumber in the chassis
The resolution is to create /opt/oracle/oak/conf/node_num.conf on each compute node and add NODENUM=0 or NODENUM=1.

2) Network issue
 
If you setup new ODA and in the first boot, it should ask for fiber or copper connection and after providing the right option, ODA will keep the appropriate driver and will remove unnecessary drivers. If you do not see it in any new ODA x3-2 onwards when it is booted for the first time, you may see issue with setting up network later. 
To fix the issue, before further progress with deployment and setting up environment, run /opt/oracle/oak/lib/SetupX4Network.pl 

3)  Some oakcli commands fail
You may notice that some oakcli commands fail with the following error:


OAKERR:6000 Exception encountered in Module getMasterNode
OAKERR:6002 No master node was found 

This cause usually could be that the process cannot connect to oakd daemon on ODA. 
You could confirm this with running
oakcli show ismaster
If this command fails, it could be fixed by bouncing oakd using oakcli. As long as oakcli show ismaster does not work well, you may experience failure of some oakcli commands.

 

Read More

Access to ODA ILOM is challenging ?

TIP 117#: Access to ODA ILOM is challenging ?

New ODA is configured with ILOM IPs and network cable is plugged to Netmgt port. Everything is ready for connecting to the server via ILOM and bummer!, you may see the whole connection or at least the connection to remote console does not work as it is expected.

The following item could come handy to troubleshoot and fix the issue:

ILOM client requirements:

Per the following link, the client access should meet certain requirement.

http://docs.oracle.com/cd/E24707_01/html/E24528/z40000191582334.html

I found that having right Java and registering it in browser are the key.
For new ODA (X5-2), per 888888.1, consider upgrading Java to 7 to avoid bug 20420055

After you make all necessary changes per above requirement, you may still have some problem connecting to remote console.
The following two issues are reported on several customers which we have :

Issue : ILOM remote console is blocked by rule set 

Solution : The simplest solution is to remove rule set file - The file is C:\Windows\Sun\Java\Deployment\DeploymentRuleSet.jar and it is not dependent on where Java is installed.
If the issue still stays, consider setting Java security level to medium in Java control panel (in windows in Windows control panel)

Issue : ILOM remote console errors out with "Video redirection error - no appropriate protocol found"

Solution: Comment out jdk.tls.disabledAlgorithms=SSLv3 in JAVA_folder/lib/security/java.security and restart the browser
 

Read More

Spyware Terminator Premium 2015 Free Download Full Version

Spyware Terminator 2015 is a an easy-to-use and effective spyware remover providing real-time protection against spyware, adware, keyloggers, trojan horses, browser hijackers and other malware threats. Spyware Terminator protects your computer through powerful real-time protection shield, advanced system scanning and keeping found spyware in the safe quarantine. It scans your entire system using a regularly updated database of known spyware. Due to the constantly changing environment, the spyware database is updated regularly at Crawler Spyware Central to provide you with continuous protection. Spyware scanning is used on a manual basis (on-demand scanning) as well as on a scheduled basis using the spyware scheduler to perform full system scans to locate and remove unwanted spyware threats.
Spyware scans perform in-depth scans of your computer's hard drives, memory, process, and registry to seek out and remove any and all known and unknown spyware threats.
Spyware Terminator monitors your computer for both known and unknown spyware. The known spyware can be detected and identified during the scan, the unknown spyware can be detected but it cannot be identified immediately. After you send it to Crawler Spyware Central for further analysis, it can be identified and correctly removed or moved to Quarantine.
Get free real-time protection that effectively removes spyware, adware, trojans, keyloggers, home page hijackers and other malware threats from your computer. The Premium version includes integrated antivirus, priority updates, additional security tools, integrated Internet protection and product support.

Features:

• System Protect: Get effective file protection that prevents the removal or alteration of critical files and applications, and ensures operating system stability.
• Web Security Guard: Prevent access to websites reported as dangerous and protect your computer from malware infection. Anti-Phishing Protection feature tracks and blocks phishing attempts on your computer and sends logs about the websites you visit.
• Online Vault Website: Download Online Vault right from the website and access your account.
• PCRx, PCRX Optimizer, PC Power Speed and PC Fix Speed Websites: These sites feature a download link for a free PC scan as well as a secure purchase page and help section.
• System Protect Website: Download System Protect right from the website and access a support form, help section and more.
• Spyware Terminator Website: The website features a Spyware Terminator download page, links to the forum and community, and access to software database lists, malware news, support form, help section and more.
• Web Security Guard Website: Web Security Guard can be downloaded right from the website. Look up website reports in our extensive database, access our help section and help promote Web Security Guard.
• Custom Shields: enable experienced users to specify Real-Time Shield behavior in detail.

Spyware Terminator includes:

• Fast spyware scanning
• 100% real-time protection
• HIPS protection
• Antivirus protection

Key Features of Spyware Terminator:

• Free Spyware Removal. 
• Free Automatic Updates. 
• Free Scheduled Scans.
• AntiVirus Integration. 

Language:

• Multilanguage

Download Spyware Terminator:

Read More

DFX Audio Enhancer Full Version Crack Free Download

DFX Audio Enhancer boosts the sound quality of all of your music, videos, Internet radio, games, and other programs. Simply turn on DFX and be immersed in HD quality sound.

Audio plugin for better sound media players and Windows in general. The sound quality is significantly improved by improving the frequency characteristics, and what is this plugin. With DFX Audio Enhancer eliminated two major drawbacks – a cut of high frequencies and the lack of stereo separation and depth, and added surround modes and super bass. With this tool, you will receive the highest quality sound and can hear the music of such purity, as if you were sitting in a concert hall or next to a musician.

Features:

• Immerse yourself inside the music.
• Produce deeper, richer bass.
• Renew lost stereo depth and body.
• Eliminate that “muffled” sound.
• Pump up the volume.
• “See” DFX enhance your sound.
• Hear more pleasant, natural sounds with headphones.
• Modes Optimize sound quality for musics, speech and other audio types.
• Presets Select from many factory-tuned settings or create your own.
• Get the perfect sound for each song you play.

DFX Audio Enhancer 11.400 Download Free:

Read More

Driver Download PRO 3.2 Free Download Full Version With Crack + Activation Key

Driver Downloader is a program that allows you to scan your computer outdated, missing or corrupted drivers. The program will automatically update the necessary drivers by using a database with 200000 device drivers. You can also backup and restore your Windows drivers.

Features:

• Scan Your PC for missing, corrupt or out-of-date Drivers
• Automatically Download Drivers
• One-click backup and restore of all your PC drivers
• Designed for Windows 8, Windows 7, Windows XP & Windows Vista

Download:

Read More

YouTube Video Downloader PRO (YTD) Free Download Full Version

YouTube Downloader allows you to download videos from YouTube, including HD and HQ videos, Facebook, Vevo, and dozens of other video sites and convert them to other video formats. The program is easy to use--just specify the URL for the video you want to download and click the Download button. The program also allows you to convert downloaded videos for iPod, iPhone, PSP, Cell Phone, Windows Media, XVid and MP3, or play video that you have previously downloaded or converted.

Features Of YTD:

• Download High Definition Video. YTD YouTube downloader allows you to easily download HD Youtube videos (1080p) along with many other sites. Downloading HD video is made easy with YTD.
• Fast and Easy to Use. Downloading video shouldnâ?™t be complicated. Our interface is super easy to use. Just paste a URL into the interface and click download. Youtube Downloader takes care of the rest.
• Convert Most Video Formats. YTD Downloader is more than a Youtube Downloader. It allows you to convert multiple video formats including HD (1080p). No other simple Youtube Downloaders can do this as quickly or easily – which is why YTD is the best in the business.
• Download Videos and Watch Later. Have a slow connection and cannot stream? Want to watch video later? No problem! Youtube Downloader makes it simple to download videos so you can watch them on your own time.
• Watch Videos on Other Devices. Have multiple devices you watch videos on? YTD Downloader makes it easy for videos to work on multiple devices, whether it is iPhone, iPod, PSP, iTunes, or more.
• Integrated Video Player. YTD Downloader also lets you categorize, sort and build playlists from all your favorite videos. Start watching them now!

Download YouTube Video Download PRO Free:

Read More

Music MP3 Downloader Free Download Full Version

Music MP3 Downloader is very easy to use software which enables you search and download over 100 million MP3 in the largest music network.

Features:

• Over 100 million MP3 from the largest network
• You can search and download any music you want - over 100 million MP3 from the largest download network.
• 100% clean and safe download
• Music MP3 Downloader is not a Peer-to-Peer program. You don't have to worry about downloading virus. It is clean of any form of badware (viruses, spyware, adware, etc.)
• Always bring you the hottest songs
• Music MP3 Downloader always brings you the hottest songs in the world. We recommend you the US Airplay Top 100 every week and list the hottest songs of every category, from electrical to religious, mainstream to indie, hip-hop to classical.
• Unlimitedly listen to music online
• You can Unlimitedly listen to over 100 million songs online for FREE. You can try the searched results to decide which one to download.
• Advanced search
• Music MP3 Downloader can search songs by title, artist, album, and edition. You can even search the live, piano, guitar or cover edition of your favorite songs.
• Compatible with iPod and all the other portable devices
• Music MP3 Downloader is compatible with any portable device: iPod, iPhone, PSP, PDA, cell phone etc.

Download Music MP3 Downloader:

Read More

Wise Folder Hider PRO Free Download Full Version

Wise Folder Hider is a great tool to hide your pictures, movies, files or folder or any other data. It protects your private and important data from other's eyes. This application is designed as a free USB drive/ file/ folder hiding tool. User can use it to hide sensitive or important files and folders on local partitions or removable devices. The data can't be accessed by other programs or other operating systems such as DOS. The only way to access or unhide these data is to enter the valid password. However, Wise Folder Hider is designed for home use only, but not recommended for commercial settings which require stricter confidentiality. Using this application, your private data and important files will not be exposed to others or unintentionally revealed and your privacy will not be pried into if you share one computer, USB drive, removable HDD drive, etc.

Advanced Encryption Algorithm Protects Your Private Data from Priers

Wise Folder Hider Pro adopts advanced encryption algorithm, providing much more enhanced security than the free version for files and folders on your Windows PC. Wise Folder Hider Pro defends your private files from being found/read by a third-party tool.

Second Password Makes Your Hidden Files & Folders Double Secure

Wise Folder Hider Pro offers users an optional higher level of security. Users can set a second password for each of the files and folders hidden by Wise Folder Hider Pro. For those who have some real confidential files, they can rest assured knowing that their hidden files are double secured.

More Secure and Convenient to Modify protected files:

Different from other folder hiders, when it comes to modifying a hidden file or folder, users donâ?™t have to unhide it, edit it, and then hide it again. A single click of the ‘Openâ?™ button will open the hidden file or folder, so it becomes visible to you. Then you can edit or modify it like it has been unhidden. When you are done editing, close the program and the file or folder will become hidden again automatically, saving you extra steps. This amazing feature comes in handy when you hide some files that you use or edit frequently.

Context Menu Option & Super User-friendly Interface

The interface of Wise Folder Hider Pro is very intuitive. Even a first timer can get the hang of it in a minute.

Screen Shots:

Download:

Read More