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.58k stars 5.43k forks source link

23.4.0 Free gets "ORA-07427: spstp: cannot change directory to dbs." error #2801

Closed yahonda closed 5 months ago

yahonda commented 6 months ago

23.4.0 Free gets "ORA-07427: spstp: cannot change directory to dbs." error

Steps to reproduce

git clone https://github.com/oracle/docker-images
cd docker-images/OracleDatabase/SingleInstance/dockerfiles
./buildContainerImage.sh -v 23.4.0 -f
sudo docker run -d --name oracle-container  oracle/database:23.4.0-free

Expected behavior

It should start up 23.4.0 Free Docker process.

Actual behavior

It gets "DATABASE SETUP WAS NOT SUCCESSFUL!".

$ docker logs -f 9e2ad8cdd05889c8b7fa4c2b17a377a6ff7ec252625d7777b84a0b1f8e765053
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database FREE.
Enter SYS user password:
*****************
Enter SYSTEM user password:
****************
Enter PDBADMIN User Password:
*****************
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
33% complete
36% complete
39% complete
43% complete
Completing Database Creation
47% complete
49% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details.

Connect to Oracle Database using one of the connect strings:
     Pluggable database: 9e2ad8cdd058/FREEPDB1
     Multitenant container database: 9e2ad8cdd058

SQL*Plus: Release 23.0.0.0.0 - Production on Tue May 14 08:44:22 2024
Version 23.4.0.24.05

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

Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05

SQL>
System altered.

SQL>
Pluggable database altered.

SQL>
PL/SQL procedure successfully completed.

SQL> SQL>
Session altered.

SQL>
User created.

SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL>
User altered.

SQL> SQL> Disconnected from Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05
The Oracle base remains unchanged with value /opt/oracle
The Oracle base remains unchanged with value /opt/oracle
#####################################
########### E R R O R ###############
DATABASE SETUP WAS NOT SUCCESSFUL!
Please check output for further info!
########### E R R O R ###############
#####################################
The following output is now a tail of the alert.log:
ALTER SYSTEM SET local_listener='' SCOPE=BOTH;
ALTER PLUGGABLE DATABASE FREEPDB1 SAVE STATE
Completed: ALTER PLUGGABLE DATABASE FREEPDB1 SAVE STATE
2024-05-14T08:44:22.977086+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_2733.trc:
ORA-07427: spstp: cannot change directory to dbs.
ORA-27300: OS system dependent operation:chdir() failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: spstp:9
ORA-27303: additional information: error returned by chdir() is 2
2024-05-14T08:44:35.715092+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_j000_2737.trc:
ORA-07427: spstp: cannot change directory to dbs.
ORA-27300: OS system dependent operation:chdir() failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: spstp:9
ORA-27303: additional information: error returned by chdir() is 2
2024-05-14T08:44:36.706783+00:00
kkjcre1p: unable to spawn jobq slave process
2024-05-14T08:44:36.707447+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_cjq0_2464.trc:
2024-05-14T08:44:36.997895+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_j000_2740.trc:
ORA-07427: spstp: cannot change directory to dbs.
ORA-27300: OS system dependent operation:chdir() failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: spstp:9
ORA-27303: additional information: error returned by chdir() is 2
2024-05-14T08:44:37.989368+00:00
kkjcre1p: unable to spawn jobq slave process
2024-05-14T08:44:37.989589+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_cjq0_2464.trc:
2024-05-14T08:44:38.205260+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_j000_2742.trc:
ORA-07427: spstp: cannot change directory to dbs.
ORA-27300: OS system dependent operation:chdir() failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: spstp:9
ORA-27303: additional information: error returned by chdir() is 2
2024-05-14T08:44:39.195527+00:00
kkjcre1p: unable to spawn jobq slave process
2024-05-14T08:44:39.195824+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_cjq0_2464.trc:
2024-05-14T08:44:39.411332+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_j000_2744.trc:
ORA-07427: spstp: cannot change directory to dbs.
ORA-27300: OS system dependent operation:chdir() failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: spstp:9
ORA-27303: additional information: error returned by chdir() is 2
2024-05-14T08:44:40.401019+00:00
kkjcre1p: unable to spawn jobq slave process
2024-05-14T08:44:40.401222+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_cjq0_2464.trc:
2024-05-14T08:44:40.614321+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_j000_2746.trc:
ORA-07427: spstp: cannot change directory to dbs.
ORA-27300: OS system dependent operation:chdir() failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: spstp:9
ORA-27303: additional information: error returned by chdir() is 2
yahonda commented 6 months ago 
$ docker ps
CONTAINER ID   IMAGE                         COMMAND                  CREATED         STATUS                            PORTS      NAMES
9e2ad8cdd058   oracle/database:23.4.0-free   "/bin/bash -c $ORACL…"   4 minutes ago   Up 4 minutes (health: starting)   1521/tcp   oracle-container

*** 2024-05-14T08:44:22.976738+00:00 ORA-07427: spstp: cannot change directory to dbs. ORA-27300: OS system dependent operation:chdir() failed with status: 2 ORA-27301: OS failure message: No such file or directory ORA-27302: failure occurred at: spstp:9 ORA-27303: additional information: error returned by chdir() is 2 bash-4.4$ exit

kaidonato commented 4 months ago

Just to let you know. I'm still running into this issue. Let me know if I can assist.

kaidonato commented 4 months ago

@gvenzl This is the .trc

Trace file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_4214.trc
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05
Build label:    RDBMS_23.0.0.0.0_LINUX.X64_240424
ORACLE_HOME:    /opt/oracle/product/23ai/dbhomeFree
System name:    Linux
Node name:  febd2b603ee1
Release:    4.18.0-519.el8.x86_64
Version:    #1 SMP Tue Oct 24 16:44:13 UTC 2023
Machine:    x86_64
VM name:    KVM CPUID feature flags: 0x01003afb
Storage:    ?
CLID:   U
Instance name: FREE
Instance number: 0 <none>
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Unix process pid: 4214, NID: 4026532646, image:

*** 2024-06-18T09:17:57.165801+00:00
ORA-07427: spstp: cannot change directory to dbs.
ORA-27300: OS system dependent operation:chdir() failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: spstp:9
ORA-27303: additional information: error returned by chdir() is 2
sh-4.4$
yunus-qureshi commented 4 months ago

@kaidonato have you rebuilt after the fix was pushed?

Sam-Hwang commented 3 days ago

Removed previous comment. Error on my setting and issue is fixed.