Twitter @gcolbran
Bikers Against E-Tolls SA
Monthly Archives: November 2007
Find 10g EM ports
Enterprise Manager 10g installs a number of control web sites. These can be found by checking the settings on the system after installation.
Posted in Oracle
Comments Off
Disabling Foreign Keys
Posted in Oracle
Comments Off
Space Management queries.
This document contains common queries required to check the database. Feel free to email additions to gary@rdbconsulting.com Thanks Contents: Item Added Updates Whom Free space available in a tablespace. 28 Nov 2007 None GJC Minimum size a datafile can be … Continue reading
Rman Delete Obsolete
Rman deletes unrequired backup pieces automatically using the delete obsolete command. This document is a work in progress. Feel free to email me amendments and additions at gary@rdbconsulting.com Thanks
EMCA drop repository fails.
Re-creating the EM. A client required the Enterprise manager to be rebuilt. This failed with the inability to drop the repository on the database. The cause turned out to be that the database had been a part of a cluster … Continue reading
Posted in Oracle
Comments Off
Configure Fal_client and Fal_server.
The Fal_client and fal_server parameters are configured to manage failover capabilities of a standby database, allowing it to switch from the primary to the standby and back again, whilst maintaining the flow of archive logs from the primary to standby … Continue reading
Posted in Oracle
Comments Off
Getting into a database.
Posted in Oracle
Comments Off
Import and “invalid object identifier literal”
invalid object identifier literal When importing, if you receive the errors: invalid object identifier literal It's because the objects are already defined in the database at the time that you are importing. I experienced this when importing a dump file … Continue reading
Posted in Oracle
Comments Off
