- 385.1K All Categories
- 2.6K Data
- 605 Big Data Appliance
- 2K Data Science
- 452.2K Databases
- 222.5K General Database Discussions
- 32 Multilingual Engine
- 576 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 575 SQLcl
- 4K SQL Developer Data Modeler
- 187.8K SQL & PL/SQL
- 21.5K SQL Developer
- 12 Data Integration
- 12 GoldenGate
- 297.7K Development
- 3 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 294.4K Development Tools
- 118 DevOps
- 3.1K QA/Testing
- 646.5K Java
- 30 Java Learning Subscription
- 37K Database Connectivity
- 185 Java Community Process
- 107 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 174 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 588 LiveLabs
- 41 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 197 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 240 Portuguese
When configuring database creation for Oracle DB 21c-1.0 XE, I get errors about values.
The configure program is complaining about the SHARED_POOL_SIZE being too small (2560MB, wants it to be at least 3600). Also, about sga_target being too small. Where can I set these values so that the DB creation will succeed?
I tried setting sga_target in the dbs/init.ora file which got rid of that specific message, but still get shared_pool_size error messages. I am pasting the output from the configure run, and also the contents of init.ora for review. Thanks.
It also complains about permissions and to run the root.sh script. I did run this script but am still getting the permissions errors.
[[email protected] dbs]# /etc/init.d/oracle-xe-21c configure
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 XE.
[WARNING] [DBT-11205] Specified shared pool size does not meet the recommended minimum size requirement. This might cause database creation to fail.
ACTION: Specify at least (2,592 MB) for shared pool size.
Enter SYS user password: *************
Enter SYSTEM user password:
Enter PDBADMIN User Password:
[FATAL] [DBT-10011] Incorrect ownership/permissions detected for the file (/opt/oracle/product/21c/dbhomeXE/bin/oradism).
CAUSE: Following nodes does not have required file ownership/permissions: Node :iceberg
PRVG-11960 : Set user ID bit is not set for file "/opt/oracle/product/21c/dbhomeXE/bin/oradism" on node "iceberg".
ACTION: Run the Oracle Home root script as the "root" user to fix the permissions.
Database configuration failed. Check logs under '/opt/oracle/cfgtoollogs/dbca'.
[[email protected] dbs]#
# Change '<ORACLE_BASE>' to point to the oracle base (the one you specify at
# install time)
processes = 150
# You may want to ensure that control files are created on separate physical
control_files = (ora_control1, ora_control2)