In this small tutorial, I want to show you how to drop the database without using the GUI tool DBCA 1- Export database SID if not yet Already defined export ORACLE_SID=database 2- Connect as sysdba [oracle@Ora
Oracle has again proved why it’s a leading player in the database market by releasing its latest version,Oracle Database 23c(code-named “App Simple”), for free on April 3, 2023. This is a bold step by Oracle that will disrupt the database market and make it the go-to database f...
Oracle Databaseis a robust relational database management system (RDBMS) known for its scalability, reliability, and advanced features like high availability and security. Oracle offers an integrated portfolio of cloud services featuring IaaS, PaaS, and SaaS, posing competition to big cloud providers....
[SQLPlus](https://docs.oracle.com/cd/B19306_01/server.102/b14357/qstart.htm) is an interactive tool that comes installed with every modern Oracle installation. SQLPlus allows you to go beyond the standard database queries with batches, scripts, and calculations beyond the normal scope of Orac...
In this blog post, we’ll show you how to use SQL*Plus and related utilities to single-sign-on to the Oracle Autonomous Database. The next blog post will cover SQLcl. Here is the overall solution architecture: There are three key steps: ...
In Oracle RAC, clients access one of three scan listeners and are then routed to database listeners. To support SSL all of these listeners must have TCPS protocol endpoints. Follow steps 1.1 & 1.2 below to add TCPS endpoints to the database (node) listeners and then the scan listeners. ...
You can use the CloudWatch Logs Insights purpose-built query language to interactively search and analyze your log data in CloudWatch Logs. The following steps show how to create an analysis for common Oracle errors in the alert log and client connections in the liste...
If the database is hung then we need to gather systemstate dumps to try to determine what is happening. At least 3 dumps should be taken as follows: Login to sqlplus as the internal user: sqlplus "/ as sysdba" rem -- set trace file size to unlimited: ...
Since the broker enables real-time apply by default, the left job is only to alter the standby database to read only. 1. Make sure the value of compatible is at least 11. [oracle@standby01 ~]$ sqlplus / as sysdba ... SQL> show parameter compatible ...
SAP Managed Tags: Oracle Database Can you please tell me how to "disable databse log mode", In another word, how to set "Database log mode" parameter to "No Archive mode", using brtools or using sqlplus, what is the exact database parameters? BTW, I am not talking about Automat...