Best Of

Re: Security Hardening Guidance for Primavera P6 EPPM (WebLogic & DB Configuration)

Please review:

Security and Hardening Best Practices For Primavera P6 Database, Application and Web Servers (Doc ID 1198103.1)

Should you have additional questions, please raise an SR via My Oracle Support and we can route to the Security team.

Thanks,

Ron

RonVongs-Oracle

1

Re: Activity Sheet - Milestones (zero-day duration & unable to un-milestone)

Hi Mathias

Zero-day durations - this is the same behavior as P6. In P6 for a Start Milestone you can only define the Start date and the Finish Date is set to the Start Date and the duration set to 0. For a Finish Duration it's the reverse but the duration is still 0.

You can swap an activity from Task Dependent to Start Milestone and vice versa as long as there are no assignments. If there are assignments they can be removed and saved and the switch can then happen. We have a backlog item to automate this.

Ray McEntee -Oracle

1

Re: unable to close and drop pdb ORA-01122 ORA-01110 ORA-01204

dba_pdbs is populated from the data dictionary. v$pdbs is populated from the control file. So you now have the two out of sync. I cannot imagine a better example of why following some AI advice on a technical issue is not always a good idea. Is this any sort of production system? If not, I would drop the whole database and start again. If it is a production environment, you could try the routine for PDB point in time recovery.

JohnWatson2

1

Re: Generate Award Button

Thank you. The issue was a customization that was missing in the environment. After adding the customization, the issue got fixed.

User_QZK0K

1

Announcing Oracle Solaris 11.4 SRU85

We've just released Oracle Solaris 11.4 SRU85.

It is available via 'pkg update' from the support repository or by downloading the SRU from My Oracle Support Doc ID 2433412.1.

The following packages have been updated to address security issues:

MySQL 8.4 to 8.4.6
Web Server to 2.4.65
PHP to 8.4.10
Firefox to 128.13.0esr
Thunderbird to 128.13.0esr
ruby 3.3 to 3.3.9
Golang to 1.23.12
utility/cups

Full details of this SRU can be found in My Oracle Support Doc 3103853.1.

For the list of Service Alerts affecting each Oracle Solaris 11.4 SRU, see Important Oracle Solaris 11.4 SRU Issues (Doc ID 2445150.1).

Prashant Deo-Oracle

1

Re: How to set a default destination subinventory on internal requisitions

We will discuss the custom defaulting rule internally. I will post with decisions or results when I have them. Thank you for the suggestion.

User_64K2W

1

How to migrate database from ODA (X8-2)19.6 to ODA (X11-2)19.26

Hello experts,

We are planning to migrate oracle database running in 19.6 (ODA X8-2) to a new hardware platform ODA X11-2.

In this process following is our plan.

1. Create 19.26 RDBMS binary home n new ODA X11-2 server.

2. Create 2nd standby database from the backup taken on 1st standby database running in ODA X8-2

3. Validate redo sync between primary and 2nd standby database

4. Switchover role of 2nd standby database to primary.

Now question is all metadata belongs to 19.6 even though we are using 19.26 RDBMS binary.

Do we need to follow upgrade path(19.6 to 19.26) after switchover?

Please help us to clarify this question.

DDeb

1

Re: How to migrate database from ODA (X8-2)19.6 to ODA (X11-2)19.26

Hi,

The RU difference is huge, so you should patch the primary first to 19.26 using Out-Of-Cycle patching and apply the same patches that you have on the newly created 19.26 dbhome on X11-2.

https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/19.6/cmtxn/patching-oda.html#GUID-C6EC7E10-9C91-4362-9086-99F023AAA79B

Once done, the procedure you described is a possible option indeed.

Br,

krisz