Tech Lover

In this I am going to explain in detail about installation of DATABASE on LINUX As we all know Database installation is easy task on Windows. On other hand Linux is little complex as we need to do many  step before installation. Step1:-  Download the DB setup from  https://www.oracle.com/downloads Step2:-  After downloading the setup. We need to prepare our OS (windows and linux) 1) Make an entry in "/etc/hosts" for linux and "C:\Windows\System32\drivers\etc\hosts" for windows like below :-      127.0.0.1       localhost.localdomain  localhost      XXX.XXX.XXX.XXX         test.domain            test  Where XXX.XXX.XXX.XXX is IP of your machine. 2) No Need to do anything for windows After this. On linux you need to check the packages. Below are the packages that should be there in the Linux server.  For Linux : You can create all the packages by using oracle...

How to solve ORA-12505, Listener does not currently know of SID   This is very common error and really it will suck your blood if you are not right path. I will try to explain you about this error. As you can see this error is showing itself that listener is up and running but not serving  the SID that it is meant for. And yes 1st you need to check where you are facing this error. Is it on client side or on server side. So what is the SID this listener looking for? SID is name for your database or you can say service identifier, That is help to to identify the the service like we use PROD for production UAT for testing server. SID of Database should be identical to avoid the confusion. It's length is 8 character only that means you can not extend it more then 8 character. Now how listener works ? As we all know its like a car, That drop us from airport to hotel, hahah sorry I am not good in examples. So let me explain technically, whenever you try to make connection from ...

Oracle's “Ten Days Rule” ?? I know it's very confusing and hard to understand " Oracle Ten Days Rule”. I will try to explain these "Ten Days Rule”. Please check my post on oracle auditing risks too. Oracle's “Ten Days Rule” are very confusing not even for us but sometimes for oracle's sales representatives too. You have to pay a lot of money means a lot if you follow them wrongly. We all may thinks that by these "Oracle 10 day rules" we can run our DR(disaster  recovery) server for ten days without purchasing any license. Let me tell you, This is totally a myth. I was working for one of our client in INDIA and They were so confident about these Ten day rules that they are under these rules. After discussing with their IT mgr, We come to the point that yes they were totally confused with this "Oracle 10 days rule". So What is Oracle 10 day rule? These "Ten Days Rule” are actually very simple. It can applies for fail-over situation and y...

HOW To GET PREPARED FOR ORACLE AUDIT Oracle Audit is like earthquake. We all have faced Oracle audit in our career. I want to share below steps those can be very helpful when you faced Audit. I will try to elaborate all points in simple and easy way. I am not saying that after reading this you will easily clear the audit but by using following steps but you may minimize the risks and time of the AUDIT. I am working from last 5 years as ORACLE APPS DBA and I know its not long time :). We need to work proactively in case of oracle AUDIT. One secret is, always keep AUDIT in your mind before implementing anything new like H/W changes. As we all know ORACLE is not having very friendly reputation e.g. you will never get a perfect solution for licencing .Many cases are there in market where sales guys sold meaning less software to costumers (ORACLE). OK that is a different story. Let's get back to the topic. Prepare your self 1. Be careful about the HARDWARE up gradation. This is very imp...

The character set determines what languages can be represented in the database. Oracle recommends using Unicode (AL32UTF8) as the database character set. AL32UTF8 is Oracle's name for the UTF-8 encoding of the Unicode standard. The Unicode standard is the universal character set that supports most of the currently spoken languages of the world. The use of the Unicode standard is indispensable for any multilingual technology, including database processing. Changing the database character set is a time consuming and complex project. Therefore, it is very important to select the right character set at installation time. If the language is American English or a Western European language, then the default character set is WE8MSWIN1252. Each Microsoft Windows ANSI Code Page can store data from only one language or a limited group of languages, such as only Western European, or only Eastern European, or only Japanese. AL32UTF8 is a multibyte character set, database operations on character...

ORA-28002: the password will expire within x days Many times we face issue of user password expiry in the DB. For this problem you can assign UNLIMITED limit to the user. This is not exactly for the user, but it’s for the profile in which your DB user exists.  You can easily change the profile of users in oracle DB. By default the profile is DEFAULT that is having unlimited limit for Password i.e  PASSWORD_LIFE_TIME  . Let’s use this in practical  For example, we have new developer joined our company and he/she needs a DB user or you can say fresher. So what happened is, he/she most of the cases she tried to login with wrong password and got DB account locked. For this case follow the following steps :- You need to connect with the sysdba privileges. SQL> conn sys/**** as sysdba SQL> alter user test identified by test account unlock; Now the 2 nd  case, we need to change the limit of our PROFILE that we have created to avoid the AUDIT issues. E.g. TEST is ...

Hi, These below are best links to clone your oracle application  You get detail in all these links . http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=24&MMN_position=13:13 Follow this one for accuracy :-- http://oracle-latest-technology.blogspot.in/2012/07/step-by-step-oracle-apps-r1213-rapid.html Please look into this. This will help you a lot:-- http://balaoracledba.com/2013/10/23/r12-2-cloning-step-by-step/ If you want a expert choice then follow this:-- http://expertoracle.com/2014/09/23/oracle-applications-ebs-r12-2-cloning-process/ Short and sipmle step to clone :-- http://prasadappsdba.blogspot.in/2013/09/clone-oracle-apps-r12-short-steps.html

Hi, It is very easy to start or stop the oracle apps r12, but as a fresher you face many issues with starting and stopping the oracle apps. So in this I will tell you the simple steps to start the oracle apps. What we must remember some rules first about starting and stopping the oracle apps. SOME RULES:-- To start oracle apps           when you start the oracle apps you must remember that start your database tier first and then start your listener and after that start your apps tier. To Stop oracle apps            When you want to stop oracle apps you have reverse  the starting process . First shutdown your app tier and then shutdown the listener and then at last shutdown the  database. You must keep these steps in mind that you must follow the rules. How to start the oracle apps:- I will tell you the step that I use  to perform to start the oracle apps on LINUX. Step...

In this, I will explain you that how we can configure our weblogic server to work on the cluster. As you all know why we need cluster, Yes you are right we do this only for high availability and scalability.  Installation of weblogic with the cluster in Multi-node architecture Note:- we have to have two machines . And please follow the following steps. Simple steps that we needed :--  1. Install WebLogic on both physical machines  2. Create the WebLogic Domain on one physical machine  3. Configure the domain by adding Managed Servers and Machines on one physical machine  4. Copy the domain file structure to the other physical machine and enroll it to the WebLogic Domain  5. Ensure that both WebLogic Machines are operational  6. Create and configure the Cluster  7. Ensure that the Cluster is operational Install WebLogic on both physical machines :-- We have to install weblogic on both machine with same middleware home . So that we can copy our...

We face many errors in oracle application in day to day activity. I am sharing some of them as may be this will help you to save time. ERROR 1 ORA-00020: maximum number of processes (200) exceeded ORA-20 errors will not be written to the alert log for the next minute. Please look at trace files to see all the ORA-20 errors.   Reason :--  we are exceeded from the defined range of the sessions. So please find the below solution for this problem. Solution :--   It is very common error that we face day to day. For this please  Increase the processes & Session in  DB e.g. alter system set processes=XXX scope=spfile;      alter system set sessions=XXX scope=spfile; And bounce the Database properly. ERROR 2 frm-92050 failed to connect to the server hostname:hostname:9000 Solution :-- Have a look at the following notes (especially the troubleshooting note): Note: 252113.1 - Login Issue Failed To Connect To The Server Frm-92050 After Specfic ...

Detail of Patches in Oracle apps As you all know, we have to apply patches very frequently .This may be on your database or for oracle application ERP. We use OPATCH to apply patches on database and ADPATCH to apply patches on oracle apps. Here I am discussing only about ADPATCH. As till now I have worked in many organizations and applied number of patches in different environments. So I am sharing my knowledge with you all. And if you find any mistake please feel free to write.  What is patch ? In simple words patches are used to fix a bug. A bug  is a defect in the code or functionality. Oracle provide solution for that particular bug known as patch.   Types of patches in oracle apps? Standalone/Oneoff patches   :--  This is used to define patch created to fix single/particular problem. Mini Pack   :--This is group of oneoff patches for a particular product like INV, GL, AP and named like 11i.GL.E ( means this group of patches con...

Cloning Oracle apps R12 I am Sunny Thakur working as Oracle apps DBA from last 3 years. I worked on many oracle product like  weblogic , OBIEE, Oracle apps and oracle database, ORACLE RMA etc. but I like Oracle apps most. I love to work on oracle apps. You can also see my previous blog about patching oracle apps  here  . The truth about oracle apps is it was a hot technology, it is hot and will remain hot. So for fresher's I will highly recommend oracle apps to take as primary skill :).  So today I am sharing my knowledge with you guys about how to clone a oracle apps . Cloning is not very easy to perform. You have to have full knowledge of oracle apps and database also. I will also discuss with you about the common errors that we face while cloning. Please follow the following steps carefully to clone your system . STEP  1 :-- Stay calm !!! Yes, while cloning don't panic at all. I know when you clone your a...

How to apply patch on EBS R12. Patching in oracle apps is very simple. We have to put application in maintains mode . This step is important .    So for this we have Eight steps:--- 1. Stop application tier. 2. Turn the maintains mode enable e.g.             i. run adadmin (for this you have to run apps env)            ii. go for 5 and after that go for 2 (1 for disable),   that will run "adsetmmd.sql" from                  $AD_TOP/patch/115/sql       3.Copy the patch to oracle user folder 4. UNZIP the patch and change directory to patch number. 5. Set the PATH for home,bin. 6.  Run "adpatch"  and go with default value and give "system" and "apps" password 7. It will prompt for drive than give the patch drive name e.g. u"patch_no".drv 8. After applying the patch turn maintenance mode disable by going through 2nd step.  ...