We have a 10G (10.2) oracle DB on Windows 2003. This week we fired the DBA due to internal problems, but today I discovered that the system, sys, sysdba, sysoper and all passwords are changed. How can we recover access to DBs?
I sow a lot of messages telling to logon on sqlplus /nolog "connect / as sysdba" but I ger a ORA 12560 TNS protocolo adapter error.
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…