SAINORA

HomeTech Articles

Blogs

ASM

Gopinathan D Published on 24th March 2012

groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba oracle
passwd oracle

Read more

Configure YUM in OEL 5

Gopinathan D Published on 18th June 2013

Install 2 packages
[root@redhat Server]# rpm -Uvh vsftpd*
[root@redhat Server]# rpm -Uvh createrepo*

Read more

Configure Mail Server in Linux

Gopinathan D Published on 18th June 2013

[root@redhat ]# yum install bind
[root@redhat ~]# yum install system-config-bind
Loaded plugins: security
Setting up Install Process

Read more

Dataguard

Gopinathan D Published on 24th March 2012

Configure dataguard in oracle 10G
Primary database : sss
server : 192.168.1.100
standby database : std
server : 192.168.1.101

Read more

Disk Maintenance

Gopinathan D Published on 19th July 2012

Adding a Disk in Linux
Step 1:
Create a Disk in VMware
Step 2 :
Start the Virtual Machine

Read more

EXP IMP

Gopinathan D Published on 17th April 2012

Exp and Imp are logical backups.
They must connect to a opened database and take the backup or do the recovery.
It does cross platform data movement like linux to windows / solaris to linux etc..

Read more

Linux & Shell Script

Gopinathan D Published on 24th March 2012

What is UMASK?
When user creates a file or directory it will be created with permission. The default value is 022.
If we create a file or directory the file will be created with 755 permission.
the calculation is the difference between 777 and the umask value.
ie. 777-022=755.

Read more

Oracle Architecture

Gopinathan D Published on 24th March 2012

Explain Oracle Architecture?
Oracle server is divided into instance and database.
Again,
INSTANCE is divided into
Memory structures
Background processes.

Read more

Oracle Architecture Questions

Gopinathan D Published on 17th May 2013

1. Explain Oracle architecture?
2. what will happen if you give commit?
3.What is difference between
pinned vs dirty buffer
keep and recycle
4. what is logical and physical structures in database?

Read more

Oracle Installation

Gopinathan D Published on 24th March 2012

[root@redhat ]# yum install bind
[root@redhat ~]# yum install system-config-bind
Loaded plugins: security
Setting up Install Process

Read more

Oracle Interview Questions

Gopinathan D Published on 17th May 2013

1.How to detach oracle and attach oracle.
2.How will you remove oracle home from inventory details.
3.name some tuning parameters.
4.What is the purpose of exact,similar,force.
5.how will you apply stdby logs on stdby server. For some reason logs are not applied on stdby db.

Read more

Patches And Upgradation

Gopinathan D Published on 24th March 2012

What are the types of patch in oracle?
There are different kinds of oracle patches.
CPU - Critical Patch Update
Interim patches
Generic patches.
PSU - Patch Set Update

Read more

PerformanceTuning

Gopinathan D Published on 24th March 2012

One of the most and COMPLEX task is tuning the database. COMPLEX is not the correct word, if we understand the environment(ie. functionality) and we know how to tune a query, then everything is simple. Advanced tuning can be learned only through experience and with good environment setup.

Read more

24th March 2012

Gopinathan D Published on 24th March 2012

groupadd oinstall
groupadd dba
mkdir -p /export/home/oracle /ocfs
useradd -d /export/home/oracle -g oinstall -G dba -s /bin/ksh oracle
chown oracle:dba /export/home/oracle /u01
passwd oracle

Read more

RMAN

Gopinathan D Published on 9th May 2012

How will you restore a backupset into new server from different location.
1. Create the pfile in the new server.
2. startup the database in nomount stage;
3. connect to rman and restore the controlfile using the below command.

Read more

SQL

Gopinathan D Published on 17th May 2013

1. What is difference between decode and case?
2. How will you delete duplicate records?
3. how will select first 5 records from a table?
4. what are the psedu columns?
5. Difference between delete and truncate?

Read more

Tns And Listener

Gopinathan D Published on 24th March 2012

Registering listener in oracle 11G
Error :
[oracle@oraclehost admin]$ sqlplus system/manager@test
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 21 11:16:06 2013

Read more

Video tutorials

linux installation oel5

Oracle Architecture in 10g

Tablespace

View more...