search

oracle / docker-images

Official source of container configurations, images, and examples for Oracle products and projects
https://developer.oracle.com/use-cases/#containers
Universal Permissive License v1.0
6.47k stars 5.41k forks source link

The Oracle instance is not available for use #2679

Closed rodrigomesquitaorclapex closed 11 months ago

rodrigomesquitaorclapex commented 11 months ago

After installed 23c I can connect to the database but receive an error message when try to do something

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Mon Aug 7 13:25:28 2023 Version 23.2.0.0.0

Copyright (c) 1982, 2023, Oracle. All rights reserved.

Connected. SQL> ALTER SESSION SET CONTAINER = FREEPDB1; ALTER SESSION SET CONTAINER = FREEPDB1 * ERROR at line 1: ORA-01034: The Oracle instance is not available for use. Start the instance. Process ID: 0 Session ID: 0 Serial number: 0

SQL>

2023-08-07 17:42:09 Starting Oracle Net Listener. 2023-08-07 17:42:10 Oracle Net Listener started. 2023-08-07 17:42:10 Starting Oracle Database instance FREE. 2023-08-07 17:42:11 Oracle Database instance FREE started. 2023-08-07 17:42:11 2023-08-07 17:42:11 The Oracle base remains unchanged with value /opt/oracle 2023-08-07 17:42:12 ##################################### 2023-08-07 17:42:12 ########### E R R O R ############### 2023-08-07 17:42:12 DATABASE SETUP WAS NOT SUCCESSFUL! 2023-08-07 17:42:12 Please check output for further info! 2023-08-07 17:42:12 ########### E R R O R ############### 2023-08-07 17:42:12 ##################################### 2023-08-07 17:42:12 The following output is now a tail of the alert.log: 2023-08-07 17:42:12 2023-08-07T16:42:11.604648+00:00 2023-08-07 17:42:12 1. For optimal performance, configure system with expected number 2023-08-07 17:42:12 of pages for every supported system pagesize prior to the next 2023-08-07 17:42:12 instance restart operation. 2023-08-07 17:42:12 2023-08-07T16:42:11.647027+00:00 2023-08-07 17:42:12 2. Increase per process memlock (soft) limit to at least 1536MB 2023-08-07 17:42:12 to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory 2023-08-07 17:42:12 2023-08-07T16:42:11.647142+00:00 2023-08-07 17:42:12 ** 2023-08-07 17:42:12 Using an SGA granule size of 16MB

watsom27 commented 11 months ago

@rodrigomesquitaorclapex Did you get anywhere with this? Im getting a similar error

yunus-qureshi commented 11 months ago

Is this the image from container-registry? container-registry.oracle.com/database/free:latest

Can you try the above image

aditya059 commented 11 months ago

Hi @watsom27 @rodrigomesquitaorclapex I tested this on my machine by building free 23c locally. Also tested image from container registry. This error is not reproducible. Please try with podman and reopen the issue if it persist.