I am trying to start up an oracle database server locally. My goal is to have a schema with a user, what my application can use then. I am somewhat familiar with Oracle database, but I am a beginner with DBA things (previously DBAs created schema / user for me). So I used the "doctorkirk" image: https://registry.hub.docker.com/r/doctorkirk/oracle-19c I followed the instructions and I executed this command to get the image: sudo docker pull doctorkirk/oracle-19c then started up the image with this command: sudo docker run --name oracle-19c -e ORACLE_PDB=orcl -e ORACLE_PWD=password -v /opt/oracle/oradata:/opt/oracle/oradata -p 11521:1521 -p 15500:5500 doctorkirk/oracle-19c The output is this: cat: /sys/fs/cgroup/memory/memory.limit_in_bytes: No such file or directory cat: /sys/fs/cgroup/memory/memory.limit_in_bytes: No such file or directory /opt/oracle/runOracle.sh: line 102: [: -lt: unary operator expected ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN: password LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 15-JAN-2025 12:25:50 Copyright (c) 1991, 2020, Oracle. All rights reserved. Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 19.0.0.0.0 - Production System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora Log messages written to /opt/oracle/diag/tnslsnr/95fe0518c5bb/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 15-JAN-2025 12:25:50 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora Listener Log File /opt/oracle/diag/tnslsnr/95fe0518c5bb/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) The listener supports no services The command completed successfully [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. CAUSE: a. 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]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. CAUSE: a. 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]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. Prepare for db operation 10% complete Copying database files 40% complete Creating and starting Oracle instance 42% complete 46% complete 50% complete 54% complete 60% complete Completing Database Creation 66% complete 69% complete 70% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at: /opt/oracle/cfgtoollogs/dbca/ORCLCDB. Database Information: Global Database Name:ORCLCDB System Identifier(SID):ORCLCDB Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details. SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 15 12:33:00 2025 Version 19.9.1.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.1.0.0 SQL> System altered. SQL> System altered. SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.1.0.0 The Oracle base remains unchanged with value /opt/oracle ######################### DATABASE IS READY TO USE! ######################### The following output is now a tail of the alert.log: 2025-01-15T12:33:00.200091+00:00 AQPC started with pid=43, OS id=2837 Starting background process CJQ0 2025-01-15T12:33:00.279886+00:00 CJQ0 started with pid=48, OS id=2849 Completed: ALTER DATABASE OPEN 2025-01-15T12:33:00.663094+00:00 ALTER SYSTEM SET control_files='/opt/oracle/oradata/ORCLCDB/control01.ctl' SCOPE=SPFILE; 2025-01-15T12:33:00.669302+00:00 ALTER SYSTEM SET local_listener='' SCOPE=BOTH; 2025-01-15T12:33:00.765152+00:00 QPI: opatch file present, opatch QPI: qopiprep.bat file present 2025-01-15T12:33:02.444120+00:00 Shared IO Pool defaulting to 128MB. Trying to get it from Buffer Cache for process 2811. 2025-01-15T12:33:02.505232+00:00 Resize operation completed for file# 3, old size 450560K, new size 460800K 2025-01-15T12:33:02.579912+00:00 =========================================================== Dumping current patch information =========================================================== Patch Id: 29585399 Patch Description: OCW RELEASE UPDATE 19.3.0.0.0 (29585399) Patch Apply Time: 2019-04-18T07:21:33Z Bugs Fixed: 3,27222128,27572040,27604329,27760043,27877830,28302580,28470673, 28621543,28642469,28699321,28710663,28755846,28772816,28785321,28800508, 28808652,28815557,28847541,28847572,28870496,28871040,28874416,28877252, ... 31781897,31792615,31796208,31796277,31816631,31820859,31833172,31867037, 31872230,31876368,31886547,31888148,31897786,31905033,31909295,31921267, 31927930,31935717,31952052,32007698,32010707,32050048,32069834,32089820, 32105135,32129659,32172777,32212635,32234161,32296941,32321765 =========================================================== 2025-01-15T12:37:18.357290+00:00 *********************************************************************** Fatal NI connect error 12537, connecting to: (ADDRESS=(PROTOCOL=tcp)(HOST=172.17.0.1)(PORT=55358)) VERSION INFORMATION: TNS for Linux: Version 19.0.0.0.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production Version 19.9.1.0.0 Time: 15-JAN-2025 12:37:18 Tracing not turned on. Tns error struct: ns main err code: 12537 TNS-12537: TNS:connection closed ns secondary err code: 12560 nt main err code: 507 TNS-00507: Connection closed nt secondary err code: 0 nt OS err code: 0 2025-01-15T12:37:18.362695+00:00 opiodr aborting process unknown ospid (3332) as a result of ORA-609 So to me it seems that the database is up and running, and the sys password is password. However, when I try to connect as sys (in order to create my schema) I have this error: ~/tools/instantclient_21_12$ ./sqlplus -S "sys/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=11521))(CONNECT_DATA=(SERVICE_NAME=orcl)))" ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor In sqldeveloper I have the same error. What is my mistake?

We have been running a list of commands in cli: sqlplus / as sysdba We did not have "history on" and we logged out of the session. How do we get the list of sql statements we ran before as sysdba? We tried the following: SELECT h.sample_time, u.username, h.program, h.module, s.sql_text FROM DBA_HIST_ACTIVE_SESS_HISTORY h, DBA_USERS u, DBA_HIST_SQLTEXT s WHERE sample_time >= SYSDATE - 1 AND h.user_id=u.user_id AND h.sql_id = s.sql_iD ORDER BY h.sample_time Also tried select * from v$sql

Having an issue on one of our SQL servers at work in which the SQL backup folder permissions are not right and the folder is inaccessible. I just noticed this problem when attempting to setup nightly maintenance plans. Even though I'm logged in with my domain admin account, I still don't have access to the folder. I'm not the one who set this server up so I'm not sure how it got in this state. Any ideas?

**→ OS: Oracle Linux Server release 8.7** **→ DBMS: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production - Version 19.3.0.0.0** After cloning a virtual machine that we can connect normally on sqlplus with sys user, we cannot say the same about the clone and reconfigured machine, even change sys password and putting the right one: > oracle@somedb ~]$ sqlplus sys@somecdb as sysdba > > SQL*Plus: Release 19.0.0.0.0 - Production on Seg Set 23 09:39:55 2024 > Version 19.3.0.0.0 > > Copyright (c) 1982, 2019, Oracle. All rights reserved. > > Informe a senha: ERROR: ORA-01017: senha/nome do usu�rio inv�lido; > log-on negado But I can connect with SYSTEM user and probably with the other users, on both machines: > oracle@somedb ~]$ sqlplus system@somecdb > > SQL*Plus: Release 19.0.0.0.0 - Production on Seg Set 23 09:56:01 2024 > Version 19.3.0.0.0 > > Copyright (c) 1982, 2019, Oracle. All rights reserved. > > Informe a senha: Hor�rio do �ltimo log-in bem-sucedido: Seg Set 23 > 2024 09:03:09 -03:00 > > Conectado a: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 > - Production Version 19.3.0.0.0 > > SQL> The root connection is ok (sqlplus / as sysdba), but the CDB connection not - same problem happens trying to connect with SQL Developer. How can I solve it?

I am a SQL Server developer/DBA consultant who is helping out a customer who recently lost their Oracle DBA. I have done development on Oracle, but not much DBA work, and not in multi-homed environments like this. **The Problem:** I can connect using "SYS As SYSDBA" from SQL Plus, but *not* from SQL Developer on the same system. However, I *can* connect using "system" with either SQL Plus *or* SQL Developer. **Details:** On this server, in my windows Admin account (also entered as server administrator in Oracle Admin Asst.), this DOS command works: D:\Oracle\app\product\11.2.0\dbhome_1\BIN>sqlplus /@MyDb as sysdba and, Select * from V$INSTANCE shows that it is in MyDb and that both tool and db are 11.2.0.3 So does this one: D:\Oracle\app\product\11.2.0\dbhome_1\BIN>sqlplus sys/@MyDb as sysdba (ALSO: entering the *wrong* password works as well(!)) Using SQL-Plus start menu option from same (sever, account and home), these also work: Enter user-name: /@MyDb as sysdba Enter user-name: sys/@MyDb as sysdba Select * from V$INSTANCE shows that it is in MyDb and that both tool and db are 11.2.0.3 Attempt to access MyDb from same with SQL Developer, succeeds for "system" username, but fails for "sys" "as sysdba" with “ORA-01031:insufficient privileges”. However, this *does* work when connecting to other databases on other servers. I have researched this, and most of the posted help for this seems to be aimed at cases where no connections at all can be made, which is not the case here. Just to head off some of these: - The problem isn't that the network isn't setup, because SQL Developer works for "system" both locally and remotely. - The problem isn't that the DB/Instance isn't started, because again, it works for "system" - It's not that I am connecting to the wrong database, I checked it for "system" - AFAIK, it's not that I am using the wrong syntax in SQL Developer to connect to a DB "As SYSDBA" because it works when I connect to other servers on other DBs. My gut feel is that either 1. there's some setting that says "*don't allow SYSDBA through a network connection*", or 2. there's some configuration/authorization problem in the Oracle network Listener that is preventing it from checking my windows admin account, and additionally, the sys password is not what I was told it was, and finally Oracle is giving an obtuse error message for that. Any help or guidance on this would be greatly appreciated. ------- OK, so using instructions from @BalasPapp, I was able to find more the following: - This database is serviced by the *second* Oracle 11g home called OraDb11g_home3 pathed to D:\Oracle\app\product\11.2.0\dbhome_1D:\Oracle\app\product\11.2.0\dbhome_1. - Windows services showed *no* startup parameters for it (except the DB name, of course). - the command show parameter remote_login_passwordfile shows a value of "**EXCLUSIVE**". Contents of Listener.ora: # listener.ora Network Configuration File: D:\Oracle\app\product\11.2.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\Oracle\app\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\Oracle\app\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ..local)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = D:\Oracle\app Contents of sqlnet.ora: # This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT. SQLNET.AUTHENTICATION_SERVICES = (NTS) The output of lsnrctl status: D:\Oracle\app\product\11.2.0\dbhome_1\BIN>lsnrctl status LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 23-DEC-2015 12:03:55 Copyright (c) 1991, 2011, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=..local)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production Start Date 02-DEC-2015 16:25:41 Uptime 20 days 19 hr. 38 min. 17 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File D:\Oracle\app\product\11.2.0\dbhome_1\network\admin\listener.ora Listener Log File D:\Oracle\app\diag\tnslsnr\\listener\alert\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=..local)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "" has 1 instance(s). Instance "", status READY, has 1 handler(s) for this service... The command completed successfully D:\Oracle\app\product\11.2.0\dbhome_1\BIN> Parameters when connecting from SQL Developer: Username: system (or sys) Password: Connection Type: Basic Role: Default (or SYSDBA) Hostname: localhost Port: 1521 SID (or Service name, both work/fail the same): (Neither OS Authentication nor Kerberos is set) Works for "system, Default", fails for "sys, SYSDBA" with "Insufficient privileges". I have tried many combinations of OS Authentication and Keberos settings as well, to no avail. Finally, these are the only two .ora files in the /database directory: SNCF.ORA (18MB) SPFILE.ORA (4kb) They both appear to be binary files in Notepad. ALSO: select * from v$pwfile_users returns no rows.

Nice to meet you all. This is the first time I have posted here, so please feel free to let me know if I am wrong. I am doing some research on the Transparent Data Encryption feature. I want to validate the ability to extract data without logging into the database instance and before encryption, by reading the .dbf file directly with HexEditor, Notepad++, or something equivalent. The problem is with the data type VARCHAR2; the value is plaintext, the same as the returns when I query in the instance. But with NUMBER, DATE, or anything that is not VARCHAR2, I cannot find plaintext in the .dbf *Datatypes of columns* *The returns when I query in the instance* *Hex Editor returns plaintext with VARCHAR2 datatype data…* *… but not with NUMBER datatype data* I did a lot of research on the Internet, but it seems there is no clear answer and no demo of the contents of data files before and after using TDE. Why is it like that? And more, I think that Oracle stores non-VARCHAR2 data types in binary format to save storage and VARCHAR2 data types for easily returning in query, am I correct? Thank you for any guidance! Vu Hoang.

While updating/copying the data from old column to new column we are facing the issue with tablespaces in database. Records count: 158 million+ Using below query to update the records, UPDATE TABLE_NAME SET NEW_COLUMN = OLD_COLUMN: I updated the tablespace for the 3 times, but issue is not resolve.

I am facing issue while decryption, Please help me if my column encryption/decryption process is wrong. I encrypted table in Source DB and back up certificate, then exported my encrypted table result to CSV from source DB. In the destination DB, I Created master Key, and using certificate backup (of my source DB) I created certificate in destination and then my symmetric key. Now I imported the CSV result into my destination DB table and running my decryption script. But it gives me NULL value. (Decryption works fine in source DB, same is not working in destination). Below is my sample script, ----AT MY SOURCE DB---- CREATE TABLE tbluser ( id INT, NAME VARCHAR(200), encryptname VARBINARY(200) ) INSERT INTO tbluser (id, NAME) VALUES (1, 'Raj'), (2, 'Vimal') CREATE master KEY encryption BY password = 'M@sterKey123' CREATE certificate testcert1 WITH subject = 'Test my Certificate'; BACKUP certificate testcert1 TO FILE = 'D:\DESKTOP\Certificate\TestCert1.cer' WITH private KEY ( FILE = 'D:\DESKTOP\Certificate\pkTestCert1.pvk', encryption BY password = 'Certific@te123' ); CREATE symmetric KEY symkeytest1 WITH algorithm = aes_256 encryption BY certificate testcert1; OPEN symmetric KEY symkeytest1 decryption BY certificate testcert1; UPDATE tbluser SET encryptname = Encryptbykey(Key_guid('SymKeyTest1'), NAME); CLOSE symmetric KEY symkeytest1; OPEN symmetric KEY symkeytest1 decryption BY certificate testcert1; SELECT TOP 5 NAME, CONVERT(VARCHAR(50), Decryptbykey(encryptname)) DecryptedName FROM tbluser; CLOSE symmetric KEY symkeytest1 DECLARE @str NVARCHAR(2000), @path NVARCHAR(200)='D:\DESKTOP\Certificate', @TableName NVARCHAR(100)='tbluser' SET @str = 'BCP Test.dbo.' + @TableName + ' OUT ' + @path + '\' + @TableName + '.csv -c -t^| -T -S MAILPTP45\SQL2012' EXEC Xp_cmdshell @str ----AT MY DESTINATION DB---- CREATE master KEY encryption BY password = 'M@sterKey123' CREATE certificate testcert1 FROM FILE = 'D:\DESKTOP\Certificate\TestCert1.cer' WITH private KEY(FILE = 'D:\DESKTOP\Certificate\pkTestCert1.pvk', decryption BY password = 'Certific@te123') CREATE symmetric KEY symkeytest1 WITH algorithm = aes_256 encryption BY certificate testcert1; CREATE TABLE tbluser ( id INT, NAME VARCHAR(200), encryptname VARBINARY(200) ) BULK INSERT [tbluser] FROM 'D:\DESKTOP\Test\tbluser.csv' WITH ( fieldterminator = '|', rowterminator = '\n' ) OPEN symmetric KEY symkeytest1 decryption BY certificate testcert1; SELECT TOP 5 NAME, CONVERT(VARCHAR(50), Decryptbykey(encryptname)) DecryptedName FROM tbluser; CLOSE symmetric KEY symkeytest1

I am experiencing some issue with my subscription (transactional replication) recently as whenever I tried to add a new subscription to my existing publication either way I use Initialize when Immediately or At first synchronization I always encountered issue resulting unsuccessful subscription. When I select initialize when Immediately, after I hit the finish button, I encountered this error: Message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Command Text: sp_MSreplupdateschema Parameters: @object_name = [dbo].[myTableName] Stack: at Microsoft.SqlServer.Replication.AgentCore.ReMapSqlException(SqlException e, SqlCommand command) at Microsoft.SqlServer.Replication.AgentCore.AgentExecuteNonQuery(SqlCommand command, Int32 queryTimeout) at Microsoft.SqlServer.Replication.AgentCore.ExecuteDiscardResults(CommandSetupDelegate commandSetupDelegate, Int32 queryTimeout) at Microsoft.SqlServer.Replication.Snapshot.TransSnapshotProvider.ConcurrentPreArticleFilesGenerationTransaction(SqlConnection connection) at Microsoft.SqlServer.Replication.RetryableSqlServerTransactionManager.ExecuteTransaction(Boolean bLeaveTransactionOpen) at Microsoft.SqlServer.Replication.Snapshot.TransSnapshotProvider.DoConcurrentPreArticleFilesGenerationProcessing() at Microsoft.SqlServer.Replication.Snapshot.TransSnapshotProvider.DoPreArticleFilesGenerationProcessing() at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot() at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun() at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQLServer, Error number: -2) Get help: http://help/-2 Server MyServerName, Level 11, State 0, Procedure , Line 0 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Source: MSSQLServer, Error number: -2) Get help: http://help/-2 Source: Target Site: Message: The wait operation timed out Stack: (Source: , Error number: 0) Get help: http://help/0 However if I select Initialize when At First Synchronization, it gives me the status of The initial snapshot for article myTableName is not yet available. Furthermore, if I reinitialize the subscription nothing happens Note: I am using SQL Server Standard 2019 Edition, Microsoft SQL Server Management Studio 2019 Here's also my Server specification: HP Proliant Gen10 + and my current system utilization via task manager

Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link? I am getting ORA-00942: table or view does not exist when tried to query the same.

Is it possible for Oracle database administrator to make direct changes in data contained in a row, for example, changing an amount of 50 to 500 either by typing into the database cell or by executing an update query? If so, how could it be restricted so that data changes could only input through ERP application?

I am connecting to Oracle DB with: sqlplus / as sysdba What is the default password for the sysdba user? I tried in net and found out the default password is change_on_install but it is not working for me. Does Oracle DB maintain some file or DB table where it stores the passwords?

I am using Oracle 12c on Linux. Using the enterprise manager database express, I am looking at the list of privileges and roles for the SYS user but I haven’t found the SYSDBA privilege assigned there. Is the SYS user a member of an Oracle role or Linux group with sysdba privilege? If so, which role or group?

If the SYSDBA privilege gives the grantee ultimate authority, then why does the SYS user also have the DBA role in addition to the SYSDBA privilege?

I don't know if I correctly understand the privileges of these built-in roles and users, but this is a list of the information that I have found: * The DBA and SYSDBA roles enable you to do everything. If this is true, then why are there two names for the same thing? * The SYSOPER role enables you to do everything except accessing users' data; * The SYS user has the DBA and SYSDBA roles, so they can do anything; * The SYSTEM user has the DBA role, so it seems that they could do anything, but I have read that they cannot do backups, recovery, and DB upgrade. Is my understanding correct?

Can a user connected as sysdba always bypass auditing mechanisms? What could be done to minimize (or prevent) auditing prevention?

I implemented a logical replication on PostgreSQL 14 (from AWS to on-premise) via windows. A few days we experience internet lags. When i checked the pg_stat_replication in publication source, it was totally empty but the pg_replication_slots has one row entry. I tried executing "alter subscription refresh publication" and also "alter subscription disable/enable" in the subscriber side but still no entry on the pg_stat_replication under publication source. What is the proper way to resume/continue the logical replication on the subscriber side?

Im using oracle 11g. I cannot access the software products since they are missing. When I cd to $ORACLE_HOME, there are no files under it. They are missing. I cannot access the sqlplus. What to do in this kind of case? I have input the correct environment and path.

**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;

we have noticed that our database server is getting so high CPU (more than 90 % used by mysqld process), the output of mysqltunner is shown below, can you help me please, i'm okay about the innodb_buffer_pool_instances(=7), but is there some other suggestions ?