How to share an Internet access from Window 10 to VirtualBox Oracle Linux 7.x Server

I am glad to share my experience here.

To share an Internet access from Windows10 to Oracle Linux7.3 which is installed in VirtualBox6.

Below are the steps required to be following in sequence.

1. VirtualBox Machine OL7.3

2. VB Network Configuration

3. After Starting OL7.3

4. Connect Wire from topLeft

5. Ifconfig After Connect Wire

6. Able to browse my website

7. Able to access VB Machine from MobaXterm (In Windows10)

Bridged Networking is used when you want your vm to be a full network citizen, i.e. to be an equal to your host machine on the network; in this mode, a virtual NIC is “bridged” to a physical NIC on your host.

The effect of this is that each VM has access to the physical network in the same way as your host. It can access any service on the network such as external DHCP services, name lookup services, and routing information just as the host does. Logically, the network looks like this:

Bridging to wired LAN

Oracle blog Oracle VM VirtualBox: Networking options and how-to manage them

Thank you for visiting this blog. 🙂

About OTNYathra

OTNYathra is one day event which is organized by AIOUG / Oracle Community ACE / ACE Directors / OUG Evangelists on every year.

This is series of six conferences across six major cities (Chennai,Bangalore,Hyderabad,Pune,Mumbai,Gurgaon)

Mostly there are three parallel classroom sessions are going on so you can decide and seat in your interested session.

This is not a commercial event, They are collecting Rs. 500 as registration fee to cover the Lunch/Tee/Coffee/Snacks and other logistics to host the event.

I’m regularly attend this event since 2014.

As per my opinion this is the best technical one day event that i recommended to attend to all the DBA and Developers.

AIOUG also started local chapter in all above region.

I hope that AIOUG Gujarat Chapter will start officially very soon.

You can check latest information on my OTN Blog
https://community.oracle.com/blogs/hiteshgondalia/2017/05/16/aioug-gujarat-chapter

Website: http://otnyathra.in

You can check session information using this link(http://otnyathra.in/{name of city}/)
http://otnyathra.in/mumbai

Link to register in event
http://otnyathra.in/register

Oracle12c DB Service failover Behavior change

-bash-4.1$ srvctl stop instance -h

Stops the database instance.

Usage: srvctl stop instance -db {-node | -instance } [-stopoption ] [-force] [-failover]
-db Unique name for the database
-node Node name
-instance “” Comma separated instance names
-stopoption Options to instance shutdown command (e.g. NORMAL, “TRANSACTIONAL LOCAL”, IMMEDIATE, or ABORT)
-force Forcibly stop the instance and any running services.
-failover Allow the running services to fail over to another instance
-help Print usage
-bash-4.1$
-bash-4.1$
-bash-4.1$ srvctl stop instance -d blrdb -s ndb1 -f
PRKO-2002 : Invalid command line option: -s
-bash-4.1$
-bash-4.1$ srvctl stop instance -d blrdb -i ndb1 -f
Invalid instance name(s): ndb1
-bash-4.1$
-bash-4.1$ srvctl stop instance -d blrdb -i blrdb1 -f
-bash-4.1$ srvctl start instance -d blrdb -i blrdb1
-bash-4.1$
-bash-4.1$
-bash-4.1$ srvctl stop instance -d blrdb -i blrdb1 -failover
-bash-4.1$
-bash-4.1$ srvctl start instance -d blrdb -i blrdb1

tfactl – Diagnostic data Collection for troubleshooting the issue of GI, ASM, and RAC

Diagnostic data is needed for troubleshooting the issue.

Execute the action plan described in [ DOC ID 2041228.1 ] “SRDC – Data Collection for Grid Infrastructure, Storage Management, and RAC” and upload the information collected to ensure rapid resolution.

Use the following command to run TFA:
$GI_HOME/tfa/bin/tfactl diagcollect -from “MMM/dd/yyyy hh:mm:ss” -to “MMM/dd/yyyy hh:mm:ss”

Date and time format example: “Jul/1/2014 21:00:00”
Specify the “from time” to be 4 hours before and the “to time” to be 4 hours after the time of error.

/u01/app/12.1.0.2/grid/tfa/bin/tfactl diagcollect -from “Sep/3/2016 12:00:00” -to “Sep/4/2016 08:00:00”

/u01/app/12.1.0.2/grid/tfa/bin/tfactl diagcollect -from “Sep/4/2016 01:00:00” -to “Sep/4/2016 02:28:00”

CLSU-00100: operating system function: opendir failed with error data: 2

CLSU-00100: operating system function: opendir failed with error data: 2

[root@localhost ~]# /u01/app/12.1.0.2/grid/bin/crsctl check crs
Oracle Clusterware infrastructure error in CRSCTL (OS PID 33435): ADR home path /u01/app/oracle/diag/crs/localhost/crs does not exist; ADR initialization will try to create it

CRS-4639: Could not contact Oracle High Availability Service

http://www.oracle-scn.com/asm-not-starting-after-changing-the-hostname-or-ip-address-of-the-server/
https://mehmeteser.wordpress.com/2013/02/21/rename-host-has/
http://www.toadworld.com/platforms/oracle/b/weblog/archive/2016/01/23/how-to-fix-quot-cant-open-scr-home-dir-scls-scr-getval-quot-error

hostname csm-clstrnode1

crsctl start crs

ORA-15087: disk ‘string’ is formatted as an ext2/ext3 or OCFS2 file system

Problem:
ORA-15087: disk ‘string’ is formatted as an ext2/ext3 or OCFS2 file system

Document:
Cannot See ASM Disks From Asmca when using udev rules on rhel 6 (Doc ID 1911888.1)

SOLUTION
Clear the header by writing 25 MB of null, after clearing the header ASMCA and KFOD can able to see the devices
For example:

# dd if=/dev/zero of= bs=1M count=25