Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ORA-1119 when creating tablespace in setupscript #2916

Open
Kmdkca opened this issue Feb 7, 2025 · 0 comments
Open

ORA-1119 when creating tablespace in setupscript #2916

Kmdkca opened this issue Feb 7, 2025 · 0 comments

Comments

@Kmdkca
Copy link

Kmdkca commented Feb 7, 2025

I try to create a tablespace as part of the startup script in docker.

 oracledatabase:
      image: container-registry.oracle.com/database/express:latest
      platform: linux
      environment:
        - ORACLE_PWD=xxx
      container_name: oracle
      ports:
        - '1521:1521'
      volumes:
        - ./oracle/std/oradata:/opt/oracle/oradata
        - ./scripts/std/setup:/opt/oracle/scripts/setup
      restart: unless-stopped

Script placed /scripts/std/setup contains:
create smallfile tablespace TESTDATA datafile 'testdata.dbf' SIZE 300M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

But it fails with ORA-1119 in the log:

2025-02-07 10:04:51 2025-02-07T09:04:50.642609+00:00
2025-02-07 10:04:51 create smallfile tablespace TESTDATA datafile 'testdata.dbf' SIZE 300M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
2025-02-07 10:04:51 ORA-1119 signalled during: create smallfile tablespace TESTDATA datafile 'testdata.dbf' SIZE 300M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO...
2025-02-07 10:04:51 2025-02-07T09:04:50.929572+00:00

I can manually run the same script when its started.
Also tried with the free version of Oracle.

@Kmdkca Kmdkca marked this as a duplicate of #2915 Feb 7, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant