OCI : How To Backup Database In OCI (Oracle Cloud Infrastructure) Virtual Machine & Bare Metal DB System

 

OCI : How To Backup Database In OCI (Oracle Cloud Infrastructure) Virtual Machine & Bare Metal DB System (Doc ID 2707577.1)

ERROR: ORA-44787: Service cannot be switched into. - 19c DB with R12.2.10

 Issue 

ERROR:

ORA-44787: Service cannot be switched into.

Sol:

QL> show con_name

 

CON_NAME

------------------------------

CDB$ROOT

SQL> alter pluggable database <PDNAME> close immediate;

 Pluggable database altered.

 SQL> alter pluggable database <PDNAME> open;

 Pluggable database altered.

You can then change the container without receiving this error.

SQL> alter session set container=<PDNAME>;

Session altered.

Create a clone instance from ExaCS database backup

 

Create a clone instance from ExaCS database backup (Doc ID 2703923.1)

Required Diagnostic Data Collection for RMAN Issues

 

SRDC - Required Diagnostic Data Collection for RMAN Issues (Doc ID 1671431.1)

Autonomous Health Framework (AHF) - Including TFA and ORAchk/EXAchk (Doc ID 2550798.1)

Upgrading Oracle Database 11g to 19c with Oracle E-Business Suite Release 12.2 on Oracle Exadata Cloud Services

 Upgrading Oracle Database 11g to 19c with Oracle E-Business Suite Release 12.2 on Oracle Exadata Cloud Services (Doc ID 2567103.1)

Migrating and Upgrading Oracle Database 11g to Oracle Database 19c for Oracle E-Business Suite Release 12.1 on OCI VM DB Systems

 

Migrating and Upgrading Oracle Database 11g to Oracle Database 19c for Oracle E-Business Suite Release 12.1 on OCI VM DB Systems (Doc ID 2758990.1)

19c with R12.2 clone doc ID's

 

Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1)

Using Oracle 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.2 (Doc ID 2530665.1)

19c Database with Oracle E-Business Suite R12 Known Issues & Solutions (Doc ID 2662860.1)

Business Continuity for Oracle E-Business Release 12.1 Using Oracle 11g Release 2 Physical Standby Database (Doc ID 1070033.1)

Example Manual Migration of Oracle E-Business Suite Release 12.2 with Oracle Database 19c to VM DB Systems and Compute Cloud Service in Oracle Cloud Infrastructure (Doc ID 2743151.1)

Data Gaurd setup--

-For AD/TXK 9 above , we can use logical names.

Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Logical Host Names (Doc ID 2617788.1)

Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Physical Host Names (Doc ID 2617787.1)

To keep /etc/hosts permanent after adding enry

 chattr -R +i /etc/hosts

 

chattr -i /etc/hosts

OEM 13.5 -Tuning Advisor giving ORA-01031: insufficient privileges - with DBSNMP user

Sol : (Replace XXXX with DBSNMP in my case or change accordingly)

GRANT OEM_ADVISOR TO XXXX;

GRANT CONNECT TO XXXX;

GRANT OEM_MONITOR TO XXXX;

ALTER USER XXXX DEFAULT ROLE OEM_ADVISOR, OEM_MONITOR;

GRANT CREATE SESSION TO XXXX;

GRANT SELECT ANY DICTIONARY TO XXXX;

GRANT ADMINISTER SQL TUNING SET TO XXXX;

GRANT EXECUTE ON SYS.DBMS_WORKLOAD_REPOSITORY TO XXXX;

------------

Issue :

---------Run below queries to confirm the issue

---Use DBSNMP user to connect and run below  , replace sql_id with latest from your environment.

1) 

SET SERVEROUTPUT ON

declare

stmt_task VARCHAR2(40);

begin

stmt_task := DBMS_SQLTUNE.CREATE_TUNING_TASK(

sql_id => '6xdyxvdxkmuj3',

scope => DBMS_SQLTUNE.scope_comprehensive,

time_limit => 10000, --<<< number of seconds

task_name => '6xdyxvdxkmuj3_tuning_task',

description => 'Tuning task for statement 6xdyxvdxkmuj3');

DBMS_OUTPUT.put_line('task_id: ' || stmt_task );

end;

/

****

BEGIN

DBMS_SQLTUNE.EXECUTE_TUNING_TASK( task_name => '6xdyxvdxkmuj3_tuning_task');

end;

/

-- See the suggestions of the TUNING TASK.

SET LONG 100000

SET LONGCHUNKSIZE 1000

SET LINESIZE 200

set pagesize 500

--***************************

--TO GET DETAILED INFORMATION

--***************************

SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK('1djr35t9304ns_tuning_task','TEXT','ALL','ALL') FROM DUAL;

###>>>>>Check the results of the detailed query. <<<<<###

SQL> SET LONG 100000

SET LONGCHUNKSIZE 1000

SET LINESIZE 200

set pagesize 500

SQL>

SQL> SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK('6xdyxvdxkmuj3_tuning_task','TEXT','ALL','ALL') FROM DUAL;

DBMS_SQLTUNE.REPORT_TUNING_TASK('6XDYXVDXKMUJ3_TUNING_TASK','TEXT','ALL','ALL')

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

GENERAL INFORMATION SECTION

-------------------------------------------------------------------------------

Tuning Task Name : 6xdyxvdxkmuj3_tuning_task

Tuning Task Owner : DBSNMP

Tuning Task ID : 375975

Workload Type : Single SQL Statement

Execution Count : 1

Current Execution : EXEC_343213

Execution Type : TUNE SQL

Scope : COMPREHENSIVE

Time Limit(seconds): 10000

Completion Status : COMPLETED

Started at : 10/20/2021 08:35:54

Completed at : 10/20/2021 08:35:56

-------------------------------------------------------------------------------

Schema Name: APPS

SQL ID : 6xdyxvdxkmuj3

SQL Text : SELECT

'PO' PO_RELEASE_FLAG,

POH.CLM_DOCUMENT_NUMBER PO_NUM,

POHA.ACCEPTANCE_DUE_DATE,

POH.APPROVED_DATE,

NVL(POH.AUTHORIZATION_STATUS,'INCOMPLETE')

AUTHORIZATION_STATUS,

POH.CLOSED_DATE,

POHA.COMMENTS,

POH.FIRM_DATE,

POH.NOTE_TO_AUTHORIZER,

POH.NOTE_TO_RECEIVER,

POH.NOTE_TO_VENDOR,

POH.PRINT_COUNT,

POH.PRINTED_DATE,

POH.RATE,

POH.RATE_DATE,

POH.RATE_TYPE,

POH.REVISED_DATE,

POH.REVISION_NUM,

POH.AGENT_ID,

POH.BILL_TO_LOCATION_ID,

POH.FROM_HEADER_ID,

POH.PO_HEADER_ID,

POH.SHIP_TO_LOCATION_ID,

POH.TERMS_ID,

POH.VENDOR_CONTACT_ID,

POH.VENDOR_ID,

POH.VENDOR_SITE_ID,

NVL(POH.CLOSED_CODE, 'OPEN') CLOSED_CODE,

POH.CURRENCY_CODE,

NVL(POH.FIRM_STATUS_LOOKUP_CODE,'N')

FIRM_STATUS_LOOKUP_CODE,

POH.FOB_LOOKUP_CODE,

POH.FREIGHT_TERMS_LOOKUP_CODE,

POH.SHIP_VIA_LOOKUP_CODE,

POH.TYPE_LOOKUP_CODE,

POCR.REQUEST_LEVEL (+)= 'HEADER' AND

POCR.CHANGE_ACTIVE_FLAG (+)= 'Y'

-------------------------------------------------------------------------------

ERRORS SECTION

-------------------------------------------------------------------------------

- ORA-01031: insufficient privileges

----------------------------------------------------

VNC Server Installation commands - OEL Linux 7

 From root user

yum -y install tigervnc-server pixman pixman-devel libXfont

yum install xorg-x11-fonts*

yum install tigervnc-server matchbox-window-manager xterm xorg-x11-fonts-misc.noarch

yum install xclock

ASMCMD - /u01/app/19.0.0/grid/bin/kfod.bin: No such file or directory

-->as oracle user

$ asmcmd
/u01/grid/product/19.0.0/bin/kfod: line 22: /u01/app/19.0.0/grid/bin/kfod.bin: No such file or directory
Use of uninitialized value $result[0] in scalar chomp at /u01/grid/product/19.0.0/lib/asmcmdbase.pm line 5982.
Use of uninitialized value $result[0] in split at /u01/grid/product/19.0.0/lib/asmcmdbase.pm line 5985.
Use of uninitialized value $clus_mode in scalar chomp at /u01/grid/product/19.0.0/lib/asmcmdbase.pm line 5987.
Use of uninitialized value $clus_mode in concatenation (.) or string at /u01/grid/product/19.0.0/lib/asmcmdbase.pm line 5988.
Use of uninitialized value $clus_mode in string eq at /u01/grid/product/19.0.0/lib/asmcmdbase.pm line 5993.
Use of uninitialized value $clus_mode in string eq at /u01/grid/product/19.0.0/lib/asmcmdbase.pm line 6030.
Use of uninitialized value $clus_mode in string eq at /u01/grid/product/19.0.0/lib/asmcmdbase.pm line 6080.
Use of uninitialized value $clus_mode in string eq at /u01/grid/product/19.0.0/lib/asmcmdbase.pm line 6080.
Use of uninitialized value $clus_mode in string eq at /u01/grid/product/19.0.0/lib/asmcmdbase.pm line 6080.
Use of uninitialized value $clus_mode in string eq at /u01/grid/product/19.0.0/lib/asmcmdbase.pm line 6156.
Use of uninitialized value $clus_mode in string eq at /u01/grid/product/19.0.0/lib/asmcmdbase.pm line 6190.
Use of uninitialized value $clus_mode in string eq at /u01/grid/product/19.0.0/lib/asmcmdbase.pm line 6190.
ASMCMD> exit 

Solution : 

vi /u01/grid/product/19.0.0/bin/kfod

 

and correct OHOME to the correct value.

--------------------------

OHOME=/u01/grid/product/19.0.0
ORACLE_HOME=${OHOME}
export ORACLE_HOME

exec $OHOME/bin/kfod.bin "$@"
 ------------------

 /u01/app/19.0.0/grid
ls: cannot access /u01/app/19.0.0/grid: No such file or directory

 vi /u01/grid/product/19.0.0/bin/kfod
$ asmcmd
ASMCMD> exit

now ASMCMD working fine.

Blocking Lock - scripts

 1) To find out lock for big long running sql during upgrade

SELECT s1.username || '@' || s1.machine || ' ( SID=' || s1.sid || ' )
is blocking ' || s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status FROM v$lock l1,
v$session s1, v$lock l2, v$session s2
WHERE s1.sid=l1.sid AND s2.sid=l2.sid
AND l1.BLOCK=1 AND l2.request > 0 AND l1.id1 = l2.id1 AND l1.id2 = l2.id2;

Form compilation error While Performing Compilation for CLL product 1213

As the CLL product version is out of date, the recommendation is to upgrade to the latest version - CLL.D.4. This would probably correct all CLL forms pointed out with errors.

Please let me know if an upgrade is not in the short-term plans that I will be reviewing the objects pointed out with a compilation error for the forms, compare them with their current versions, and indicate the next action plans for treatment.

Otherwise, refer to Doc ID 2413397.1 - "LAD Add-on Localizations - R12.1: CLL Minipack D.4 installation Instructions", to have a guide of the technical installation procedures of the CLL products actions.

-----------------------------------------------------

now form was compiled without error.

Created form file /u01/oracle/SID/apps/apps_st/appl/cll/12.0.0/forms/US/CLLUPRSG.fmx

ACTION PLAN
============
1. Connect into application tier as APPLMGR ID and execute:

cd $CLL_TOP/sql
sqlplus apps/<apps_password>
@CLLTUPSS.pls
@CLLTUPSB.pls

export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US:$AU_TOP/resource/US

frmcmp_batch module=$AU_TOP/forms/US/CLLUPRSG.fmb userid=apps/<apps_password> module_type=form batch=no compile_all=special output_file=$CLL_TOP/forms/US/CLLUPRSG.fmx

cp $CLL_TOP/forms/US/CLLUPRSG.fmx $CLL_TOP/forms/ZHS/CLLUPRSG.fmx

-----------------------

==> form_comp2.txt:

================

Sequence CLL_F406_RESG_MIN_AMOUNT_S does not exist in CLL schema.

Creating the Sequence in schema CLL.

Creating synonym CLL_F406_RESG_MIN_AMOUNT_S for CLL.CLL_F406_RESG_MIN_AMOUNT_S

Synonym created

Sequence CLL_F406_RESG_PARAMETERS_S does not exist in CLL schema.

Creating the Sequence in schema CLL.

Creating synonym CLL_F406_RESG_PARAMETERS_S for CLL.CLL_F406_RESG_PARAMETERS_S

Synonym created

----------------------------------------------------

1. Connect into application tier as APPLMGR ID and execute:

[ please, replace <apps_password> and <hostname>:<DB_Port>:<SID> ]

adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp CLL CLL APPS <apps_password> THIN <hostname>:<DB_Port>:<SID> sequence $CLL_TOP/patch/115/xdf/cll_f406_resguardo_min_amount.xdf $FND_TOP/patch/115/xdf/xsl

adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp CLL CLL APPS <apps_password> THIN <hostname>:<DB_Port>:<SID> sequence $CLL_TOP/patch/115/xdf/cll_f406_resguardo_parameters.xdf $FND_TOP/patch/115/xdf/xsl


export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US:$AU_TOP/resource/US

frmcmp_batch module=$AU_TOP/forms/US/CLLUPRSG.fmb userid=apps/<apps_password> module_type=form batch=no compile_all=special output_file=$CLL_TOP/forms/US/CLLUPRSG.fmx

cp $CLL_TOP/forms/US/CLLUPRSG.fmx $CLL_TOP/forms/ZHS/CLLUPRSG.fmx

-----------------------------------------

/* SQL 007 - sequences*/
select owner, object_name, object_type, status
from dba_objects
where object_name in ('CLL_F406_RESG_MIN_AMOUNT_S','CLL_F406_RESG_PARAMETERS_S');

no rows selected

===========

1. Connect into application tier as APPLMGR ID and execute:

[ please, replace <apps_password> and <hostname>:<DB_Port>:<SID> ]

adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp CLL CLL APPS <apps_password> THIN <hostname>:<DB_Port>:<SID> table $CLL_TOP/patch/115/xdf/cll_f406_resguardo_min_amount.xdf $FND_TOP/patch/115/xdf/xsl

adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp CLL CLL APPS <apps_password> THIN <hostname>:<DB_Port>:<SID> table $CLL_TOP/patch/115/xdf/cll_f406_resguardo_parameters.xdf $FND_TOP/patch/115/xdf/xsl

export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US:$AU_TOP/resource/US

frmcmp_batch module=$AU_TOP/forms/US/CLLUPRSG.fmb userid=apps/<apps_password> module_type=form batch=no compile_all=special output_file=$CLL_TOP/forms/US/CLLUPRSG.fmx

cp $CLL_TOP/forms/US/CLLUPRSG.fmx $CLL_TOP/forms/ZHS/CLLUPRSG.fmx

--------------------------------------------------------------------

1. Connect into application tier as APPLMGR ID and execute:

adident Header $CLL_TOP/patch/115/xdf/cll_f406_resguardo_min_amount.xdf

 adident Header $CLL_TOP/patch/115/xdf/cll_f406_resguardo_min_amount.xdf

/u01/oracle/SID/apps/apps_st/appl/cll/12.0.0/patch/115/xdf/cll_f406_resguardo_min_amount.xdf:
$Header cll_f406_resguardo_min_amount.xdf 120.0 2017/11/08 22:18:31 fmaurici noship $

$ adident Header $CLL_TOP/patch/115/xdf/cll_f406_resguardo_parameters.xdf
/u01/oracle/SID/apps/apps_st/appl/cll/12.0.0/patch/115/xdf/cll_f406_resguardo_parameters.xdf:
$Header cll_f406_resguardo_parameters.xdf 120.0 2017/11/08 22:19:35 fmaurici noship $
adident Header $CLL_TOP/patch/115/xdf/cll_f406_resguardo_parameters.xdf


2. Connect into database as APPS ID, execute the SQLs and send us the results:

/* SQL 005 - cll_f406_resguardo_min_amount */
select owner, object_name, object_type, status
from dba_objects
where object_name = 'CLL_F406_RESGUARDO_MIN_AMOUNT';

no rows selected

/* SQL 006 - cll_f406_resguardo_parameters*/
select owner, object_name, object_type, status
from dba_objects
where object_name = 'CLL_F406_RESGUARDO_PARAMETERS';

no rows selected

----------------------------------------------------

adident Header $AU_TOP/forms/US/CLLUPRSG.fmb

/u01/oracle/SID/apps/apps_st/appl/au/12.0.0/forms/US/CLLUPRSG.fmb:
$Header CLLUPRSG.fmb 120.2 2017/11/09 16:33 fmaurici ship $
$Header APPSTAND.fmb 120.6.12010000.16 2013/05/16 09:02 dbowles ship $
$Header APPSTAND.fmb 120.6.12010000.16 2013/05/16 09:02 dbowles ship $
$Header CLLUPRSG.fmb 120.2 2017/11/09 16:33 fmaurici ship $
$Header CLLUPRSG.fmb 120.2 2017/11/09 16:33 fmaurici ship $

adident Header $AU_TOP/forms/ZHS/CLLUPRSG.fmb
/u01/oracle/SID/apps/apps_st/appl/au/12.0.0/forms/ZHS/CLLUPRSG.fmb:
$Header CLLUPRSG.fmb 120.2 level:-99999 2018/12/14 03:55:58 pkm ship $
$Header APPSTAND.fmb 120.6.12010000.16 2013/05/16 09:02 dbowles ship $
$Header APPSTAND.fmb 120.6.12010000.16 2013/05/16 09:02 dbowles ship $
$Header CLLUPRSG.fmb 120.2 level:-99999 2018/12/14 03:55:58 pkm ship $
$Header CLLUPRSG.fmb 120.2 level:-99999 2018/12/14 03:55:58 pkm ship $

frmcmp_batch userid=apps/*** module=/u01/oracle/SID/apps/apps_st/appl/au/12.0.0/forms/ZHS/CLLUPRSG.fmb output_file=/u01/oracle/SID/apps/apps_st/appl/cll/12.0.0/forms/ZHS/CLLUPRSG.fmx

==> CLL_FORMS_ERROR.xls:
========================
OBJECT_NAME TYPE File Version Sequence Line Position Error Text
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 1 380 17 PL/SQL: ORA-00904: "SUB_FAMILY_CODE": invalid identifier
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 3 500 36 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 5 501 38 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 7 517 54 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 9 535 60 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 11 582 118 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 13 583 64 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 15 666 37 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 16 666 50 PL/SQL: ORA-00984: column not allowed here

CLL_F035_CPY_TRX_COD_XML Package Body cll_f035_ctcb.pls - 120.3.12010000.2 17 650 22 PL/SQL: SQL Statement ignored

--------------------------------------

1. Connect into database as APPS ID, execute the SQLs and send us the results:

/* SQL 001 - EBS version */
select release_name release
from apps.fnd_product_groups;

RELEASE
--------------------------------------------------
12.1.3

/* SQL 002 - DB version */
select instance_name, host_name, version
from v$instance;

INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
VERSION
-----------------
instancename
hostname
19.0.0.0.0

/* SQL 003 - CLL product */
SELECT patch_level
FROM fnd_product_installations
WHERE patch_level LIKE '%CLL%';

PATCH_LEVEL
------------------------------
R12.CLL.D.2

/* SQL 004 - Invalid objects */ =====> please, upload the results of this SQL in spreadsheet (.xls) format:
SELECT a.object_name,
        decode(a.object_type,
          'PACKAGE', 'Package Spec',
          'PACKAGE BODY', 'Package Body',
          a.object_type) type,
        (
          SELECT ltrim(rtrim(substr(substr(c.text, instr(c.text,'Header: ')),
            instr(substr(c.text, instr(c.text,'Header: ')), ' ', 1, 1),
            instr(substr(c.text, instr(c.text,'Header: ')), ' ', 1, 2) -
            instr(substr(c.text, instr(c.text,'Header: ')), ' ', 1, 1)
            ))) || ' - ' ||
            ltrim(rtrim(substr(substr(c.text, instr(c.text,'Header: ')),
            instr(substr(c.text, instr(c.text,'Header: ')), ' ', 1, 2),
            instr(substr(c.text, instr(c.text,'Header: ')), ' ', 1, 3) -
            instr(substr(c.text, instr(c.text,'Header: ')), ' ', 1, 2)
            )))
          FROM dba_source c
          WHERE c.owner = a.owner
          AND   c.name = a.object_name
          AND   c.type = a.object_type
          AND   c.line = 2
          AND   c.text like '%$Header%'
        ) "File Version",
        b.sequence "Sequence",
      b.line "Line",
      b.position "Position",
        b.text "Error Text"
 FROM dba_objects a,
      dba_errors b
 WHERE a.object_name = b.name(+)
 AND a.object_type = b.type(+)
 AND a.owner IN ('APPS','CLL')
 AND a.status = 'INVALID'
 ORDER BY 1, 4, 5;

-------------------Error--------------------------------

Form compilation error While Performing Compilation for CLL product

Problem Description
---------------------------------------------------
ERROR:-

Compiling package body CLL_F406_RESG_MIN_AMOUNT_V...
Compilation error on package body CLL_F406_RESG_MIN_AMOUNT_V:
PL/SQL ERROR 201 at line 10, column 18
identifier 'CLL_F406_RESGUARDO_MIN_AMOUNT' must be declared
PL/SQL ERROR 0 at line 10, column 18

-------------------------- Error----------------------

compilation failed with below error.Attached complete log.

Compiling package body CLL_F406_RESG_MIN_AMOUNT_V...
Compilation error on package body CLL_F406_RESG_MIN_AMOUNT_V:
PL/SQL ERROR 201 at line 146, column 18
identifier 'CLL_F406_RESG_MIN_AMOUNT_S.NEXTVAL' must be declared
PL/SQL ERROR 0 at line 146, column 11
SQL Statement ignored
PL/SQL ERROR 201 at line 175, column 7
identifier 'CLL_F406_RESGUARDO_PKG.DML_CLL_F406_RESG_MIN_AMOUNT_P' must be declared
PL/SQL ERROR 0 at line 175, column 7
Statement ignored

Compiling package specification CLL_F406_RESG_PARAMETERS_V...
No compilation errors.

Compiling package body CLL_F406_RESG_PARAMETERS_V...
Compilation error on package body CLL_F406_RESG_PARAMETERS_V:
PL/SQL ERROR 201 at line 120, column 18
identifier 'CLL_F406_RESG_PARAMETERS_S.NEXTVAL' must be declared
PL/SQL ERROR 0 at line 120, column 11
SQL Statement ignored
PL/SQL ERROR 201 at line 148, column 7
identifier 'CLL_F406_RESGUARDO_PKG.DML_CLL_F406_RESG_PARAMETERS_P' must be declared
PL/SQL ERROR 0 at line 148, column 7
Statement ignored

Compiling package specification CLL_F406_RESG...
No compilation errors.

Compiling package body CLL_F406_RESG...
No compilation errors.

Compiling package specification CTRL...
No compilation errors.

Compiling package body CTRL...
No compilation errors.


Compilation errors have occurred.