Hi All
Im trying to get the statpack report from a RAC environment. When I execute the report on node 2 works fine. But I node 1 I have this problem.
SQL> @spreport.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
2722185951 PRODAPX 1 prodapx_1
Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
----------- -------- ------------ ------------ ------------
2722185951 2 PRODAPX prodapx_2
2722185951 1 PRODAPX prodapx_1
Using 2,722,185,951.00 for database Id
Using 1.00 for instance number
:dbid := 2,722,185,951.00;
*
ERROR at line 2:
ORA-06550: line 2, column 25:
PLS-00103: Encountered the symbol "," when expecting one of the following:
* & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec between || multiset member submultiset
ORA-06550: line 2, column 40:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
) , * & = - + < / > at in is mod remainder not rem =>
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec between || multiset member
ORA-06550: line 4, column 4:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
following:
end not pragma final instantiable order overriding static
member constructor map
declare
*
ERROR at line 1:
ORA-20200: Database/Instance / does not exist in STATS$DATABASE_INSTANCE
ORA-06512: at line 23
Please can you help me??
Thanks in advance!!