Labels

Tuesday, May 2, 2017

Mango Mist Blog

Mango Mist Resort Blog
==========================

Time fly very soon. It looks to me like my marriage happen just few days before, however it had completed 1095 days and still counting was going on.I was happy that it went so soon.It was time for my 3rd Anniversary.I had to think some plan for this. I had 2 choices, either visit some place out of Bangalore or some place near . After doing all the permutation and combination I came to the conclusion to go for a place near by Bangalore. The good reason was it may be difficult to handle my lovely child for making a trip out of Bangalore. Now the big question was where to go. I had to spend one day with my sweet family, so resort might be a good option. It was not a difficult task to choose which resort as internet  made things very easy. After taking few research and advice from friends, I decided to go for Mango Mist Resort.

I got some good feedback from friends about this resort. So thought to take a chance. It was time for booking. I checked in the internet and it was damn easy process for booking.They provide 30% discount on weekdays and 10% on weekends. I was happy that I might get 30% discount as I was planning for Friday. However as per Mango Mist Friday is weekend. Hence I dint have any other option rather than satisfied with 10% discount only. :)

The travel day had arrived and it was time to ready for Mango Mist. The huddle was how to reach. I didn't have a car to visit that place. However I was amazed to know  that OLA Cab service(https://www.olacabs.com/)  was present in that area. So I used this service. I started around 11:15 a.m and reached the place by 12:30 P.M. The security guy in the resort check my details and gave me the way to reach  Mango Mist reception. They were very friendly.After initial verification process, we straight head to wards our cottage. We had booked Neelum cottage which was well maintained.The room  was  all the basic amenities which required for hotel room. Room was made with wood and bamboo. Room size was approximately 12-12 feet size. The background of the wall was with bamboo sticker.  It had 2 chair with one table where one can take Tea/Coffee or other beverage. There was wooden hanger where one can hang his/her dress. The room was having one small tool where land phone was present.  The guest can call to reception,room service,maintenance,security etc. There was a self where one can place the mobile charger,room key and all. AC was present on head side of the wall. There were 2 windows in the room and the outer view was wonderful. There was western bathroom attached with the room.It was well maintained and having all the basic facility  which make you feel like in nature. Overall I feel room condition was awesome. So after reached the room we thought to take some rest and then will go for lunch.

 We started for lunch around 2 p.m. After reaching the buffet area, we were amazed with variety of food. The exception was food taste should be at least ok. However after lunch we felt it
 was a good decision to take lunch in buffet. Planty of variety food was available which included both veg and non-veg. The item included were veg soup,chicken soup,french fries,gobi manchurian,
 grape juice,plane rice,sambar,pulao,chicken biriyani,veg noodle,veg curry,Chicken tikka masala,chicken roggan curry,chapati,naan,salad of different variety etc. In the desert it was
 ice creem, gulab jamun, kheer. The best part of this lunch was that we eat food in an open area where mango trees were present. The wind was flowing very slowly which was very relaxing.
 Me and my better half enjoyed the food. Since food was too heavy, so thought to take some rest. So we went to the cottage.

 In the evening we started roaming different parts of the resort for relaxation. My cottage surrounding was with full of mango trees. Although it was summer season we never felt like we are having sweat or anything  like that. Wind flow was very smooth. We took some photo of resort as well as ours, in order kept for future memories.We went to pool area,bar area,rock climb area,indoor game and outdoor game area.In the evening, we played table tennis,  however we have to  interrupted in the mid as my little baby was very fast in moving one place to other place. Since we need his constant attention so we stopped the game soon. In the evening we were coming   from indoor game to rain dance area,suddenly my son ran in the opposite direction of us. So we both( me and wife) just hide behind the tree, so  that my tinny little champ will not able to find us.
 The boy ran for few yards in the opposite direction and after that he realised that he is alone. So he started return back in our direction. The best part was he didn't cry or scared of dark.
He just reached to the same place where he departed from us. After looking this thing I felt very happy that he is brave.In the rain dance area music was loud and rain was very smooth. People were dancing.It was nice to watch them.

In the night we thought for a la carte  rather then buffet as lunch was little heavy.We order chili chicken,stuff paratha,garlic naan to our room. We really enjoy the food,drink and music. The wind was as usual very refreshing. So we thought to spend some quality time outside of our resort. We sit together,relaxed and discuss various subjects. We never noticed it was around 1:30 a.m. So went for good sleep.

In the morning we wake up and went for breakfast. It was very nice and having lots  of variety in food.The items included like idly,dosa (plan/masala/set), rasam, sambar, chatani, puri, sabji, egg, bread, jam,upma,different types of salad,Tea/Coffee,Juice etc. It was too much and food was really tasty.After breakfast it was time for some activity. So we went to activity areas and participated in rope climbing,fish spa and other  activity. The Fish spa was the very smoothing and interesting. We really enjoyed.

Time went very fast that I never realized that time has come for leaving. We got a call from reception about out time. So we packed and gave the keys to the reception. I request that although
I was doing checkout,however want to spend some more time. They are very politely agree my request. So I kept my luggage in the reception and went for some fun. I had not available the welcome drink so went to the counter and took that. This was also great. After that we did our lunch which was very good.So that time has came for packed off. So booked a cab in OLA again and moved for
sweet lovely home. Reached home around 4:30 p.m in the evening.

I strongly feel and recommend Mango Mist resort who ever want to pay a visit for honeymoon/anniversary etc. I feel happy with the atmosphere and service of Mango Mist.
Lunch was again great






Saturday, August 8, 2015

User complain that query is running very slow in oracle 11g. How to trouble shoot?

Performance issue on 11g.
One day user suddenly started complaining that they are experiening slowness. So I have started troubleshooitng  like below.
Luckly I have OEM, So first I look into performance section to find out how it is currently. I found below to in the OEM.



It is found that select statement is the top SQL and the wait event is db file sequential read. So I had to find out what is the object on which this wait is happening. I found the object information by below queries.



In order to overcome this I gather statistics for that table and flush shared pool.


I Monitor the performance home page and found the performance has improved.


I also cross checked the execution time and elapsed time for the execution.

Question is why I took these steps?
Answer:- This had happen in UAT environment. So most probably states may be old. Sometimes, the stats may not be fresh and it leads to costly execution plans as in this case I had seen the execution and elapse time was high. In such case, immediately stats collection and a flush from shared pool will give new hash value for the sql_id with new plan


Interview on 07-Aug-2015

Interview question for 4-8 years experience held on 07-Aug-2015
1.Tell me about your self
2.Day to day activity in office as oracle dba
3. What is the flow of select statement?
4.What are the steps for oracle RAC installation?
5.What is the purpose of standby redolog files? why it is used?
6.Difference between 10g and 11g?
7.One table is accidentally dropped by user. You don't have flash back feature enabled. Database is production database and in terms of TB. How to restore using RMAN?
8.What is the steps of physical standby creation?
9. What are difference between exp and expdp?
10.What is voting disk and ocr?
11. Why odd numbers of voting disks are used?
12.How to trouble shoot when one node is down in RAC? What are the possible reasons?
13. In expdp what method used to take backup byte or block?
14. What are the advantages of datapump over tradition export ?
15.Suppose a user is connected to the database. and mean the time listner get down. What would happen to that user? When the user will give a statement will that process?
16.User complained one query is not performing well ? what action will be taken?
17.one index is already present in a column. Now we create primary key on that column. will new index will be created?
18. One big transaction was going on and client machine got rebooted. At that time what would happen to that transaction. If it roll back then which process will do this?
19. How to recover undo tablespace?
20 How to recover if redolog files got deleted?
21.What are the steps to create asm instance?
22. What is SCAN listner?
23.If one archive log file has not been applied and it got deleted. How to make standby database sync with primary database?
24.Explain different background process of RAC?
25. Explain background process for ASM?


Thursday, March 6, 2014

Can Common user and local user name be same in oracle 12c?

In a multitenant environment, a common user is a database user whose identity and password are known in the root and in every existing and future pluggable database (PDB).
Hence common user and local user name cannot be same.
Lets proof this satement
SQL> alter system set  "_common_user_prefix"='' scope=spfile;

System altered.

SQL> create pfile from spfile;

File created.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

In pfile
ora12c._common_user_prefix=''
SQL> startup pfile='C:\app\XXXXXX\product\12.1.0\dbhome_1\database\INITora12c.ORA';
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2410864 bytes
Variable Size             666896016 bytes
Database Buffers          394264576 bytes
Redo Buffers                5365760 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT

SQL> create user demo identified by demo;

User created.

SQL> select name,open_mode from v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDBORA12C                      MOUNTED
SUBUPDB                        MOUNTED
TEST                           READ WRITE

SQL> alter session set container=TEST;

Session altered.

SQL> show con_name

CON_NAME
------------------------------
TEST
SQL> create user demo identified by demo;
create user demo identified by demo
            *
ERROR at line 1:
ORA-01920: user name 'DEMO' conflicts with another user or role name
SQL> show con_name

CON_NAME
------------------------------
TEST
SQL> create user hello identified by hello;

User created.
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> create user hello identified by hello;
create user hello identified by hello
*
ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database TEST

ORA-01920: user name 'HELLO' conflicts with another user or role name

Supressing C## for common user in Oracle 12c

Normally common user are started with C## in 12c. But this can be eliminated by using hidden parameter below method. SQL> alter system set  "_common_user_prefix"='v##' scope=spfile; System altered. SQL> create user v## identified by test;create user v## identified by test            *ERROR at line 1:ORA-65096: invalid common user or role nameSolutions:-SQL> create pfile from spfile;
 File created. SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down. #####Opened the pfile and modify the value ora12c._common_user_prefix='V##' SQL> startup pfile='C:\app\XXXXXX\product\12.1.0\dbhome_1\database\INITora12c.ORA';ORACLE instance started. Total System Global Area 1068937216 bytesFixed Size                  2410864 bytesVariable Size             666896016 bytesDatabase Buffers          394264576 bytesRedo Buffers                5365760 bytesDatabase mounted.Database opened.SQL> show con_name CON_NAME------------------------------CDB$ROOTSQL> create user v## identified by test; User created.

Oracle 12c Multisection Incremental backup

Starting with Oracle Database 12Release 1 (12.1), RMAN supports multisection incremental backups. Wherever applicable, RMAN also uses unused block compression and block change tracking while creating multisection incremental backups. When backup sets are used, you can create multisection full or incremental backups.

To create level 0 multisection incremental backups, the COMPATIBLE parameter must be set to 11.0 or higher. However, to create multisection incremental backups of level 1 or higher, you must set the COMPATIBLE parameter to 12.0.0 or higher. RMAN always creates multisection incremental backups withFILESPERSET set to 1.

The SECTION SIZE clause specifies the size of each backup section. If you specify a section size that is larger than the size of the file, then RMAN does not use multisection backups for that file.

Multisection Incremental Backup of Database as Backup Sets
SQL> select name from v$database;

NAME
---------
ORA12C
SQL> show user
USER is "SYS"
SQL> create user c##x identified by c##x;

User created.
SQL> grant sysbackup to c##x;

Grant succeeded.

SQL> grant connect,resource to c##x;

Grant succeeded.
C:\Users\xxxxxx>rman target 'c##x@ORA12C as sysbackup'

Recovery Manager: Release 12.1.0.1.0 - Production on Thu Mar 6 16:47:51 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

target database Password:
connected to target database: ORA12C (DBID=218350063)
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;

using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored

RMAN> backup incremental level 1 section size 300m datafile 'C:\APP\XXXXXX\ORADATA\ORA12C\SYSTEM01.DBF';

Starting backup at 06-MAR-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=267 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=34 device type=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSTEM01.DBF
backing up blocks 1 through 38400
channel ORA_DISK_1: starting piece 1 at 06-MAR-14
channel ORA_DISK_2: starting incremental level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSTEM01.DBF
backing up blocks 38401 through 76800
channel ORA_DISK_2: starting piece 2 at 06-MAR-14
channel ORA_DISK_1: finished piece 1 at 06-MAR-14
piece handle=C:\APP\XXXXXX\RECOVERY_AREA\ORA12C\BACKUPSET\2014_03_06\O1_MF_NNND1_TAG20140306T165137_9KJPL2B2_.BKP tag=TAG20140306T165137 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:05:31
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSTEM01.DBF
backing up blocks 76801 through 98560
channel ORA_DISK_1: starting piece 3 at 06-MAR-14
channel ORA_DISK_2: finished piece 2 at 06-MAR-14
piece handle=C:\APP\XXXXXX\RECOVERY_AREA\ORA12C\BACKUPSET\2014_03_06\O1_MF_NNND1_TAG20140306T165137_9KJPWFGG_.BKP tag=TAG20140306T165137 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_1: finished piece 3 at 06-MAR-14
piece handle=C:\APP\XXXXXX\RECOVERY_AREA\ORA12C\BACKUPSET\2014_03_06\O1_MF_NNND1_TAG20140306T165137_9KJPWKS0_.BKP tag=TAG20140306T165137 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 06-MAR-14

Starting Control File and SPFILE Autobackup at 06-MAR-14
piece handle=C:\APP\XXXXXX\RECOVERY_AREA\ORA12C\AUTOBACKUP\2014_03_06\O1_MF_S_841510637_9KJPWP6R_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 06-MAR-14



Making Multisection Backups Using Image Copies
While the image copy is being created, multiple channels are used to write files sections. However, the output of this operation is one copy for each data file. If the section size that you specify is larger than the size of the file, then RMAN does not use multisection backups for that file.

Ensure that the COMPATIBLE parameter for the target database is set to 12.0.0 or higher.
RMAN> BACKUP AS COPY SECTION SIZE 500M DATABASE;

Starting backup at 06-MAR-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=267 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=32 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSTEM01.DBF
backing up blocks 1 through 64000
channel ORA_DISK_2: starting datafile copy
input datafile file number=00003 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSAUX01.DBF
backing up blocks 1 through 64000
level 1 incremental backup of image copy.

RMAN> RUN {
   RECOVER COPY OF DATABASE WITH TAG 'incr_update';
   BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_update' section size 500m
       DATABASE;
   }
Starting backup at 06-MAR-14
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSTEM01.DBF
backing up blocks 1 through 64000
channel ORA_DISK_1: starting piece 1 at 06-MAR-14
channel ORA_DISK_2: starting incremental level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00003 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSAUX01.DBF
backing up blocks 1 through 64000
channel ORA_DISK_2: starting piece 1 at 06-MAR-14
channel ORA_DISK_1: finished piece 1 at 06-MAR-14
piece handle=C:\APP\XXXXXX\RECOVERY_AREA\ORA12C\BACKUPSET\2014_03_06\O1_MF_NNND1_INCR_UPDATE_9KJSKMP
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:17
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set


Blogs

http://saivamsi.blogspot.com/

http://shaharear.blogspot.com/

http://harshavardhandba.blogspot.com/

http://dbataj.blogspot.com/

http://ayyudba.blogspot.com/