Hi All ,
When i excute the below query on DG give the follwing error . However the same query run on same enviorment since long time . Our database release 12.1.02
ORA-16000: database or pluggable database open for read-only access
ORA-06512: at "APPS.XX_TRACE_PKG", line 38
ORA-06512: at "APPS.XX_MASTER_EMPLOYEE_INFO", line 16
ORA-06512: at "APPS.XX_MASTER_EMPLOYEE_INFO", line 1241
16000. 00000 - "database open for read-only access"
*Cause: The database has been opened for read-only access. Attempts to
modify the database using inappropriate DML or DDL statements
generate this error.
*Action: In order to modify the database, it must first be shut down and
re-opened for read-write access.
select
XX_EMPLOYEE_ASG_INFO.EMPLOYEE_NUMBER ,
XX_EMPLOYEE_ASG_INFO.OLD_HIRE_DATE ,
XX_EMPLOYEE_ASG_INFO.HIRE_DATE ,
XX_EMPLOYEE_ASG_INFO.TITLE ,
XX_EMPLOYEE_ASG_INFO.EN_FULL_NAME ,
XX_EMPLOYEE_ASG_INFO.EN_FIRST_NAME ,
XX_EMPLOYEE_ASG_INFO.EN_FATHER_NAME ,
XX_EMPLOYEE_ASG_INFO.EN_GRANDFATHER_NAME ,
XX_EMPLOYEE_ASG_INFO.EN_FAMILY_NAME ,
XX_EMPLOYEE_ASG_INFO.AR_FULL_NAME ,
XX_EMPLOYEE_ASG_INFO.AR_NAME ,
XX_EMPLOYEE_ASG_INFO.AR_FATHER ,
XX_EMPLOYEE_ASG_INFO.AR_GRANDFATHER ,
XX_EMPLOYEE_ASG_INFO.AR_FAMILY ,
XX_EMPLOYEE_ASG_INFO.EMP_EMAIL ,
XX_EMPLOYEE_ASG_INFO.ERP_USERNAME ,
XX_EMPLOYEE_ASG_INFO.NATIONALITY ,
XX_EMPLOYEE_ASG_INFO.NATIONAL_IDENTIFIER ,
XX_EMPLOYEE_ASG_INFO.MARITAL_STATUS ,
XX_EMPLOYEE_ASG_INFO.DATE_OF_BIRTH ,
XX_EMPLOYEE_ASG_INFO.AGE ,
XX_EMPLOYEE_ASG_INFO.SEX ,
XX_EMPLOYEE_ASG_INFO.WORK_TELEPHONE ,
XX_EMPLOYEE_ASG_INFO.EDUCATION_LEVEL ,
XX_EMPLOYEE_ASG_INFO.PAYROLL ,
XX_EMPLOYEE_ASG_INFO.ORGANIZATION_NAME ,
XX_EMPLOYEE_ASG_INFO.JOB_NAME ,
XX_EMPLOYEE_ASG_INFO.POSITION_NAME ,
XX_EMPLOYEE_ASG_INFO.GRADE_NAME ,
XX_EMPLOYEE_ASG_INFO.LOCATION_CODE ,
XX_EMPLOYEE_ASG_INFO.SALARY_BASIS ,
XX_EMPLOYEE_ASG_INFO.COST_CENTER ,
XX_EMPLOYEE_ASG_INFO.SERVICE_PERIOD ,
XX_EMPLOYEE_ASG_INFO.PER_EFFECTIVE_START_DATE ,
XX_EMPLOYEE_ASG_INFO.PER_EFFECTIVE_END_DATE ,
XX_EMPLOYEE_ASG_INFO.ASG_EFFECTIVE_START_DATE ,
XX_EMPLOYEE_ASG_INFO.ASG_EFFECTIVE_END_DATE ,
XX_EMPLOYEE_ASG_INFO.PERSON_ID ,
XX_EMPLOYEE_ASG_INFO.EMPLOYEE_ID ,
XX_EMPLOYEE_ASG_INFO.ASSIGNMENT_ID ,
XX_EMPLOYEE_ASG_INFO.POSITION_ID ,
XX_EMPLOYEE_ASG_INFO.JOB_ID ,
XX_EMPLOYEE_ASG_INFO.ORGANIZATION_ID ,
XX_EMPLOYEE_ASG_INFO.GRADE_ID ,
XX_EMPLOYEE_ASG_INFO.LOCATION_ID ,
XX_EMPLOYEE_ASG_INFO.PAYROLL_ID ,
XX_EMPLOYEE_ASG_INFO.PAY_BASIS_ID ,
XX_EMPLOYEE_ASG_INFO.NATIONALITY_CODE ,
XX_EMPLOYEE_ASG_INFO.OBJECT_VERSION_NUMBER ,
XX_EMPLOYEE_ASG_INFO.SPECIAL_CEILING_STEP_ID ,
XX_EMPLOYEE_ASG_INFO.PEOPLE_GROUP_ID ,
XX_EMPLOYEE_ASG_INFO.SOFT_CODING_KEYFLEX_ID ,
XX_EMPLOYEE_ASG_INFO.PERSON_TYPE_ID ,
XX_EMPLOYEE_ASG_INFO.FU_EMAIL_ADDRESS ,
XX_EMPLOYEE_INFO_T_B.P_DEPARTEMENT_NAME ,
XX_EMPLOYEE_INFO_T_B.G_DEPARTEMENT_NAME ,
XX_EMPLOYEE_ASG_INFO.EMPLOYEE_CATEGORY,
XX_EMPLOYEE_ASG_INFO.OLD_EMPLOYE_TYPE,
XX_EMPLOYEE_ASG_INFO.ATTENDANCE_TYPE
from APPS.XX_EMPLOYEE_ASG_INFO XX_EMPLOYEE_ASG_INFO,
APPS.XX_EMPLOYEE_INFO_T_B XX_EMPLOYEE_INFO_T_B;