Oracle Java Blog
-
Oracle Enterprise Manager Port 5500 Not Working When Called From Remote Machine
8 Using Enterprise Manager Express
You can leverage all the functionality and ease of use of Enterprise Manager (EM) to manage your XE database.
To connect to EM Express, go to https:// … more
-
ORA-28040: No matching authentication
Bug 14575666 In 12.1, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. This means that database clients using pre-11g JDBC thin drivers cannot authenticate to 1 … more
-
Oracle Business Intelligence
https://www.oracle.com/middleware/technologies/bi-enterprise-edition-downloads.html
https://www.oracle.com/middleware/technologies/business-intelligence-v12214-downloads.html
-
Oracle AWR report in-depth analysis
https://www.ibm.com/downloads/cas/WNK5D2QZ
https://oracle-base.com/articles/10g/automatic-workload-repository-10g
https://www.oracle.com/technetwork/database/manageability/diag-pack-ow09-133950.pdf … more
-
Steps to Analyze AWR Report in Oracle
http://nonfunctionaltestingtools.blogspot.com/2015/04/steps-to-analyze-awr-report-in-oracle.html
-
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/password@(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