Best Of

Re: How to Modify the Column Length in a Standard Report - Account Analysis report?

What product and version are you using? ( E-Business Suite / Oracle Fusion)

Regards,

Alexandra

1

Re: when will be the session details remove from the v$session view after killing an session?

The session stays around because the corresponding process is still around; in most cases, it’s waiting for an “SQLNet message from the client”. In your case your sql*plus session. When you run another command, the database can react with "the message ORA-00028 your session has been killed." and after that it can clear the database session.

Gerrit van der Linden

1

Re: How to Implement the Input Service Distribution(ISD) in GST in R12.2.8

Thank you all for your responses,

@Ramesh Ramalingam, Thank you very much for sharing your approach.

@AvinashM-Oracle, I appreciate you sharing the documentation (Doc ID 2287567.1).
I had reviewed this document earlier; however, I believe Oracle should provide more comprehensive and detailed documentation on the ISD configuration steps in Oracle EBS, especially since the government is making it mandatory.

Santanu Ghosh

1

Re: Oracle 19c Standard Edition on Windows - changing drives

In addition to moving control files:

Alter the control_files parameter using the ALTER SYSTEM command
Shutdown the database
Rename/move the physical files on the OS
Start the database

Redo log files require a similar approach to control files.

Since you mentioned environment variables, you'll need to update:

ORACLE_BASE: Point to the new location if applicable
ORACLE_HOME: Usually remains unchanged, but verify
TNS_ADMIN: If you store listener files on C: drive
PATH: May need updates if moving Oracle binaries

Arsalan Dehghanisariyarghan

1

Re: How do we download sudo package for Solaris 10 to cover CT Advisory: CVE-2025-32463,CVE-2025-32462

SR already opened no responses so far, will chase :)

SR 3-41426675861 : Download sudo package for Solaris 10 to cover CT Advisory: CVE-2025-32463,CVE-2025-32462

User_R30D9

1

Re: Can I run the post-install script once for multiple installations of Oracle database patches?

https://community.oracle.com/mosc/discussion/comment/17068422#Comment_17068422

I asked that somewhere and the answer was that Datapatch doesn't use the Central Inventory as it is ONLY performing database changes.

But anyway, running 2 Datapatch at the same time may indeed cause issues, if not the Central inventory. Particularly if sharing Oracle Homes.

What you can do is do staged runs: start one, wait some time (*), start the second one.

(*) The time needed to wait is arbitrary, nobody knows and it depends on "things". A perfect solution though is to wait untile finished, also called serial runs, ie not parallel. Slow but safe.