2/15/22, 6:37 PM SR Detail
SR 3-28589834851 : CTXSYS is missing after upgrade
Severity 1-Critical Status Solution Offered
Escalation Status Never Escalated Opened Feb 13, 2022 12:17 PM (Sunday)
Last Updated Feb 15, 2022 3:07 PM (3+ hours ago)
2_text_install.txt, bde_chk_cbo.log,
bde_chk_cbo_report.html,
Bug Reference No Related Bugs Attachments db_upg_diag_POC1_08_Feb_2022_0150.log,
db_upg_diag_POC1_11_Feb_2022_0354.log,
[Link], text_install.txt, [Link]
Related Articles No Related Articles Related SRs No Related SRs
Support Identifier 99930220851761
Account Name 株式会社東芝
Primary Contact Manoj Kumar Alternate Contact
System Host No Related Hosts
Product Oracle E-Business Suite Technology Stack
Product Version 12.1.3
Operating System Oracle Solaris on SPARC (64-bit) OS Version 10
Problem Description CTXSYS is missing after upgrade
History
ODM Action Plan Oracle Support- Feb 15, 2022 3:07 AM (15+ hours ago)
Even though this document is prepared for migration situation,
What To Do After A Migration To Linux And The AD_CTX_DDL Package Is Missing (Doc ID 1917695.1)
the solution is applicable to any such situation, could you please test this ?
Notes Oracle Support- Feb 14, 2022 11:36 PM (19+ hours ago)
Dear Customer,
Your Service Request is reassigned to me, Please allow me a brief moment to review the issue and get back to you.
The following note can enhance your experience with Global Customer Services:
Note: 166650.1 : Working Effectively With Support.
Thank you,
Vandana
Oracle Customer Support
EBS - ATG
Transfer Oracle Support- Feb 14, 2022 10:50 PM (19+ hours ago)
CTC OBSERVATION
-----------------------------
Currently the owning ATG Engineer is OFF SCHEDULE, therefore reassigning SR to current shift.
Call - Inbound Oracle Support- Feb 14, 2022 10:43 PM (19+ hours ago)
Call - Inbound
----------------------------
Customer contact: Primary
Verify preferred method of contact: PHONE OR My Oracle Support customer portal
Comments for this update: The customer is requesting an update from an available engineer.
ACTION PLAN
To engage with the appropriate team.
Thank you.
Abraham
Oracle Global Customer Support
Call - Inbound Oracle Support- Feb 14, 2022 10:38 PM (19+ hours ago)
Call - Inbound Oracle Support- Feb 14, 2022 10:36 PM (19+ hours ago)
Update from Customer MANOJ.KUMAR5@[Link]- Feb 14, 2022 7:34 PM
(23+ hours ago)
any update ?
Update from Customer MANOJ.KUMAR5@[Link]- Feb 14, 2022 4:31 PM
(Monday)
any update ?
Update from Customer MANOJ.KUMAR5@[Link]- Feb 14, 2022 2:59 PM
(Monday)
can we use below doc ??
Prepare a target database instance - Set CTXSYS parameter Giving Error PLS-00201: identifier 'CTXSYS.CTX_ADM' must be declared (Doc ID
2387341.1)
Update from Customer MANOJ.KUMAR5@[Link]- Feb 14, 2022 2:57 PM
(Monday)
[Link] 1/9
2/15/22, 6:37 PM SR Detail
SQL> /
Component Version Status
-------------------------------------------- ----------------- -----------------
Oracle Expression Filter [Link].0 VALID
Oracle Application Express [Link].08 VALID
Oracle Data Mining [Link].0 VALID
Oracle XML Database [Link].0 INVALID
OLAP Catalog [Link].0 VALID
Spatial [Link].0 INVALID
Oracle Database Catalog Views [Link].0 VALID
Oracle Database Packages and Types [Link].0 VALID
Oracle Real Application Clusters [Link].0 INVALID
JServer JAVA Virtual Machine [Link].0 VALID
Oracle Database Java Packages [Link].0 VALID
Oracle XDK [Link].0 VALID
OLAP Analytic Workspace [Link].0 VALID
13 rows selected.
SQL>
Update from Customer MANOJ.KUMAR5@[Link]- Feb 14, 2022 2:54 PM
(Monday)
scripts execution went successfull, but we are getting mentioned error, while executing step 20 in below notes.
Interoperability Notes EBS 12.0 and 12.1 with Database 11gR2 (Doc ID 1058763.1)
Update from Customer MANOJ.KUMAR5@[Link]- Feb 14, 2022 2:52 PM
(Monday)
we are getting below error while executing
Connected to:
Oracle Database 11g Enterprise Edition Release [Link].0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');
BEGIN ctxsys.ctx_adm.set_parameter('file_access_role', 'public'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'CTXSYS.CTX_ADM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SQL>
Notes Oracle Support- Feb 13, 2022 11:03 PM (Sunday)
Hello Manoj -
Thanks for giving us the current status,
I look forward to your next update.
Regards,
Gbenga
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 10:43 PM
(Sunday)
Please ignore those files as we set new CTXSYS password as per log.
Give you an update soon
Thanks & Regards,
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 10:18 PM
(Sunday)
Upload to TDS successful for the file 2_text_install.txt.
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 10:17 PM
(Sunday)
Upload to TDS successful for the file text_install.txt.
ODM Action Plan Oracle Support- Feb 13, 2022 9:56 PM (Sunday)
Hello Manoj -
[Link] 2/9
2/15/22, 6:37 PM SR Detail
Thanks for the continued patience.
CTXSYS is missing could be caused by different issues.
1. Missing required privileges
2. Invalid Objects
3. missing PUBLIC SYNONYM ANYDATA
Please review and execute the following:
SQL> connect SYS/password as SYSDBA
SQL> spool text_install.txt
SQL> @?/ctx/admin/[Link] change_on_install SYSAUX TEMP NOLOCK
Where:
change_on_install - is the ctxsys user password
SYSAUX - is the default tablespace for ctxsys
TEMP - is the temporary tablespace for ctxsys
LOCK|NOLOCK - ctxsys user account will be locked or not
2. The next step is to install appropriate language-specific default preferences.
SQL> connect "CTXSYS"/"change_on_install"
SQL> @?/ctx/admin/defaults/[Link] "AMERICAN";
SQL> connect SYS/password as SYSDBA
SQL> alter user ctxsys account lock password expire;
SQL> spool off
Regards,
Gbenga
ODM Research Oracle Support- Feb 13, 2022 9:46 PM (Sunday)
-- Search --
Note: This is INTERNAL ONLY research. No action should be taken by the customer on this information. This is research only, and may NOT be
applicable to your specific situation.
Searched on:
Oracle Text Component Invalid Due TO Missing Synonym ANYDATA (Doc ID 2763035.1)
Manual Deinstallation, Installation of Oracle Text in a Multitenant Database (Doc ID 2797324.1)
Required privileges are missing. Please ensure you have SELECT privilege to CTXSYS objects with EM 12c And Text Manager (Doc ID
1951798.1)
Notes Oracle Support- Feb 13, 2022 8:13 PM (Sunday)
Hi ,
Your SR was transferred to me. My name is Alex and I will be helping you with your issue.
I am currently reviewing the issue and will update the SR as soon as I have completed the initial investigations referring the SR history.
Thank you for your patience and cooperation
Kind Regards,
Alex.
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 7:44 PM
(Sunday)
1. CUSTOMER CONTACT INFORMATION
---------------------------------------------------------
See Additional Contacts activity.
** Customer's Management contact name: Manoj Kumar
** Customer's Management contact number: +91-8074744184
** Customer's Management E-mail Address: manoj.kumar5@[Link]
** Primary Customer contact name: Manoj Kumar
** Primary Customer contact number: +91-8074744184
** Primary Customer E-mail Address: manoj.kumar5@[Link]
** Primary Customer Contact Method: Email
** Secondary Customer contact name: Manoj Kumar
** Secondary Customer contact number: +91-8074744184
** Alternate Contact Number: +91-8074744184
** Secondary Customer E-mail Address: manoj.kumar5@[Link]
2. INITIAL TECHNICAL & BUSINESS IMPACT
a. Please describe the business impact: (document customer impact, i.e. - customer system down, interoperability impact)
--> Go-Live dates are approaching
[Link] 3/9
2/15/22, 6:37 PM SR Detail
b. Do you have a Complete Loss of Service?
--> Yes
c. Is this a Test or Production Environment?
--> Test
d. Is there a workaround?
--> No
ODM Action Plan Oracle Support- Feb 13, 2022 7:35 PM (Sunday)
Please provide the following information:
1. CUSTOMER CONTACT INFORMATION
---------------------------------------------------------
See Additional Contacts activity.
2. INITIAL TECHNICAL & BUSINESS IMPACT
a. Please describe the business impact: (document customer impact, i.e. - customer system down, interoperability impact)
b. Do you have a Complete Loss of Service?
c. Is this a Test or Production Environment?
d. Is there a workaround?
Call - Inbound Oracle Support- Feb 13, 2022 7:35 PM (Sunday)
Call - Inbound
----------------------------
Customer contact: <Primary>
Comments for this update: The user called and asked to have the SR severity increased back to 1 24x7.
ACTION PLAN
--------------------
I am increasing the severity. The user agreed to update the SR with the technical and business impact details.
Thank you.
Radu
Oracle Global Customer Support
Call - Inbound Oracle Support- Feb 13, 2022 7:31 PM (Sunday)
Call - Inbound Oracle Support- Feb 13, 2022 4:38 PM (Sunday)
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 3:57 PM
(Sunday)
Hi,
Please understand our concern and make this Sev-1 as we have deadlines to finish this tasks
Thanks & Regards
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 3:56 PM
(Sunday)
Upload to TDS successful for the file bde_chk_cbo_report.html.
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 3:56 PM
(Sunday)
Upload to TDS successful for the file bde_chk_cbo.log.
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 3:47 PM
(Sunday)
Hi,
1) we are at step no 13. upgrade the database instance
2) We are at Step 28: Upgrading Database to 11gR2 in the doc id: 837570.1
3) Upload the required log soon
fyi... We are not yet planned which db version to go as if now we planned to go with 19.6 of everything is finished on time we will go to 19.14
latest version.
Thanks & Regards,
Proactive Monitoring Update Oracle Support- Feb 13, 2022 2:08 PM (Sunday)
Dear Customer,
After reviewing the business impact of your Service Request and aligning it with our severity definitions, your SR has been set to a Severity 2.
A Severity 2 indicates that you are experiencing a severe loss of service and we will work with urgency to resolve your issue.
If this requirement changes please call Oracle Support asking to reevaluate the severity on this Service Request.
The Support numbers for each country are listed on the following website [Link]
[Link] 4/9
2/15/22, 6:37 PM SR Detail
In your next update, please include your preference for the time zone where you would like to continue working this issue,along with your
feedback to the previously requested action plan.
Thank you,
Bapu
Manager
Oracle Support
Noted Links:
Business Impact Guidelines Section 9:
[Link]
Support numbers for each country: [Link]
ODM Action Plan Oracle Support- Feb 13, 2022 1:47 PM (Sunday)
-------------------- ACTION PLAN DETAILS BELOW---------------------
Owner (Who)
------------------------------------------------------
Manoj
Follow-up (When)
------------------------------------------------------
13-Feb-202
ACTION PLAN (What, Why)
-------------------------------------------------------
1)
Please confirm exactly at which step you are at in the upgrade document Doc ID 1058763.1
2)
Please share top level step performed as a part of upgrade
3)
Please refer and share the BDE checks
Refer to note: bde_chk_cbo.sql - EBS initialization parameters - Healthcheck ( Doc ID 174605.1 )
4)
As per one of your update I see that you are only planning to upgrade db to 19.6 which is not sufficient. As you are still in first iteration and in
planning phase. Please make sure to upgrade DB to either to 19.14 or 19.13
Regards
Sindhuja
ODM Issue Clarification Oracle Support- Feb 13, 2022 1:22 PM (Sunday)
On : 12.1.3 version, Database for Application Technology
post upgrading DB to [Link] CTXSYS user is missing
ACTUAL BEHAVIOR
---------------
CTXSYS is missing
EXPECTED BEHAVIOR
-----------------------
CTXSYS USER should be present
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. upgrading DB to [Link] following Doc ID 1058763.1
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete upgrade
ODM Data Collection Oracle Support- Feb 13, 2022 1:20 PM (Sunday)
db_upg_diag_POC1_11_Feb_2022_0354.log (73.63 KB) (13-Feb-2022 07:02:46 AM)
=======================================================
================
[Link] 5/9
2/15/22, 6:37 PM SR Detail
Default and Temporary Tablespaces By User
================
USERNAME TEMPORARY_TABLESPACE DEFAULT_TABLESPACE
---------------------------- ---------------------- ----------------------
SYSTEM TEMP SYSTEM
OUTLN TEMP SYSTEM
DBSNMP TEMP SYSTEM
SYS TEMP SYSTEM
AHL TEMP APPS_TS_TX_DATA
ORDPLUGINS TEMP SYSTEM
MDSYS TEMP1 SYSAUX
AHM TEMP APPS_TS_TX_DATA
AK TEMP APPS_TS_TX_DATA
ALR TEMP APPS_TS_TX_DATA
AMF TEMP APPS_TS_TX_DATA
AMS TEMP APPS_TS_TX_DATA
AMV TEMP APPS_TS_TX_DATA
Relevant information
===================
After upgrade ctxsys is missing
ODM Data Collection Oracle Support- Feb 13, 2022 1:19 PM (Sunday)
db_upg_diag_POC1_08_Feb_2022_0150.log
====================================
================
Local Listener
================
POC1_LOCAL
================
Default and Temporary Tablespaces By User
================
USERNAME TEMPORARY_TABLESPACE DEFAULT_TABLESPACE
---------------------------- ---------------------- ----------------------
SYSTEM TEMP SYSTEM
OUTLN TEMP SYSTEM
DBSNMP TEMP SYSTEM
SYS TEMP SYSTEM
AHL TEMP APPS_TS_TX_DATA
ORDSYS TEMP SYSTEM
ORDPLUGINS TEMP SYSTEM
MDSYS TEMP1 SYSAUX
CTXSYS TEMP CTXD
Call - Outbound Oracle Support- Feb 13, 2022 1:09 PM (Sunday)
Call - Outbound
------------------------------
Spoke to primary contact. Customer stated that this is their first iteration of upgrade post upgrading EBS 12.1.3 DB from [Link] to [Link]
they find CTXSYS is missing . Informed I will review and will update the SR
ODM Research Oracle Support- Feb 13, 2022 1:06 PM (Sunday)
-- Search --
Note: This is INTERNAL ONLY research. No action should be taken by the customer on this information. This is research only, and may NOT be
applicable to your specific situation.
Searched on:
Interoperability Notes EBS 12.0 and 12.1 with Database 11gR2 (Doc ID 1058763.1)
Notes Oracle Support- Feb 13, 2022 12:52 PM (Sunday)
Hello,
My name is Sindhuja Thallam and your SR has been assigned to me. I am currently reviewing the SR. I will update the Service Request (SR) or
call you as soon as I have relevant information.
The following note can enhance your experience with Global Customer Services:
Doc ID: 166650.1 : Working Effectively With Support
You may search the community for issues similar to yours at the following URL:
[Link]
[Link] 6/9
2/15/22, 6:37 PM SR Detail
If you need to call in, here is a link to the Customer Global support numbers:
[Link]
Your patience is greatly appreciated.
You can call HUB at 1-800-223-1711 to request reassignment of SR in case you need assistance during of my offshift hours.
Regards
Sindhuja
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 12:35 PM
(Sunday)
fyi..
8th Feb log is before upgrade file
11th feb is after upgrade file
NOTE:- Currently we are upgrading DB from [Link] to [Link] and final goal to reach 19.6
and ebs upgrading from 12.1.3 to 12.2.10, once we upgrade DB from [Link] to [Link] then we start ebs upgrade
Hope the info is sufficient , let us know if you need any additional info to work on it
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 12:34 PM
(Sunday)
Upload to TDS successful for the file db_upg_diag_POC1_08_Feb_2022_0150.log.
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 12:33 PM
(Sunday)
Upload to TDS successful for the file [Link].
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 12:33 PM
(Sunday)
Upload to TDS successful for the file [Link].
Update from Customer MANOJ.KUMAR5@[Link]- Feb 13, 2022 12:32 PM
(Sunday)
Upload to TDS successful for the file db_upg_diag_POC1_11_Feb_2022_0354.log.
Notes Oracle Support- Feb 13, 2022 12:24 PM (Sunday)
The Service Request (SR) is assigned and is currently being monitored by an automated process. During this process, an evaluation of the SR is
done to ensure it is routed to an agent with the correct skill set to service your issue.
If a file request is posted to the SR, please make every effort to upload all items requested.
For more information about automation please review Note 1998077.1 Automated Troubleshooting Process.
Your patience is most appreciated.
Thank you
Customer Problem Description MANOJ.KUMAR5@[Link]- Feb 13, 2022 12:17 PM
(Sunday)
Customer Severity 1 Details
---------------------------------------------------
Work 24x7 option has been selected - Work hours for this Service Request are 24x7.
Severity 1 Contact Information
---------------------------------------------------
** Customer's Management contact name: Manoj Kumar
** Customer's Management contact number: +91-8074744184
** Customer's Management E-mail Address: manoj.kumar5@[Link]
** Primary Customer contact name: Manoj Kumar
** Primary Customer contact number: +91-8074744184
** Primary Customer E-mail Address: manoj.kumar5@[Link]
** Primary Customer Contact Method: Email
** Secondary Customer contact name: Manoj Kumar
** Secondary Customer contact number: +91-8074744184
** Alternate Contact Number: +91-8074744184
** Secondary Customer E-mail Address: manoj.kumar5@[Link]
Customer Problem Description
---------------------------------------------------
Problem Summary
---------------------------------------------------
CTXSYS is missing after upgrade
Problem Description
---------------------------------------------------
[Link] 7/9
2/15/22, 6:37 PM SR Detail
CTXSYS is missing after upgrade
Error Codes
---------------------------------------------------
Problem Category/Subcategory
---------------------------------------------------
[03] EBS Upgrade Issues/[02] Database 19c
Uploaded Files
---------------------------------------------------
Global Problem Definition Details
---------------------------------------------------
Question: Issue is happening in:
Answer: Non-Production Environment (Test, Stage, etc.)
Question: Your system is:
Answer: System down
Question: The issue occurs:
Answer: Every time (consistently)
Question: The issue impacts:
Answer: Most / All users
Question: The expected functionality has:
Answer: Worked previously
Question: The business impact is:
Answer: Financial impact - High
Question: Indicate what milestone is affected by the issue:
Answer: GO Live
Question: Need by date (DD/MM/YY):
Answer: Feb 18th
Question: Do you have a workaround to avoid this problem?
Answer: No workaround available
Question: Describe workaround
Answer: CTXSYS is missing after upgrade
Question: Describe recent changes to your environment
Answer: we are upgrading Database from [Link] to [Link] and final goal is to upgrade DB to 19.6
Question: Provide other details (Critical process, critical dates, financial impact, frequency, % of impacted transactions):
Answer: Financial impact is high
Question: Select one of the following
Answer: Database upgrade
Question: Select one of the following
Answer: Preparation for upgrade
Question: Select one of the following
Answer: Database tier only platform on 19c
Diagnosis: Review the following document to troubleshoot this issue:
Read Note:2640496.1 Using Oracle E-Business Suite Release 12.1 with a Database Tier Only Platform on Oracle 19c
You may also want to review the following notes:
Read Note:2662860.1 19c Database with Oracle E-Business Suite R12 Known Issues & Solutions
Read Note:2655839.2 Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1
We recommend saving this session as a draft Service Request (SR). Once data gathering is complete, proceed with the next step to upload
requested data and submit SR.
[Link] 8/9
2/15/22, 6:37 PM SR Detail
[Link] 9/9