Contents tagged with Oracle
-
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
-
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
-
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