Proper way of Startup/Shutdown Oracle Database Instance (Solaris) ..

Guys.. I am not a DBA. I am just a SA. But SA role is related with Database environment also. And I think that every SA should know about basic of Database as like how to Start/Shutdown the database service properly.

Let's say.. you need to shutdown the Oracle Database server machine for your maintainance of hardware or other purpose. If you are going to shutdown the server before shutdown the database , Man .. It will be like that you find the risk by yourself and call phone to DBA .. :)

Ok .. Here is the start and shutdown process of the orcale database which is running on solaris .

Startup
If you are already login to solaris terminal with root , change to orcale user

#su - oracle

Enter the following command to start SQL Command Line

#sqlplus

It will ask to type user name type " / as sysdba"

#Enter user-name: / as sysdba
(note: you can use only one command to login SQL command line "#sqlplus / as sysdba" )

To start the database , type follow command : "STARTUP"

 SQL>STARTUP

And type "exit" for leave the sql command line.

SQL>exit

Then, Start the Oracle listener : (If Orcale Database is for remote clients, you will need this step)

#lsnrctl start
Shutdown
If you are already login to solaris terminal with root , change to orcale user

#su - oracle

Enter the following command to start SQL Command Line

#sqlplus

It will ask to type user name type " / as sysdba"

#Enter user-name: / as sysdba

To shutdown the database , type follow command : "SHUTDOWN IMMEDIATE"

SQL> SHUTDOWN IMMEDIATE

And type "exit" for leave the sql command line.

SQL>exit

Then, Stop the Oracle listener : (If you Orcale Database is for remote clients, you will need this step)

#lsnrctl stop

OK now switch back to root user and process to shutdown the solaris OS

#shutdown -y -g0 -i5

>>

UTEE

Ref :http://docs.oracle.com/cd/B25329_01/doc/admin.102/b25107/startup.htm

Mouse Without Border ...

Guys..

Ok Let say, You are a busy guy, you have to control different OS with different monitors, which are on your small desk. If you are using one mouse and one keyboard for each OS, Do you think you will be convenience on your small desk? (that's my reson :P )

Here let me introduce two product that allow you to control so many computer by one pair of keyboard and mouse.....

1) Microsoft Garage Mouse Without Borders

"Mouse without Borders is a product that makes you the captain of your computer fleet by allowing you to control up to four computers from a single mouse and keyboard. This means that with Mouse without Borders you can copy text or drag and drop files across computers."


This will allow you to control between various of Microsoft OS Windows 7, Windows 8, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows Vista, Windows XP. But This is support between only Microsoft OS Platforms.

you can download freely @ below link..

http://www.microsoft.com/en-us/download/details.aspx?id=35460


2) Synergy

"Synergy lets you easily share your mouse and keyboard between multiple computers on your desk, and it's Free and Open Source. Just move your mouse off the edge of one computer's screen on to another. You can even share all of your clipboards. All you need is a network connection. Synergy is cross-platform (works on Windows, Mac OS X and Linux)."

This is a alternative way of Microsoft Mouse Without Border But this will allow you to control between Microsoft OS, Linux or Mac.

http://synergy-foss.org/


Note: I want to recommend "Microsoft Mouse Without Border" if your OS are various of  Microsoft OS because it's allow you to copy, drag and drop a file via this product.

>>

UTEE

Ref :Microsoft / OpenSource / Forum

Solaris 10 Internet not working problem with Web Browser

Solaris 10 Internet not working problem with Web Browser

Problem is here ..

I configured the static IP on Solaris 10. And I tried to browse the website on browser of Solaris 10. But I can't browse any website on the browser.

So Tested the "nslookup" on terminal , It's ok.

Ping to Google IP, It's return back "alive".

 So I tried search on the google/forum for this problem.

"This is what i founded and that is the perfect answer for this problem."


Yes , There have two things that you may be forget when you setting up the IP configuration on Solaris .

1) Must be sure to add nameserver on /etc/resolv.conf

 

 2) And Most of the people are forget to put the entry called "dns" at behind of "hosts" line in the /etc/nsswitch.conf . I am also no idea to do this before  :P

Ok now you may be restart the network service or reboot the system.

#svcadm restart network/physical

>>

UTEE

Ref :Forums

Configuration of Static IP on Solaris 10

Configuring the static ip on Solaris 10 is different with the other linux. You have to configure a few files.

Firstly you must know your interface name of your solaris. You can get your interface name with following command.

#dladm show-link

If your solaris is configured with the DHCP, you must delete file /etc/dhcp.interface (/etc/dhcp.e1000g0). Now you have to configure with below files :

/etc/hosts
/etc/hostname.interface
/etc/nodename
/etc/inet/hosts
/etc/inet/ipnodes
/etc/defaultrouter

Add the IP and hostname at /etc/hosts

Add IP and Netmask at /etc/hostname.interface (/etc/hostname.e1000g0)

Add the hostname at /etc/nodename , If nodename file isn't available at /etc by the default, create byself.

/etc/inet/hosts and /etc/inet/ipnodes will updated automatically if you updated your hostname on /etc/hosts. If not, add the same entries as /etc/hosts.

Add default gateway ip at /etc/defaultrouter, If defaultrouter file isn't available at /etc by the default, create byself.

Now, restart the Network service using following command or reboot the server for the changes to take effect.

# svcadm restart network/physical

 >>

UTEE

Ref: Forums

NIC Teaming On VMware ESXi

NIC Teaming On VMware ESXi

This will show you to how to create a teaming with 2 nics on VMware ESXi 5.0 .

Why we need the nic teaming for a virtual environment?

" A NIC team can share the load of traffic between physical and virtual networks among some or all of its members, as well as provide passive failover in the event of a hardware failure or network outage. " By kb.vmware

Ok Let's start..

1) Connect to your ESXi box with the vSphere Client..

2) Choose the "Configuration"

3) Choose "Networking" from the Hardware Panal

 

4) Click "Add Networking"

5) Choose "Virtual Machine" and click "Next"

6) Choose "Create a vSphere Standard switch" and tip on the 2 nics which are you want to prefer to be a teaming then click the "Next"

7) Click "Next"

8) Click "Finish"

9) Click the "Properities" of created vSwitch

10) Choose "VM Network" and Click the "Edit"

11) Click the "NIC Teaming" tab.

12) Tip on the "Load Balancing" and choose the "Route based on the originating virtual port ID" then click "Ok".

13) Click "Close"

Now Nic teaming is finish !! We can define the TCP/IP information by adding "VM Kernal" on that vSwitch..

>>

UTEE

Ref:
- http://kb.vmware.com