Oracle Java Blog
-
RMAN Full Backup & Demo
https://blog.zeddba.com/2019/05/23/rman-full-backup-demo/ more
-
Exploring the new SSB Schema with SQL Developer Web
https://www.thatjeffsmith.com/archive/2019/06/exploring-the-new-ssb-schema-with-sql-developer-web/ more
-
Oracle Docker Images
https://github.com/oracle/docker-images more
-
EM 13c Install / Upgrade : _allow_insert_with_update_check Prerequisite Check Failed
13cR2 OMS Install / Upgrade fails during prerequisite checks with a message on the 12.2 Database Connection Details page:
Check if the parameter _allow_insert_with_update_check is TRUE
Prior to … more
-
EM Express versus EM Cloud Control
https://petewhodidnottweet.com/2015/05/em-express-versus-em-cloud-control/
https://www.oracle.com/technetwork/database/manageability/emx-intro-1965965.html more
-
How to Run a Java .Jar File
1) Install the JDK
2) Check if UAC needs to be disabled and then open a command prompt (Run As Administrator)
3) Navigate to the directory that has the jar file you wish to run
3) use the command: … more
-
Debugging PL/SQL in Apex from SQL Developer
https://www.thatjeffsmith.com/archive/2019/05/debugging-pl-sql-in-apex/ more
-
Oracle Outlines
https://oracle-base.com/articles/misc/outlines
http://psoug.org/reference/outlines.html
https://docs.oracle.com/cd/E25178_01/server.1111/e16638/outlines.htm
https://blog.dbi-services.com/sql-plan- … more
-
Create Scheduled Job in Oracle to Execute Batch File
from AskTime:
I just did this on my machine with no problems -
C:\>type c:\temp\demo.cmd
@echo off
echo Hello > c:\temp\demo.out
dir c:\temp >> c:\temp\demo.out
exit
SQL> declare
2 … more
-
Force Oracle Database Listener to Listen on Specific IP Addresses For VPN Connections
1) First, add the IP address of the database server (the ip address of the machine on the VPN network) as a listening location in Net Manager, and also specify the Port Number to connect to the … more
-
SQLPlus Command-Line Syntax for Connection
sqlplus user/[email protected](description=(address_list=(address=.......ODS)))will work (use quotes if in Unix else the () are interpreted by the shell)
that url-like syntax is supported by (much) later … more
-
Oracle Database Change Port
https://help.blackboard.com/Learn/Administrator/Hosting/Databases/Database_Ports_Oracle
http://sumations.net/i/doc/XEDBA/network005.htm
-
Changing Oracle Ports
https://docs.oracle.com/cd/B19306_01/install.102/b15660/app_port.htm
-
Check Oracle TNS Listener Status
lsnrctl status more
-
Check Oracle Console Errors (dbconsole)
emctl status dbconsole more
-
Internet Resources for Learning Oracle ADF and JDeveloper
https://www.quora.com/Good-resource-in-internet-to-learn-using-ADF-in-JDeveloper
-
Unexpire Oracle Password
sourc: http://www.dba-oracle.com/t_unexpire%20password.htm
Step 1: Create a profile to use by all Oracle ID's: create profile my_profile limit password_life_time unlimited; Step 2: Alter … more
-
Difference between Physical standby and Logical standby database
source: http://dbatrainer.com/difference-between-physical-standby-and-logical-standby-database/
Data Guard Apply process in standby database can apply redo information directly and in that case it … more
-
Oracle Fine-Grained Auditing is Only Available in Enterprise Edition
https://docs.oracle.com/cd/E18283_01/appdev.112/e16760/d_fga.htm
You can check version by using:
SELECT * FROM V$VERSION
The word Enterprise will be missing if it isn't the Enterprise Edition. more
-
Oracle Pragma Autonomous Transaction
CREATE FUNCTION FN_MYAPP_WS_LOGGERreturn VARCHAR2as PRAGMA AUTONOMOUS_TRANSACTION;BEGIN
/* needs grant select on v$session (or any dictionary), but not via role */INSERT INTO MYAPP_WS_LOGGERSELECT * … more