New answers tagged

0

This is not a full answer and I wrote parts of this answer already in a comment. But the error messages are very clear so I will them explain here because I am not sure if this is clear from Balazs' answer,. The correct interpretation helps when analyzing a problem. From the sqlplus error message sqlplus cd2/ @ec2-publicIp.myCloud.compute.amazonaws.com:...


3

First of all, the fact alone that some objects have old statistics, does not necessarily mean they need to be refreshed. By default indexes (tables) are analyzed automatically. About Automatic Optimizer Statistics Collection The automated maintenance tasks infrastructure (known as AutoTask) schedules tasks to run automatically in Oracle Scheduler windows ...


1

No, the below does not indicate that you could reach the server through that port: telnet ec2-pubIp.compute.amazonaws.com 1522 Trying pubIp... telnet: connect to address pubIp: Connection refused telnet: Unable to connect to remote host This is just a generic network problem. The 17002 error can be reproduced any time at will by simply entering incorrect ...


0

Database Windows Service Status "Running" does not necessarily mean the database is open and available. The database can be in all states "down|nomount|mount|open" while the Windows Service says "Running". - C:\>lsnrctl status # will tell if the database service has been exposed/made available. You should validate the state ...


0

Can the CRE account execute the "SOME_PROCEDURE_NAME" procedure? You are creating a trigger that will be owned by the user CRE and, by default, it will be created with DEFINER Rights. Anything and everything that you want to do within that trigger must be "possible" by the CRE user itself and any such permissions must be granted directly ...


3

Even if you create the trigger as SYS, the owner must have the CREATE TRIGGER privilege: GRANT CREATE TRIGGER TO CRE; In addition to the above, to create an AFTER LOGON ON DATABASE trigger, the ADMINISTER DATABASE TRIGGER privilege is also required: GRANT ADMINISTER DATABASE TRIGGER TO CRE;


1

Naming conflicts will result in an error and generally cause the object in the datapump file to be skipped. This can lead to all sorts of other dependency issues. The simplest way to avoid that is to drop the target application schema/account entirely and recreate it, using a script like the one here: https://oracle-base.com/dba/script?category=...


1

OS backups of the data files will only be valid if the database was shutdown at the time the backup was made, otherwise they most likely will not work because they will not account for the state of any data that was cached being written to disk when the backup was made. The system tablespace in particular is problematic because it contains the entire data ...


Top 50 recent answers are included