Skip to Main Content

Containers, Cloud Native & Kubernetes

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Need help installing oracle db on mac

Arushi VirkMar 3 2024

On inspecting container logs in docker I see below error. I have oracle db docker image on 2 macs intel and silicon. Intel Mac works fine but silicon I am not able to connect to oracle. Main things are oracle db container exits after approx 1 minute and listener supports no services though command is successful. I have mapped 1522:1521 port in both macs but it doesn’t seem to work on silicon

Please help

SQL> GRANT SELECT ON sys.v_$pdbs TO OPS$oracle

*

ERROR at line 1:

ORA-01012: not logged on

Process ID: 0

Session ID: 0 Serial number: 0

SQL> SQL> Disconnected

ORACLE_HOME = [/home/oracle] ? ORACLE_BASE environment variable is not being set since this

information is not available for the current user ID .

You can set ORACLE_BASE manually if it is required.

Resetting ORACLE_BASE to its previous value or ORACLE_HOME

The Oracle base remains unchanged with value /opt/oracle

/opt/oracle/checkDBStatus.sh: line 26: sqlplus: command not found

mv: cannot stat '/opt/oracle/dbs/spfileORCLCDB.ora': No such file or directory

mv: cannot stat '/opt/oracle/dbs/orapwORCLCDB': No such file or directory

ORACLE_HOME = [/home/oracle] ? ORACLE_BASE environment variable is not being set since this

information is not available for the current user ID .

You can set ORACLE_BASE manually if it is required.

Resetting ORACLE_BASE to its previous value or ORACLE_HOME

The Oracle base remains unchanged with value /opt/oracle

/opt/oracle/checkDBStatus.sh: line 26: sqlplus: command not found

#####################################

########### E R R O R ###############

DATABASE SETUP WAS NOT SUCCESSFUL!

The following output is now a tail of the alert.log:

2024-03-03T19:17:57.607283+00:00

Errors in file /opt/oracle/diag/rdbms/orclcdb/ORCLCDB/incident/incdir_146/ORCLCDB_ora_379_i146.trc:

ORA-00600: internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], [], [], [], [], []

ORA-27302: failure occurred at: skgpiidcompa

2024-03-03T19:17:57.810244+00:00

Shutdown abort by prelim connection

License high water mark = 0

USER(prelim) (ospid: 380): terminating the instance

2024-03-03T19:17:57.818618+00:00

Instance terminated by USER(prelim), pid = 380

This post has been answered by dvohra21 on Mar 4 2024
Jump to Answer

Comments

InoL Apr 29 2024

How doc gen treats nulls values?

You have to be more specific. Are your referring to the pre-built Document Generator function?

If so:

When my query return null in some columns

What is the JSON that is generated?

You should always include the element in the JSON, with an empty value. Don't leave it out.

Francois Robert-Oracle Jan 8 2025 — edited on Jan 8 2025

Since September 2024, when a tag has no corresponding value in the JSON data or the value is null, the tag is replaced by an empty string.

See the September Release Notes

1 - 2

Post Details

Added on Mar 3 2024
2 comments
1,425 views