I am trying to setup a local Oracle database with 23ai, but I fail at the very basics. I am trying to connect to the DB after installation, but get > ORA-12514: Cannot connect to database. Service FREE is not registered > with the listener at host localhost port 1521. When I try checking lsnrctl for the service, I get LSNRCTL> services Anmeldung bei (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XYZ.YOURCOMPANY.com)(PORT=1521))) TNS-12546: TNS: Berechtigung verweigert TNS-12560: Fehler bei Datenbankkommunikationsprotokoll. TNS-00516: Genehmigung verweigert 64-bit Windows Error: 13: Permission denied Anmeldung bei (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) Der Listener unterst³tzt keine Services Der Befehl wurde erfolgreich ausgef³hrt. So for some I can't even check the services due to some permission issue. I installed the DB for the local user if that changes anything. How can I get rid of this permission issue, and how can I then connect to the DB?

Have a good day, guys and girls!) Using HammerDB for Oracle benchmarking, I have this connection settings: > diset connection instance IP_of_server:1521/XEPDB1 ... this messages from start and end snapshots: > Vuser 1:Start Snapshot 30 taken at 06 JUL 2022 16:58 of instance **xe** (1) of database **XE** (691444369) > Vuser 1:End Snapshot 31 taken at 06 JUL 2022 17:00 of instance **xe** (1) of database **XE** (691444369) ... and this result message: > Vuser 1:TEST RESULT : System achieved **12248 NOPM from 0 Oracle TPM** I use HammerDB 4.4, Oracle XE 21c and **pluggable** database XEPDB1. According to Oracle docs, starting from version 12.2 there are separated AWR snapshots for CDB and PDB - and AWR PDB snapshots are default disabled. Well, I've executed the code below: alter session set container=XEPDB1; alter system set awr_pdb_autoflush_enabled=true; conn system/; alter system set AWR_SNAPSHOT_TIME_OFFSET=1000000 scope=both; ... and then restart all 5 Oracle services. No effect. Then I've tried to modify HammerDB oraoltp.tcl **line 2533:** from this: SELECT INSTANCE_NUMBER, INSTANCE_NAME, DB_NAME, DBID, SNAP_ID, TO_CHAR(END_INTERVAL_TIME,'DD MON YYYY HH24:MI') FROM (SELECT DI.INSTANCE_NUMBER, DI.INSTANCE_NAME, DI.DB_NAME, DI.DBID, DS.SNAP_ID, DS.END_INTERVAL_TIME FROM DBA_HIST_SNAPSHOT DS, DBA_HIST_DATABASE_INSTANCE DI WHERE DS.DBID=DI.DBID AND DS.INSTANCE_NUMBER=DI.INSTANCE_NUMBER AND DS.STARTUP_TIME=DI.STARTUP_TIME ORDER BY DS.END_INTERVAL_TIME DESC) WHERE ROWNUM=1" to this: SELECT INSTANCE_NUMBER, INSTANCE_NAME, DB_NAME, DBID, SNAP_ID, TO_CHAR(END_INTERVAL_TIME,'DD MON YYYY HH24:MI') FROM (SELECT DI.INSTANCE_NUMBER, DI.INSTANCE_NAME, DI.DB_NAME, DI.DBID, DS.SNAP_ID, DS.END_INTERVAL_TIME FROM AWR_PDB_SNAPSHOT DS, AWR_PDB_DATABASE_INSTANCE DI WHERE DS.DBID=DI.DBID AND DS.INSTANCE_NUMBER=DI.INSTANCE_NUMBER AND DS.STARTUP_TIME=DI.STARTUP_TIME ORDER BY DS.END_INTERVAL_TIME DESC) WHERE ROWNUM=1" So, I've replaced **DBA_HIST_SNAPSHOT** with **AWR_PDB_SNAPSHOT** and **DBA_HIST_DATABASE_INSTANCE** with **AWR_PDB_DATABASE_INSTANCE** - as follows from this Oracle 12.2 feature. As result it has got 0 NOPM and 0 TPM as well. So what have I done wrong and how to fix this 0 TPM? Any ideas, please?)(

While testing some migration scripts with a copy of production data (scripts run fine with development data) I found a curious situation. A CONSTRAINT has changed so I'm issuing DROP + ADD commands: ALTER TABLE A_DUP_CALLE DROP CONSTRAINT A_DUP_CALLE_UK1; ALTER TABLE A_DUP_CALLE ADD CONSTRAINT A_DUP_CALLE_UK1 UNIQUE ( CONTROL_ID, CALLE_AYTO_DUPL ) ENABLE; The DROP command worked fine but the ADD one failed. Now, I'm into a vicious circle. I cannot drop the constraint because it doesn't exist (initial drop worked as expected): > ORA-02443: Cannot drop constraint - nonexistent constraint And I cannot create it because the name already exists: > ORA-00955: name is already used by an existing object I type A_DUP_CALLE_UK1 into SQL Developer's *Search* box and... there it is! Owner, table name, tablescape... everything matches: it isn't a different object with the same name, it **is** my original constraint. The table appears in the constraint details but the constraint does not appear in the table's details. My questions: - What's the explanation for this? - How can I ensure it won't happen when I make the real upgrade in live server? *(Server is 10g XE, I don't have enough reputation to create the tag.)*

I am trying to make the jump from MS SQL Server and recently downloaded OracleXE. Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production . My version in SQL Plus lists as 21.3.0.0.0 and I have downloaded version Version 24.3.1.347 of Oracle Sql Developer. In SQL Plus I have managed to create a user with sysdba privileges and in SQL Developer I managed to create a connection whereby I can run a query like “SELECT name, open_mode FROM v$pdbs;” and I can see results . The results seem to say I only have 2 mounted databases currently. I have big ideas like standing up a new database for an application I would like to build .NET. So its my understanding (correct me if I am wrong) that this would most likely be a pluggable database? Correct? (A database that lives within a container database? ) I would also like to create a specific user that has full rights to create tables, schemas, etc to this new database. Right now whenever I try to run the commands I have read about to do this, almost next to nothing works. So for example when I runthe following command in SQL Plus I get this:

SQL> CREATE PLUGGABLE DATABASE my_new_pdb;
CREATE PLUGGABLE DATABASE my_new_pdb
*
ERROR at line 1:
ORA-00922: missing or invalid option

In SQL Developer I get this:

CREATE PLUGGABLE DATABASE my_new_pdb
Cause: An invalid option was specified in defining a column or
storage clause. The valid option in specifying a column was NOT
NULL to specify that the column cannot contain any NULL
values. Only constraints may follow the datatype. Specifying a
maximum length on a DATE or LONG datatype also causes this
error.

*Action: Correct the syntax. Remove the erroneous option or
length specification from the column or storage specification.

Also In tried creating a user in SQL Plus. When I run the following command to create a new user I get this…

SQL> create user jazzcatone identified by jazzcatone default tablespace users quota unlimited on users;
ERROR at line 1:
ORA-01109: database not open

I guess don't know what database I should be trying to connect to? Is there a database called users?

I'm using SQL Developer to migrate a database from MySQL 5.7 to Oracle 18c XE. The problem is that the tables are generated but empty, even though I'm specifying that the data should move online. I also looked at the scripts, and there's no data either. What I see in the log is DataMove.DISABLE_CONSTRAINTS_FAILED. How to fix this? These are the migration options:

I installed Oracle XE 21C on an old laptop running Oracle Linux 8.6. I followed the official documentation without getting any errors. I am trying to set the lsnrctl to the one located in /opt/oracle/product/21c/dbhomeXE/network/admin/listener.ora. I am attempting to connect from a different host to the database (Oracle Linux IP is 192.168.0.100). DEFAULT_SERVICE_LISTENER = XE SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = XE) (ORACLE_HOME = /opt/oracle/product/21c/dbhomeXE) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) However, lsnrctl stat shows this (already tried reloading it): LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 21-OCT-2022 17:53:30 Copyright (c) 1991, 2021, Oracle. All rights reserved. TNS-01106: Listener using listener name LISTENER has already been started [oracle@oserver ~]$ lsnrctl star LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 21-OCT-2022 17:53:32 Copyright (c) 1991, 2021, Oracle. All rights reserved. TNS-01106: Listener using listener name LISTENER has already been started [oracle@oserver ~]$ lsnrctl stat LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 21-OCT-2022 17:53:38 Copyright (c) 1991, 2021, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 21.0.0.0.0 - Production Start Date 21-OCT-2022 17:33:21 Uptime 0 days 0 hr. 20 min. 17 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Default Service XE Listener Parameter File /opt/oracle/homes/OraDBHome21cXE/network/admin/listener.ora Listener Log File /opt/oracle/diag/tnslsnr/oserver/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=127.0.0.1)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/homes/OraDBHome21cXE/admin/XE/xdb_wallet))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "XE" has 1 instance(s). Instance "XE", status READY, has 1 handler(s) for this service... Service "XEXDB" has 1 instance(s). Instance "XE", status READY, has 1 handler(s) for this service... Service "eb920423f5e46b23e055000000000001" has 1 instance(s). Instance "XE", status READY, has 1 handler(s) for this service... Service "xepdb1" has 1 instance(s). Instance "XE", status READY, has 1 handler(s) for this service... The command completed successfully Which is not what I have set up in the listener.ora. I have confirmed the listener.ora file is in the correct location. How do I set lsnrctl to follow the listener.ora file? And, does that listener.ora configuration allow me to connect from a different host? Thanks in advance.

I'm using Oracle 21c XE for an application with a database size of less than 0.5 GB. However, I’m encountering the error: ** ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT. I’ve tried restarting the database to release the PGA memory, but the issue reappears within a day, forcing me to restart the database daily. Upon investigation, I noticed that the process oracle@.host.secureserver.net (CJQ0) steadily increases its memory usage, eventually reaching the 2 GB limit within 24–36 hours. I currently have only two scheduled jobs, but disabling them didn’t make a significant difference. I’d appreciate any guidance or suggestions on how to resolve this issue. Thanks!

I have spent the last 6 hours trying to install Oracle 11g on Ubuntu. Obviously, I'm not the only one who has struggled with this, as there is a lot of (often misleading) "documentation" online on how to resolve the various errors that one invariably encounters when installing Oracle 11g on Ubuntu. I followed one such "guide" - (this one) , and followed all the instructions. I then spent the last 5 hours trying to configure Oracle, to no avail. when I run /etc/init.d/oracle-xe configure, I got the response (after a few minutes): Starting Oracle Net Listener...Done Configuring database... Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details Here are the contents of the files in my /u01/app/oracle/product/11.2.0/xe/config/log folder: **CloneDbCreation.log** Control file created. PL/SQL procedure successfully completed. ORA-01109: database not open Database dismounted. ORACLE instance shut down. ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2233344 bytes Variable Size 616565760 bytes Database Buffers 444596224 bytes Redo Buffers 5541888 bytes Control file created. System altered. Database altered. Database altered. System altered. System altered. Database altered. Tablespace altered. TABLESPACE_NAME ------------------------------ USERS SID PROGRAM SERIAL# ---------- ------------------------------------------------ ---------- USERNAME ------------------------------ 1 oracle@jupiter (PMON) 1 2 oracle@jupiter (VKTM) 1 3 oracle@jupiter (DIAG) 1 SID PROGRAM SERIAL# ---------- ------------------------------------------------ ---------- USERNAME ------------------------------ 4 oracle@jupiter (DIA0) 1 5 oracle@jupiter (DBW0) 1 6 oracle@jupiter (CKPT) 1 SID PROGRAM SERIAL# ---------- ------------------------------------------------ ---------- USERNAME ------------------------------ 7 oracle@jupiter (RECO) 1 8 oracle@jupiter (MMNL) 3 9 oracle@jupiter (VKRM) 7 SID PROGRAM SERIAL# ---------- ------------------------------------------------ ---------- USERNAME ------------------------------ 10 oracle@jupiter (CJQ0) 5 87 sqlplus@jupiter (TNS V1-V3) 3 SYS 88 oracle@jupiter (PSP0) 1 SID PROGRAM SERIAL# ---------- ------------------------------------------------ ---------- USERNAME ------------------------------ 89 oracle@jupiter (GEN0) 1 90 oracle@jupiter (DBRM) 1 91 oracle@jupiter (MMAN) 1 SID PROGRAM SERIAL# ---------- ------------------------------------------------ ---------- USERNAME ------------------------------ 92 oracle@jupiter (LGWR) 1 93 oracle@jupiter (SMON) 1 94 oracle@jupiter (MMON) 3 SID PROGRAM SERIAL# ---------- ------------------------------------------------ ---------- USERNAME ------------------------------ 98 oracle@jupiter (QMNC) 5 19 rows selected. User altered. User altered. System altered. **CloneRmanRestore.log** ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2233344 bytes Variable Size 616565760 bytes Database Buffers 444596224 bytes Redo Buffers 5541888 bytes TO_CHAR(SYSTIMEST ----------------- 20121127 08:47:46 Allocating device.... Specifying datafiles... Specifing datafiles... Restoring ... Restore done. PL/SQL procedure successfully completed. TO_CHAR(SYSTIMEST ----------------- 20121127 08:48:17 **PostDBCreation.log** PL/SQL procedure successfully completed. File created. Database closed. Database dismounted. ORACLE instance shut down. ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2233344 bytes Variable Size 616565760 bytes Database Buffers 444596224 bytes Redo Buffers 5541888 bytes Database mounted. Database opened. 'UTL_RECOMP_BEGIN:'||TO_CH -------------------------- utl_recomp_begin: 08:49:11 PL/SQL procedure successfully completed. 'UTL_RECOMP_END:'||TO_CH ------------------------ utl_recomp_end: 08:49:13 **postScripts.log** CREATE OR REPLACE LIBRARY dbms_sumadv_lib AS '/u01/app/oracle/product/11.2.0/xe/lib/libqsmashr.so'; * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 BEGIN dbms_datapump_utl.replace_default_dir; END; * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 commit * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 create or replace directory XMLDIR as '/u01/app/oracle/product/11.2.0/xe/rdbms/xml' * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 DROP DIRECTORY ORACLE_OCM_CONFIG_DIR * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 DROP DIRECTORY ADMIN_DIR * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 DROP DIRECTORY WORK_DIR * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 BEGIN dbms_swrf_internal.cleanup_database(cleanup_local => FALSE); END; * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 commit * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 My environment variables are as follows: root@jupiter:~# env | grep ORACLE ORACLE_SID=XE ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe/ Miscellaneous system configuration: root@jupiter:~# df -k /dev/shm Filesystem 1K-blocks Used Available Use% Mounted on shmfs 2097152 624008 1473144 30% /dev/shm root@jupiter:~# sysctl -p |grep kernel kernel.shmmax = 1073741824 I don't know what else to do. I have come to the end of my tether. Hopefully, all of the above will mean something to an Oracle expert, who can point out what I'm missing.

**Business Case:** We have an application that creates backups of its data. Each time that a user creates a backup, a registry is created in another table (like a historical table) ... Right now, we working with Oracle XE 18c. As you may know, OracleXE has fixed limit of 12GB of data ... If you try to insert something once you have reached such limit, you will receive an exception like this: > ORA-12954: The request exceeds the maximum allowed database size of 12 GB. So, we must be able to create our backup, even if the database has reached those 12GB ... Now, we're in a crossroad: either we refactor the process to avoid adding that registry into the database or we find a more elegant solution. The solution that I was thinking is like creating the historical table but reserving some space for it, allowing adding that extra registry when the 12GB limits has been reached. According to the Oracle documentation, there is clause clause called STORAGE and other types of configurations ... So, **my question is**: Will it be possible to do what I thinking? Like reserving space for the table before any record is stored in it (avoiding to refactor the application's process?) and leaving enough space to store a couple of records, even if the database has reached the 12GB limit? Thanks!

In my Windows Oracle 21c XE installation I have the product installed under: C:\Oracle\product\21c Below that there is: dbhomeXE which contains the bin directory and also network. However, I also have: C:\Oracle\product\21c\homes\OraDB21Home1 This also has network/admin. It looks like dbhomeXE should be the Oracle home, but I have seen it also mentioned that it should be the directory above. I assume TNS_ADMIN should be $ORACLE_HOME/network/admin? But how does it matter anyway? What uses ORACLE_HOME? It isn't currently set on my system and sqlplus launches, although it can't find the PDB I have created. **EDIT:** The variables are used in a batch script to run sqlplus, so I am talking about the client side really, although both the server and the client are on the same PC.

We have Oracle XE 10.2.0.1.0 running on CentOS 6.9. The Database works stable all the time, except the system reboots. If reboot command is issued in the OS terminal, the Database enters MOUNT mode. Then we issue service oracle-xe restart **TWICE** to bring the DB to OPEN mode. The first time command issues quickly, and last, the second time it takes some time to restart. As I see in the logs, the first time the instance can not raise up due to some resource blocking. It issues a terminating signal, and then, it starts after the second service oracle-xe restart command issue. I bring alert_XE.log here So here is the event and the times: 1. Fri Oct 21 12:11:46 2022 - First DB starts after reboot, DB enters the MOUNT mode 2. Fri Oct 21 12:26:50 2022 - First service oracle-xe restart issue 2. Fri Oct 21 16:51:12 2022 - Second service oracle-xe restart issue, DB enters the OPEN mode If there is not enough information for giving me the path to the solution, can you write me about where and which logs level I need to increase or what more log I need to watch for missing information. **UPDATE** I fixed the error with LD_LIBRARY_PATH, by editing /etc/init.d/oracle-xe directly, and appended follow line after block of environment variables defenition:

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LD_LIBRARY_PATH

Now, if I try to OPEN database as miracle173 suggests, I get follow error:

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

**UPDATE** Now we have new errors in alter.log, this is what is going after ALTER DATABASE MOUNT:

Mon Oct 24 17:02:49 2022
Beginning crash recovery of 1 threads
Mon Oct 24 17:02:49 2022
Started redo scan
Mon Oct 24 17:02:49 2022
Completed redo scan
 147 redo blocks read, 78 data blocks need recovery
Mon Oct 24 17:02:49 2022
Started redo application at
 Thread 1: logseq 1791, block 3
Mon Oct 24 17:02:49 2022
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1791 Reading mem 0
  Mem# 0 errs 0: /usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/onlinelog/o1_mf_2_dgsl2gd0_.log
Mon Oct 24 17:02:49 2022
Completed redo application
Mon Oct 24 17:02:49 2022
Completed crash recovery at
 Thread 1: logseq 1791, block 150, scn 284886106315
 78 data blocks read, 78 data blocks written, 147 redo blocks read
Mon Oct 24 17:02:49 2022
Thread 1 advanced to log sequence 1792
Thread 1 opened at log sequence 1792
  Current log# 1 seq# 1792 mem# 0: /usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/onlinelog/o1_mf_1_dgsl2dvq_.log
Successful open of redo thread 1
Mon Oct 24 17:02:49 2022
SMON: enabling cache recovery
Mon Oct 24 17:02:50 2022
Successfully onlined Undo Tablespace 1.
Mon Oct 24 17:02:50 2022
SMON: enabling tx recovery
Mon Oct 24 17:02:50 2022
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Process QMNC died, see its trace file
Mon Oct 24 17:02:51 2022
Errors in file /usr/lib/oracle/xe/app/oracle/admin/XE/udump/xe_ora_2423.trc:
ORA-00443: background process "QMNC" did not start
Mon Oct 24 17:02:51 2022
Errors in file /usr/lib/oracle/xe/app/oracle/admin/XE/udump/xe_ora_2423.trc:
ORA-00450: background process 'QMNC' did not start
ORA-00443: background process "QMNC" did not start
Error 450 happened during db open, shutting down database
USER: terminating instance due to error 450
Instance terminated by USER, pid = 2423
ORA-1092 signalled during: ALTER DATABASE OPEN...

And this is tail of /usr/lib/oracle/xe/app/oracle/admin/XE/udump/xe_ora_2423.trc:

*** 2022-10-24 17:02:49.712
KCRA: start recovery claims for 78 data blocks
*** 2022-10-24 17:02:49.721
KCRA: blocks processed = 78/78, claimed = 78, eliminated = 0
*** 2022-10-24 17:02:49.721
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1791 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 78/78 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 377/377 = 1.0
----------------------------------------------
*** 2022-10-24 17:02:51.204
Process QMNC is dead (pid=2545, state=3):
*** 2022-10-24 17:02:51.204
KSTDUMP: In-memory trace dump
TIME:SEQ#        ORAPID   SID EVENT  OP DATA
========================================================================
8DBD1DEB:0000066E    18    38 10254  34 KSBS1P: process USER trying to start background QMNC
8DBD1DEF:0000066F    18    38 10254  37 KSBS1P: process USER obtained PR enqueue to start background QMNC
8DCC0868:0000067C    18    38 10254  51 KSBS1P: out of loop: process did not start
KSTDUMP: End of in-memory trace dump
*** 2022-10-24 17:02:51.204
ORA-00443: background process "QMNC" did not start
ORA-00450: background process 'QMNC' did not start
ORA-00443: background process "QMNC" did not start

**UPDATE** OK, I succeed to connect to MOUNTed instance of DB using oracle account session, I tried ALTER DATABASE OPEN:

[root@MOBILE_TEST bdump]# su - oracle
-bash-4.1$ pwd
/usr/lib/oracle/xe
-bash-4.1$ groups
dba
-bash-4.1$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 24 17:45:10 2022

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

Connected to an idle instance.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available


SQL>

**UPDATE** I put logging in oracle-xe:

start() {
        MAXI_LOG="/root/temp/ora.log"
        echo $(date) >> $MAXI_LOG

        if [ "$CONFIGURE_RUN" != "true" ]
        then
        echo "Oracle Database 10g Express Edition is not configured.  You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database."
                exit 0
        fi

        status=ps -ef | grep tns | grep oracle
        if [ "$status" == "" ]
        then
                echo "TNSLSTENER" >> $MAXI_LOG
                if [ -f $ORACLE_HOME/bin/tnslsnr ]
                then
                        echo "Starting Oracle Net Listener."
                        $SU -s /bin/bash $ORACLE_OWNER -c "$LSNR  start" > /dev/null 2>&1
                fi
        fi

        echo "Starting Oracle Database 10g Express Edition Instance."
        echo "START" >> $MAXI_LOG
        $SU -s /bin/bash  $ORACLE_OWNER -c "$SQLPLUS -s /nolog @$ORACLE_HOME/config/scripts/startdb.sql" >> $MAXI_LOG 2>&1
        RETVAL=$?

        if [ $RETVAL -eq 0 ]
        then
                echo "GOOD" >> $MAXI_LOG
                echo
        else
                echo Failed to start Oracle Net Listener using $ORACLE_HOME/bin/tnslsnr\
                        and Oracle Express Database using $ORACLE_HOME/bin/sqlplus.
                echo "BAD" >> $MAXI_LOG
                RETVAL=1
        fi

        return $RETVAL
}

I rebooted the system several times, here is what we have in $MAXI_LOG:

25.10.2022 17:31:32 MSK 2022
TNSLSTENER
START
ORACLE instance started.

Total System Global Area  532676608 bytes
Fixed Size                  1259880 bytes
Variable Size             150996632 bytes
Database Buffers          377487360 bytes
Redo Buffers                2932736 bytes
Database mounted.
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
GOOD
25.10.2022 17:33:25 MSK 2022
TNSLSTENER
START
ORACLE instance started.

Total System Global Area  532676608 bytes
Fixed Size                  1259880 bytes
Variable Size             150996632 bytes
Database Buffers          377487360 bytes
Redo Buffers                2932736 bytes
Database mounted.
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
GOOD

I use ls -t --full-time . | head -10 for see last traces, this is what I have:

[root@MOBILE_TEST ~]# cd /usr/lib/oracle/xe/app/oracle/admin/XE/bdump/
[root@MOBILE_TEST bdump]# ls -t --full-time . | head -10
итого 16780
-rw-r--r--. 1 oracle dba 1906729 2022-10-25 17:33:34.694999956 +0300 alert_XE.log
-rw-r-----  1 oracle dba   39525 2022-10-25 17:02:32.848999960 +0300 xe_lgwr_2361.trc
[root@MOBILE_TEST udump]# ls -t --full-time . | head -10
итого 8976
-rw-r-----  1 oracle dba    3385 2022-10-25 17:33:30.663999958 +0300 xe_ora_2376.trc
-rw-r-----  1 oracle dba    8643 2022-10-25 17:33:27.485999961 +0300 xe_ora_2343.trc
-rw-r-----  1 oracle dba    5126 2022-10-25 17:31:37.601999962 +0300 xe_ora_2385.trc

This is tail of xe_ora_2385.trc:

*** SERVICE NAME:() 2022-10-25 16:34:08.669
*** SESSION ID:(38.1) 2022-10-25 16:34:08.669
kccsga_update_ckpt: num_1 = 8, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
/usr/lib/oracle/xe/app/oracle/admin/XE/udump/xe_ora_2376.trc
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
System name:    Linux
Node name:      MOBILE_TEST.domain.central
Release:        2.6.32-696.1.1.el6.i686
Version:        #1 SMP Tue Apr 11 16:37:48 UTC 2017
Machine:        i686
Instance name: XE
Redo thread mounted by this instance: 0 
Oracle process number: 18
Unix process pid: 2376, image: oracle@MOBILE_TEST.domain.central (TNS V1-V3)

*** SERVICE NAME:() 2022-10-25 17:33:30.664
*** SESSION ID:(38.1) 2022-10-25 17:33:30.664
kccsga_update_ckpt: num_1 = 8, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0

**UPDATE** I set /etc/security/limits.conf:

*          hard    nproc     32768
*          hard    nofile    32768

Logged ulimit in init script:

$SU -s /bin/bash $ORACLE_OWNER -c "ulimit -a | grep '\-[nu]'" >> $ORA_LOG 2>&1

And see, that there is no issue with limits:

Wed Oct 26 17:04:28 MSK 2022
open files                      (-n) 32768
max user processes              (-u) 32768

Also I put Y in /etc/oratab. But the broblem is still exists...

I have Oracle XE 21c and HammerDB 4.4. The task is to benchmark database. Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 Well, because of that I've done the command below after 'sqlplus system/pass_of_sys': alter session set container=XEPDB1; (that's the name of pluggable DB); create tablespace tpcctab datafile 'tpcctab.dat' size 8G autoextend on; create temporary tablespace tpcctemp tempfile 'tpcctemp.dat' size 4G autoextend on; And I've created HammerDB creating schema script which runs on local machine: dbset bm TPROC-C dbset db ora diset connection system_user system diset connection system_password pass_of_sys diset connection instance 192.168.192.11/XEPDB1 diset tpcc tpcc_user tpcc diset tpcc tpcc_pass tpcc diset tpcc tpcc_def_tab tpcctab diset tpcc tpcc_def_temp tpcctemp diset tpcc count_ware 4 diset tpcc num_vu 3 buildschema .... and driver script which runs on another machine in the same network: dbset db ora dbset bm TPROC-C diset connection system_user system diset connection system_password pass_of_sys diset connection instance 192.168.192.11/XEPDB1 diset tpcc tpcc_user tpcc diset tpcc tpcc_pass tpcc diset tpcc ora_driver timed diset tpcc rampup 1 diset tpcc duration 1 diset tpcc checkpoint true diset tpcc total_iterations 1000 diset tpcc allwarehouse true loadscript vuset vu 3 vuset logtotemp 1 vucreate vurun Every time first script creates tpcc user, both then executes several transactions and fails - even if to write **'diset connection instance 192.168.192.11:1521/XEPDB1'**, Oracle XE returns different errors, every time error is different: - KPEDBG_HDL_PUSH_FCPTRMAX; - KPEDBG_HDL_POP_FCPTR; - KPEDBG-...TLSORA-24550 and smth else. Moreover, rampup period does not start. If in driver script in string **'diset tpcc total_iterations 1000'** write more than 1000, or in **'diset tpcc duration 2'** write more than 1 - driver script fails even with no transaction with the same error codes.... And of course I know about XE limitations. So WHAT should I do to come over that task? Any ideas, please?((

I have an Oracle XE database on computer1. When I try to connect to it via sqlplus from computer2, it works fine, for both cdb and pdb connections; e.g.: rlwrap sqlplus timon@//192.168.0.115:9121/xepdb1 SQL*Plus: Release 21.0.0.0.0 - Production on Tue Jun 21 09:40:00 2022 Version 21.6.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Enter password: Last Successful login time: Tue Jun 21 2022 09:39:11 +03:00 Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 SQL> When I try to connect to it via DataGrip IDE: - I can connect to container database with username "sys as sysdba" - I cannot connect to pluggable database xepdb1. Settings are following: Error is following: How can I fix it?

I have hit a rather frustrating snag in that after installing Oracle 18c. I have been unable to successfully create a user and then connect to it. More precisely I can create the user but the connection keeps failing. The commands I’m using are below along with the failed connection attempt. If you have any suggestions it would be greatly appreciated. I first connect to Oracle as root and then connect to the container XEPDB1 sqlplus system/password SQL>ALTER SESSION SET CONTAINER = XEPDB1; I then do the following to create a user. SQL>create user paul identified by Guardium111; SQL>grant connect to paul; SQL>grant create session to paul; SQL>alter user paul default role all; Everything above works without error. When I try to connect to user paul I get the following. I’m tearing what little is left of my hair out trying to understand what the issue is. SQL> conn paul Enter password: ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE.

I am trying to install APEX 19.1 on ORACLE XE 18c but the problem is that APEX_LISTENER and APEX_REST_PUBLIC_USER are not being created. While I execute apex_rest_config.sql script via sqlplus, an error message appears saying: **GetConsoleMode failed, Last Error=|6|** Then I check the list of users and I see that these two users are not created. Is this a bug of APEX installation? Please can anybody help?

**Command**: GRANT SELECT ON ALL_CATALOG TO appdbuser * **Error**: ERROR at line 1: ORA-01031: insufficient privileges **PROBLEM**: > I want my Oracle XE system user ( ALL_CATALOG, ALL_CONSTRAINTS, ALL_INDEXES, ALL_OBJECTS, ALL_TABLES, > ALL_TAB_COLUMNS and ALL_VIEWS. **DMBS**: Oracle XE 18c (Express Edition), Version 18.4 **Client(s)**: SQL Developer 20.2.0.175 AND also with SQL Plus 12.2.0.0 **Operating System**: Windows 10 Pro Build 18363 **User(s) & Privileges**: 1. The Windows user that I am logged in with *is* a domain user account which is part of Windows Administrators group on my machine. 2. I have installed this DB on my own machine with this same user, that I am currently logged in with. 3. I have also verified that this user is included in ORA_DBA Windows user group. The image below shows a list of other groups on my Windows machine that start with ORA. 4. I am connected as system user (tried both via sqlplus and sql developer) to Oracle XE DB (pluggable DB *not* CDB). 5. I connected to the DB with sys/password as sysdba and executed the following command *with success*:

ALL PRIVILEGES TO system;

but the GRANT SELECT ON commands still gives the Insufficient privileges error. 6. If it matters, I have checked that NTS is included as Authentication service in my sqlnet.ora file like this: SQLNET.AUTHENTICATION_SERVICES= (NTS) 7. (EDIT1) As per this answer I have now also tried

ALL PRIVILEGES TO system WITH GRANT OPTION;

which gives me following error report Error report - ORA-01939: only the ADMIN OPTION can be specified 01939. 00000 - "only the ADMIN OPTION can be specified" *Cause: System privileges and roles can only be granted with the admin option. The grant option cannot be used with system privileges and roles. The delegate option cannot be used with system privileges. *Action: Specify the admin option. 8. After 7, I tried

ALL PRIVILEGES TO system WITH ADMIN OPTION;

with success, as in Grant succeeded, but my problem is still there. **More Context** 1. This command is part of a SQL script generated by a batch script, ***neither*** of which I want to or can change, as that is used by a larger team and based on given parameters these scripts already work for MS SQL Server and Oracle 12.2.0.1.0 on a Linux machine (however the IT has set it up), which is maintained by our IT and we have limited (2) licenses for it only. Hence, I am setting up Oracle XE on my machine and want something to be repeatable so other devs can just do it from my experience. 2. When I executed this script by logging in with system/password as sysdba, these GRANT commands inside the SQL script worked, but even this logging in is coded in script, which I don't want and most likely shouldn't change. Its ok if I provide the devs with an additional script for them to execute before they use the standard scripts. 3. This script in question is also creating the users, to whom the script is now GRANTing rights. There were errors in those CREATE USER commands too, because the CREATE USER command specifies a DEFAULT TABLESPACE user_data and a TEMPORARY TABLESPACE temporary_data. The DB complained about these not existing in database (xepdb1), so I created these tablespaces with system user using following commands:

CREATE TABLESPACE user_data 
       DATAFILE '\XE\XEPDB1\user_data.dbf' SIZE 1M 
       AUTOEXTEND ON NEXT 1M;
    
   CREATE TEMPORARY TABLESPACE temporary_data
       TEMPFILE '\XE\XEPDB1\temporary_data.dbf' SIZE 2M 
       AUTOEXTEND ON NEXT 1M;

I'm using Rails 6 with activerecord-oracle_enhanced-adapter adapter for Oracle 11 XE database. At the beginning of the project I was working with Postgres, but due to customer requirements I had to migrate to Oracle. My question is very similar to https://stackoverflow.com/questions/592444/rails-rake-dbmigrate-very-slow-on-oracle , but it's from 11 years ago, i'm using the updated version of the adapter. I know that after all migrations are applied to database then rake db:migrate calls db:schema:dump task to generate schema.rb file from current database schema. I only have one schema, with many tables (around 90) The answer for the previous question was something like > One way how to debug this issue would be if you would put some debug > messages in oracle_enhanced_adapter.rb file so that you could identify > which method calls are taking so long time. == 20200820164111 RemoveSemesterFromProject: migrated (0.1347s) =============== real 13m26,038s user 0m5,494s sys 0m0,401s All migrations finished in an reasonable time, so I think the error occurs in the following action "db: schema: dump" but i don't have oracle_enchaced_adapter.rb neither oracle_enhanced_adapter.rb, so i don't know where to look at. What can i do for improve this behaviour? Time that takes when i run db:schema:dump

real	9m44,074s
user	0m3,701s
sys	0m0,327s

and this is the time that takes when i run db:structure:dump

real	21m40,073s
user	0m5,046s
sys	0m0,413s

I have this very strange observation on my Windows 10x64 machine: Given the following script file (file name test.sql):

DEFINE SYS_NAME = &1
DEFINE SYS_PWD = &2
DEFINE ORACLE_HOME = &3

CONNECT &SYS_NAME/&SYS_PWD@//localhost:1521/xe AS SYSDBA

SET VERIFY OFF
SET SERVEROUTPUT ON
-- SET FEEDBACK OFF

WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK;
WHENEVER OSERROR EXIT FAILURE ROLLBACK;

---- enable DBMS_OUTPUT ---------
ALTER SESSION SET CONTAINER=CDB$ROOT;
@&ORACLE_HOME/rdbms/admin/dbmsotpt.sql

---- run SQL scripts ---------
BEGIN
  DBMS_OUTPUT.PUT_LINE('Database script initialization finished.');
  DBMS_OUTPUT.PUT_LINE('');
  END;
  /

DISCONNECT

@aaaaaaaaaaaa

EXIT

When I call this script against my local Oracle DB 18.4 XE Windows installation with appropriate arguments, like:

sqlplus -S /nolog '@C:\Temp\sql\test.sql' sys *** 'C:\app\Me\product\18.0.0\dbhomeXE'

Using **SQL*Plus 19.11.0.0.0** I get this output (translated from German):

Session changed.

OS Message: No such file or directory

Using **SQL*Plus 18.4.0.0.0** I get this output (again, translated from German):

Session changed.


Session changed.


Type created.


Package created.


Synonym created.


Synonym created.


User access granted.


User access granted.


Session changed.

Database script initialization finished.

PL/SQL Procedure successfully finished.

So, using **SQL*Plus 19.11.0.0.0**, neither the built-in SQL Script nor my script (@aaaaaaaaaaaa for demonstration purposes) is getting called. Using **SQL*Plus 18.4.0.0.0**, the built-in SQL Script seems to be getting called, but my script (@aaaaaaaaaaaa for demonstration purposes) is not getting called.
Why isn't this working? NB: The same script is working flawlessly when run in an Oracle 18c XE Linux Docker container.

When I tried to install Oracle 11g XE into my machine (Windows XP media center edition, version 2002 SP3) I'm getting an error as 0x80040702 Description: Failed to load DLL:chkportDll2 I've googled, but not found any suitable answer.

New to Oracle DB administration here. I have a fresh localhost installation of Oracle XE 11.2.0 (x64 installation from here ) on my computer using Windows 10 64-bit. I am able to connect to the DB using both DataGrip using SYS as SYSDBA user and I am able to connect using sqlplus command-line tool. I typed an admin password on installation but somehow I am able to connect using sys password sqlplus sys/sys as sysdba (as I said, I am an Oracle DB rookie). I have to import an exported EXP.DMP file from a colleague using the following command:

impdp.exe 'sys/sys as sysdba' FULL=Y DUMPFILE=exp.dmp REUSE_DATAFILES=Y TABLE_EXISTS_ACTION=REPLACE

Windows starts to complain: And the following line appears in the command line:

c:\oraclexe\app\oracle\product\11.2.0\server\bin>impdp.exe 'sys/sys as sysdba' FULL=Y DUMPFILE=exp2.dmp REUSE_DATAFILES=Y TABLE_EXISTS_ACTION=REPLACE
Access is denied.

c:\oraclexe\app\oracle\product\11.2.0\server\bin>

**Important note:** I have tried to **export** instead to exp2.dmp in order to try another command and it works with no issue:

c:\oraclexe\app\oracle\product\11.2.0\server\bin>expdp.exe 'sys/sys as sysdba' FULL=Y DUMPFILE=exp2.dmp directory=DATA_PUMP_DIR logfile=exp.log

Export: Release 11.2.0.2.0 - Production on Tue Mar 9 14:41:51 2021

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
Starting "SYS"."SYS_EXPORT_FULL_01":  "sys/******** AS SYSDBA" FULL=Y DUMPFILE=exp2.dmp directory=DATA_PUMP_DIR logfile=exp.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 161.2 MB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
... omitted ...
Processing object type DATABASE_EXPORT/AUDIT
. . exported "APEX_040000"."WWV_FLOW_PAGE_PLUGS"         27.16 MB   38892 rows
... omitted ...
. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE"              0 KB       0 rows
Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
  C:\ORACLEXE\APP\ORACLE\ADMIN\XE\DPDUMP\EXP2.DMP
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at 14:42:55


c:\oraclexe\app\oracle\product\11.2.0\server\bin>

___________ How to make the import successful? **Edit:** I have noticed something very odd in the C:\oraclexe\app\oracle\product\11.2.0\server\bin folder. I have installed the database engine using setup.exe and everything went smoothly. What's going on? Can I download the file anywhere for 11.2.0 XE without the un/installing again which would take another hour?