Sharing Real Life Career Starting Experiences

Dear Friends,
Myself SKU. And today, I got this opportunity to share my Real time and Real life Experiences with you all friends.
So, I’m a software engineer by trade, Oracle Apps DBA. I do front-end and back-end stuff; I am always  reading about the latest technologies on Oracle and others; and I’m always experienced the away at  something or other. And I blog.

Whenever I learn something new, or see something cool, I 
Firstly, it means that I end up understanding stuff that little bit better. 
I consolidate new concepts, transforming them from purely practical applications to something more  concrete. I can also learn from the people who end up leaving a comment, which is often. 

It’s also incredibly gratifying when people leave comments, thanking you for articulating something  which they struggled to understand before.

Secondly, I can show other people (and potential employers) that I’m passionate about learning,  developing and improving to myself and others also. This is incredibly valuable.

I started my Carrier at Bangalore. When I was struggling for job,I didn't get job, Even tried for BPO companies but I didn't get.
As every parents my parents also expecting job asap, But i was not having any answer to them and stopped to pickup the call. That situation was like hell for me. But it happens almost of us.I really don’t want that situation with any one of us.

At last I got a job in small company as sql, plsql and php developer.
One thing Remember, if you want anything, you have to do everything for that. And definitely, you will get it.

Believe me, I tried a lots for job full . I remember that days, when I was not able to sleep and eat properly because of tension, I didn't picked up the call of my parents. I cant explain that in words...

From that I learned better not to join a very small company, they will use you a lots, So be very careful in choosing a small companies. 
We joined a company either for learning or earning but at some places we didn't get anything. Only they will use us for their any type of work.
but we joined them for greedy of experiences , even that also don’t work in future. Now industries have changed.

This same thing happened with me, then I decided to resign company.
And I decided to learn Oracle technology, which I was inspired by my ex- company MD. 

Then I met one of my PG mate, he was not knowing any languages like C, C++, java, .Net etc... he was only knowing Oracle technology. And he was working in MNC. He described me about Oracle, he gave me many documents for oracle. And then I started to learn.

Later on I joined a consultancy for Oracle learning after quieting 1st job. I learned oracle database and application in 6 month. Then I worked next 6 month on project in very few salary. But I did that project because there was learning for me. Its true that company learned a lots from me :D.
After that I joined another company with a good salary and started my carrier as Oracle Apps DBA. After 1 year again I got new opportunity in Oracle company, which was my dream.

One thing remember, We all everyone require good adviser from experienced person. I’m telling this because when I was in college and joined a Training institutes, they told there is no carrier in DBAs in the market because almost companies have 1 or 2 DBAs. But it was not true.

Remember: 
If you don’t have any Dream other people will use you to complete their dream.

Nothing is Hard, Just you need to start and be positive. Never give up. I’m damn sure, you will achieve it. For any help, please contact us or put your ideas in comments.

Thank you Every body for joining us, Please keep in touch and like us for real time and real life experiences. And also join with us to share your real time/life experiences which useful and learning for everyone of us.

Some useful links:

Job Tips

Career Planning

R12.1 Vs R12.2

R12.2 Architecture & Concepts

Thanks,

ABOUT

About : ORA-DATA
Author : SKU (Oracle Apps DBA)

Ora-data is part of a helping to every Oracle DBA’s or Oracle Learners.

 
This is a long yet interesting! :)

Ora-data

Welcome to our ora-data – A community of enthusiastic Oracle DBA who are popularly known as “ora-data” ORACLE DBA !

Here is what you will find on our ora-data oracle hub:

Here almost 95% are practical Basics & advanced Oracle DBA techniques to learn & apply accordingly from our blog; the other 5% is for personal real time experiences and stories.

These are all pretty cool techniques but not that easy.
A community of like-minded Oracle DBA’s who hang out & talk about oracle techniques on our dedicated forum for Oracle DBAs.

This site is not limited to tech only like any other kind of blogging. Our Blog is appropriate for everyone with any kind of techniques, developments, real time experiences sharing and blogging etc.

Complete “Step by Step” learning and “How-To” execute it shown and shared.

Latest and new techniques & real time experiences for our blogs.

Free tutorials & video guides to simplify complex tech or ideas.(We know this is new but growing fast.)

Oracle to learn DBA on the go. (Yeah! I believe it’s the good future…)
I get down at Bangalore on 17th Aug 2012 and started looking for job. But same as everyone, I tried everywhere but didn't get anywhere. Even tried for 24/7 BPO and others where I was rejected and some of my friends was selected. You can imagine my feeling at that situation. Its happens with almost of us as per my experiences.
And as every parents, my parents also wish to listen at every evening that I got job, but how can I explain them that its not so easy. Even for some times I ignore their calls because I was not having words to tell or say them...

Something which started for my expenses and turned out to be the biggest life changing experience for me. In the last Four years, I become Oracle DBA, more than just a what I expected. It has made a positive impact on me.

This blog’s is not just for making number of likes and subscribes. It’s for guiding and sharing true and real time experiences which will change the lives of many others who apply these techniques.
This community will help numerous individuals to become Star either in corporate or in real life .

This is done by becoming experienced independent first, and then experiencing the true meaning of life.
If you are new to career , don’t be worry just start your days from today. I’m sure, you can do or change anything by your hard work and smart work.

Always Remember:
With your words, you have the power to change this world.

Ora-data is the best Oracle DBA community for anyone who is passionate about discovering themselves through writing and sharing real time experiences.

Many people think sharing experiences is only about writing your personal stories, but its not like that here. We are mixing our hard work with smart work real time and life experiences, which can make a living with others; 
this is what ora-data.blogspot.in is all about.

Ora-data is an answer to:

• How to develop sql, plsql scripts.
• How to learn oracle database.
• How to install oracle database.
• How to learn oracle applications.
• How to install oracle applications.
• How to do oracle database patching
• How to do oracle applications patching.
• How to clone oracle database.
• How to clone oracle applications.
• How to upgrade oracle database.
• How to upgrade oracle applications.
• Related all about oracle products and other new technologies many more.

As we all now how about our colleges, how tough to believe them.
Once they told us for about internship training from MNC company but when the training started they just called a local trainer. And for that they charged us heavily, later on they gave us just a color printout as training certificate card which was not a useful at all.
This was one of the most bad experiences from college.

When I’m not on my computer, I love to play games and watching movies.
But also to keep myself fit in this busy world, I love to meditate & exercise(gym).

So yeah, that’s all about me.
I’ll leave you with this moment of relative seriousness:

When I first started my carrier as sql, plsql and php developer, I became very happy that I got job as
everyone. But later on I was not happy with work and growth.
So, later on I resign my Job for learning oracle. I had no idea how it was going to be. I just did it  because I loved it! and today I’m working in ORACLE as oracle apps dba.

I felt as like me, many are there who needs some guidance and support in their life.
So started to share my real time and real life experiences, because I believe in sharing.

I love and believe in simplicity, hard work and smart work.

Summing It Up: ORA-DATA

ora-data primarily focuses on oracle DBA’s stuff, Real time experience sharing, real life experiences  sharing, blogging, reviews and suggestions, SEO tips.

We highlight the oracle DBA’s stuff aspects of blogging and teach about how anyone can learn from home via blogging.

ORA-DATA is a community blog where we allow DBA’s to take part and contribute via guest posts. At the time of updating this page.

How to become a part of the ora-data team :

To make sure you never miss any updates from ora-data, feel free to like us on google plus, Facebook, twitter and subscribe by clicking on the RSS link.

In this blog We want to keep and share all of our real time and real life true experiences. 

Thanks, 

Oracle session details and query to find out details

Hi DBA-Mates,
Many times we all faced issues like blocking session, High Temp usage and etc. which is related to session.
As we all knowing that every login requires a session. It specifies the maximum number of the sessions that can be created in the system. 

Actually, this parameter determines the maximum number of concurrent users in the system.

It can set this parameter explicitly by to a value almost closed to our maximum number of the concurrent users plus the number of background processes and approx 10% of the recursive sessions.

By default value for this parameter is as its minimum and values between 1 and the default do no trigger error. But always remember oracle ignores them and uses the default instead.

Always remember that the default values of ENQUEUE_RESOURCES and TRANSACTIONS parameters are also derived from SESSIONS. Therefore, if you increase the value of SESSIONS , you also should consider whether to adjust the values of above two parameters ENQUEUE_RESOURCES and TRANSACTIONS.

This sql query displays information about a session.
For this query, we should have SID number available.

column sid                                format 9999
column serial                             format 99999
column osuser   HEADING 'O/S|Username'    FORMAT a9
column username HEADING 'Oracle|Username' FORMAT a9
column program                            FORMAT a20

SELECT sid, serial#, osuser, username, status, logon_time, program
FROM v$session
WHERE sid like '&SID'
/

And some times, if the session is INACTIVE form session, we can kill the session.
In case of Active or Inactive Toad connections , SQL/PLSQL session can be killed but remember always if you are working on production, we must should follow some points like:
1. we should collect the details related to that particular session.
2. Inform the concern team.
3. Get approval.
4. Now you are ready to kill the session.

A session can be killed by below command:
SQL> ALTER SYSTEM KILL SESSION 'sid,serial#';

But in RAC, its is different because in RAC servers we use gv$session. And to kill the session we should use below command:
SQL> ALTER SYSTEM KILL SESSION 'sid,serial#,@inst_id';

If you want to kill the session Immediate because as we know this kill command will asks session to kill itself. But in any situation if you want to kill immediately, So better to use IMMEDIATE clause as shown below command.

SQL> ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

Also from this below session query, we can get the information about the sessions.

It will ask for some values which can be escape if you are not knowing and hit enter.

Select ' Sid, Serial#, Aud sid : '|| s.sid||' , '||s.serial#||' , '||

       s.audsid||chr(10)|| '     DB User / OS User : '||s.username||

       '   /   '||s.osuser||chr(10)|| '    Machine - Terminal : '||

       s.machine||'  -  '|| s.terminal||chr(10)||

       '        OS Process Ids : '||

       s.process||' (Client)  '||p.spid||' (Server)'|| chr(10)||

       '   Client Program Name : '||s.program "Session Info"

  from v$process p,v$session s

 where p.addr = s.paddr

   and s.sid = nvl('&SID',s.sid)

   and nvl(s.terminal,' ') = nvl('&Terminal',nvl(s.terminal,' '))

   and s.process = nvl('&Process',s.process)

   and p.spid = nvl('&spid',p.spid)

   and s.username = nvl('&username',s.username)

   and nvl(s.osuser,' ') = nvl('&OSUser',nvl(s.osuser,' '))

   and nvl(s.machine,' ') = nvl('&machine',nvl(s.machine,' '))

   and nvl('&SID',nvl('&TERMINAL',nvl('&PROCESS',nvl('&SPID',nvl('&USERNAME',

       nvl('&OSUSER',nvl('&MACHINE','NO VALUES'))))))) <> 'NO VALUES'

/

Hope you learned something new here. Please let us know for any concerns or suggestions either in comment box or Contact US. Remember we loved to listen from you.

Hope these will be useful:
How to Read and Write UTL file!!
EBS R12 Installation Steps
ORACLE DATABASE
Rebuild Context file Steps
Regards,
ora-data Team

Sharing: A Company's Experience

Dear friends,

Many friends asked me to share the experiences in Hindi. Already we have languages translation on blog but that is not enough.

Sorry to all and today I will share my first company experiences in Hindi here.

So, guys let cheerssss up.

Dosto, app sabhi ko pta hai ki maine job ke liye kya kartha tha, wo already maine share kiya hai mere previous post me How to get Job and What should do.

Bhai jab mujhe interviews ke liye call aaya tha mai bahut kush hua, fir kya ready ho kar chal diya. Baad me pta chala us din Bangalore band tha aur ooper se unknown place tha. Fir maine socha ager aaj mai company kisi tarah se pahuch gya tha thoda achha impression banega hhhh.

Tragedy:

Us din govt. busses band thi lekin pvt cabs chal rhe the. Maine cab wale se puch ki address jante ho mujhe pahucha doge, wo baitha liya fir baad me dusre jagah pahucha diya. Fir mai waha se dusre logo se pucha fir cab pakda, fir jaise taise almost 2-3 KM paidal chal kar office pahucha, kyunki bhai apni aukat nhi thi Auto se jane ka frankly. Bina job ke hum middle class wale sochte hai jitna ho sake 2 rupye bach jaye… :P 

Yaaro, aisa hota hai new places me. Shayad app logo ke sath bhi aisa hua hoga jab aap log new places/city me jate honge.

Our Dream:

Hum sab sochte hai ki company badi ho to mast lagta hai dekhne me. Mai bhi kuch aisa hi socha tha Mungeri lala ke khawab hhhh. Lekin jab pahucha to dekha ki 2 room ki company khol ke baithe the. Thoda bura laga mujhe, lekin bhai naukri karna tha, career start karna tha.

Interviews hua, usme SQL, PLSQL puche jo mujhe kuch khas pta nhi tha. Thoda- bahut reply diya. Baad me unhone bola reply karenge.Fir baad me reply aaya ki Selected.

Fir kya bahut khusi. Baad me pta chala salary bahut kam thi. Sorry yar bahut kam tha jo likhne me kharab lag rha hai yaha. Lekin monthly expenses chal jate the.

Maine job join kar liya. Sabki tarah maine bhi socha experiences lekar chhor denge. Kyunki hum sab jante hai suru me experiences hum sabhi ko chahiye.

Our Thoughts:

Jab hum interview dene jate hai aur waha ke employee ko dekh ke kahte hai ki wo kitna lucky ha.

Reality:

Lekin bhai log ye jaruri nhi hai ki wo aapse/humse jayada knowledgeful hai aur  wo jayada intelligent hai. Wo depend karte hai situation or luck pe bhi.

Wo intelligent ho bhi sakte hai aur nhi bhi :D :P Lekin ye sach hai bhai aise bahut log hai jo intelligent hote hue bhi unhe opportunity nhi milti hai.

Kabhi company ki jyada jarurat hoti hai to kabhi kuch log lucky hote hai jo less knowledge hote hue bhi select ho  jate hai…

Kuch din kaam kiya jisme sirf 4 log kaam karte the. Pehle unhone bola php or sql kaam denge. Kuch kaam diya fir bina matlab ka bhi kaam dene suru kar diye jaise data entry or others…

Even jab hum bolte the ki hum aise job nhi karenge to bolte the company me rehna hai to karna padega. Hume company ka advertise karne ko bolte the. Compnay product ke bare me internet pe advertise karne ko bolte the and etc…

Mai aapko reason batata hun ander ki baat. Dekhiye unke pass kaam nhi hota hai, kaam means project nhi hota hai aur wo hume salary pay karte hai, fir wo hume use(istemal) karna chahte hai isliye wo kuch bhi kaam de dete hai karne ko.

Humare sarafat ka log galat fayeda uthate hai. Naukri me kabhi bhi majburi nhi dikhao. Humare emotions or izzat dene ko log majburi samjhate hai. Even for experiences also, kabhi bhi aisi chhoti company join mat karo.

Mai waha subah 9 baje se raat 9 ,10 and 11 baje tak. Lekin na kuch sikhne ko mila aur na hi kuch achha experiences. Jo bate boss bole usko mano. Achha image banane ke chakkar me har baat mano, lekin wo kuch kaam nhi aata hai bhai. Never expect anything there; they will see their benefit only.

Haan ek ye experiences mila jo mai aap logo ke sath experiences kar sakte hai bata sakte hai kya hota hai waha. At least app log to sambhal jao.

Some useful links:

JobTips

CareerTips

ORACLE APPS DBA

ORACLE DATABASE

Thanks,

How to check and get details about patch applied

Hey DBA-Mates,
Oracle always tries to provide all the information which will be helping to customer and informed decisions about when and what patches to apply on servers. Our exposes bugs resolved by this patch and do a search against the knowledge base to check if there any articles or documents might be relate to this patch. After apply the patches, how we will come to check that the patches has been applied or not on the servers. 

As we all know we apply the patches to fix any bugs or issue in our either oracle database or application. It may be either small or big bugs or issues, which depends on situations. As per my experiences, my suggestion is always go through readme.txt or readme.html file in patch directory before applying the patches. And you may have noticed, always readme.html is clear by looking way and colorful which helps a lots for understanding. It’s just my opinion, depends on person to person.

Please find the below query to check.

SQL>set pages 1000
SQL>set linesize 100
SQL>column APPLIED_PATCH_ID format 9999999999
SQL>column PATCH_NAME format a16
SQL>column CREATION_DATE format a16
SQL>column BUG_ID format 9999999999
SQL>column BUG_NUMBER format a16
SQL>SELECT APPLIED_PATCH_ID,PATCH_NAME,CREATION_DATE

FROM apps.ad_applied_patches where patch_name='&PatchNO'
union
SELECT BUG_ID,BUG_NUMBER,CREATION_DATE

FROM apps.ad_bugs where bug_number='&PatchNO'
/

If we have the patch number, we can check the patch details from below query:

To get or find out all the patch details by giving patch number as input:

SQL>SELECT to_char(r.patch_run_id) patch_run_id
,t.name appl_top
,d.driver_file_name driver_file_name
,l.language language
,to_char(r.start_date,'YYYY/MM/DD HH24:MI:SS') start_date
,to_char(r.end_date,'YYYY/MM/DD HH24:MI:SS') end_date
,r.patch_top patch_top
FROM ad_appl_tops t
,ad_patch_drivers d
,ad_patch_runs r
,ad_patch_driver_langs l
WHERE t.appl_top_id = r.appl_top_id
and r.patch_driver_id = d.patch_driver_id
and l.patch_driver_id = d.patch_driver_id
and d.driver_file_name like '%&p_bug_number%'
order by r.patch_run_id
/

From above query, it will prompt for patch number, which we need to give as input. Please give the patch number and get all the details about that patch.
 

Hope above query may useful and helpful. For any concerns, please write to us either in comment box or contact us @ora-data.blogspot.com

Below are some more useful and helpful links:

Oracle database 12c Installation Step by Step

R12.2 Architecture and Concepts in details

Interviews Questions and Answers

Job Tips

R12.1 Vs R12.2

Regards,

Oracle Data Blocks, Extents and Segments Concepts

Hi DBA-Mates,
Oracle data block

As we know that Oracle allocates logical database space for all data in a database.

Actually, data blocks are also called as logical or oracle blocks or pages. And oracle stores the data in data blocks to a specific number of bytes of physical database space on disk.

In short for understand:

Oracle data blocks are Logical storage space where Oracle Database stores data in data blocks at smallest unit.

We can set the size from DB_BLOCK_SIZE initialization parameter.

Very Important:

Oracle data block-->Extents-->Segments-->Tablespace are LOGICAL STORAGE.

Data files and OS blocks are PHYSICAL STORAGE.

Oracle data block contains below important information:

Common and Variable Header

Table Directory

Row Directory

Free Space

Row Data

Extents:

In easy languages:

Extents are the logical unit of database which is made of contiguous multiple numbers of the oracle data blocks.

For example: oracle data block1+data block2+data block3 = 1 Extent etc.

As we all knowing that an extent is a logical unit of oracle database and space allocation is made up of a number of contiguous data blocks.

Segment:
And as database concepts, one or more extents are called a segment. Whenever the existing space in a segment is completely used or full, oracle allocates a new extent for the segment.

There is Storage parameters which expressed in terms of extents and define every segment.

And one more thing as we know that a Tablespace that manages the extents locally which can be either uniform extent size or variable extent sizes that are determined automatically by the system.

Above is just summery, if required, we will talk about extents later on because these all are very basic concepts about oracle database or we can say it is starting of the oracle database. Here the need is about the sql query for extents, maximum extents and size of all the extents.

We have some sql query which will be very useful getting the details of the extents.

To get the current no. of extents, maximum extents, sizes of all the extents and the sizes of them by inputting a segment name not owned by SYS User:

SQL>col owner for a7
SQL>col SEGMENT_TYPE for a7
SQL>col TABLE_NAME for a25
SQL>col NEXT(KB) for 9,999,990

SQL>SELECT s.owner, s.segment_type, t.table_name,
t.max_extents, t.next_extent/1024 "NEXT(KB)", s.extents
FROM dba_tables t, dba_segments s
WHERE t.table_name=s.segment_name
and t.owner not like 'SYS%'
and s.extents > 100
union all
SELECT s.owner, s.segment_type, i.index_name,
i.max_extents, i.next_extent/1024 "NEXT(KB)", s.extents
FROM dba_indexes i, dba_segments s
WHERE i.index_name=s.segment_name
and i.owner not like 'SYS%'
and s.extents > 100
/

And also a DBA can deallocate the unused extents using the below sql query:

SQL>Alter table table_name deallocate unused;

Hope these details and sql scripts may useful and helpful. For any concerns or suggestion please write to us either in comment box or Contact Us @ https://ora-data.blogspot.in/

Some Useful links:

Important Scripts

Oracle R12.1 Vs R12.2

Career tips

R12.2 Concepts and Architecture

Jobs Tips

Thanks,