ERPstuff - Oracle EBS Community

Hello guys If you are interested in setup RAC for 11g database on Linux platform. Here are two links, I found very useful. The new concept of Grid Infrastructure in 11gR2 makes it a bit simple to install. For 11gR2: http://www.oracle.com/technology/pub/articles/hunter-rac11gr2-iscsi.html For 11gR1: ...

Hi there

Did you make sure that ODBC connectivity is establishedt? Are you using the required driver version?

Amir

Hello

The root.sh file is created during installation and then can be found in the ORACLE_HOME directory. you can check out the contents in root.sh by
$cat root.sh.

It actually creates entries the /etc/oratab file and couple of other files.

Amir

Hello Please post the execution plan for your query and we'll see what could be done to optimize it. The pre-condition for using UNION clause is, column type must match for each corresponding column in the second query or it can be NULL. You could convert the column type in your second query, for in...

Hello

You could use NULL for each column in the second query, for example:

select first_name,last_name,hiredate,sal
from l_employees
union
select 'total ->',null,null,sum(sal)
from l_employees

Amir

Hi there

I believe that should work fine for your scenario:

SELECT ename, sal, job, hiredate
FROM emp
UNION
SELECT '__Total -> ', sum(sal), ' ',hiredate
FROM emp
group by hiredate


Amir

Hi there

This is the simplest example but it'll give you some idea:

SELECT ename, sal
FROM emp
UNION
SELECT '__Total -> ' , sum(sal)
FROM emp;

Have fun.

Hello Some drastic changes happened between 9i and 10g with DB automation to minimize the DBA manual intervention. Since the basic concepts are still same but couple of additional tools were introduced (e.g. Automatic Workload Repository AWR, in 11g some extra views are provided to enhance baseline ...

Thanks for appreciation. That's our main objective to elaborate the concepts in easy going way instead of using difficult definitions from patent documentation.

Amir

Hi

Plz check out the URLs below for the detail insight.

http://www.dba-oracle.com/t_differences_9i_10g.htm
http://download-east.oracle.com/docs/cd ... 14/toc.htm
http://download-east.oracle.com/docs/cd ... 31/toc.htm

Amir

Hi

Did you try the code below:

dbms_output.put_line('PLSQL Rows = '||TO_CHAR(SQL%ROWCOUNT));


Amir

Hi Arvin The main difference is disaster recovery time. The RAC is expensive Active Active solution (both nodes available at a time) which provide the immediate fail over solution. While Dataguard is Active Passive (one node is available at a time). Another difference is DataGurad sites can be physi...

Hello

It looks like your file got corrupted. Did you move it from different server then try to match the check sum with the command below from source and destination files are same.

md5sum myfile

Regards
Amir

<font color="maroon">Apparently B and C are the correct choices. But "C" is also true for SALES db as well that's using LMT as a default.

"E" is not a correct answer, SALES db is by default creating LMT.

Amir
</font id="maroon">

Each control file has header information of the datafiles and SCN (system change number). If they are not matching with each other then it realize that something is missing. It asks for archive logs to apply all changes to the data file to make the SCN synchronize with control file SCN.

Regards
Amir