Davis Apps DBA

Recently I migrated a database(11gR1) from Windows Platform to 12C on Linux Platform. Migration was successful. During the sanity check, found lot of Invalid objects even after all the grants and privileges were provided. Ran utlrp.sql couple times, still the invalids count remains the same. So I choose an Invalid object, compiled it manually and faced the below issue. This was the issue for almost all the invalid objects. So I understood something is not right with the object DBMS_OUTPUT. So I checked this object and to my surprise it was valid. Since the status is Valid, before doing any change to the object 'DBMS_OUTPUT', I decided to check the coding of the invalid object, since the DBMS_OUTPUT is an oracle standard one. If I comment the line "dbms_output.put_line" from the invalid object, it is getting compiled and then it is a valid one but this is not the solution. This can be accepted as an workaround when a minimal no.of objects becomes invalid due to this is...

 In one of our environment, post migration we tested the SEND_MAIL procedure to initiate the mail via SMTP server from DB level and faced the below issue. ORA-01775: looping chain of synonyms Looping chain of synonyms means, the created synonyms points to another object in a circle. Here for better understanding, SEND_MAIL is the procedure used to trigger mails from DB Server UTL_SMTP and DBMS_OUTPUT are the dependent objects for SEND_MAIL procedure UTL_SMTP synonym is also dependent object for SEND_MAIL procedure So it is clearly evident that the dependent objects should be valid before fixing the issues with the SEND_MAIL procedure. So, I started the drilldown on the required dependent objects and found the procedure 'SEND_MAIL' and package body of the object 'UTL_SMTP' is invalid. So I made an attempt to compile the UTL_SMTP body to make it a valid object and faced the below issue. This issue indicates the format of the wrapped unit being compiled is not understood b...

 I need to drop some package and synonyms from a PDB. When I attempted to do, I faced the below issue. Quick surf on the metalink leads to the solution. Warning: Object owned by SYS user should not be dropped without understanding its impact and proper backup. When you created the synonym with the schema name also appended with the object name, then it can be dropped like below. drop public synonym "TFGADMIN.DBMS_OUTPUT";

I'm using 11i(11.5.10.2) EBS in our environment. This is maintained for historical data and not in regular use. So the routine health check or any other formalities are not followed for this instance as we would do for any other normal EBS Instance. Often I'll receive mails from users stating 'Cannot access 11i Instance'. On checking mostly the error will be There are two ways to solve this issue. Method 1: Stop the apache, clear the cache and start the apache server as follows. Once the apache is started, clear the browser cache and try to login. In most cases this workaround will solve the issue. If still you are facing issue even after this workaround, then follow the below given method 2. Method 2: Stop the application services, clear the cache, compile all the jsps, start the application services and try again. Once the jsp compilation is finished, check any application related services are running. If so kill them and start the application services.  Note: Here I ...

 After we cloned our TEST instance, some of the reports(seeded and custom) completed with error. On checking the log file found the below error After a short search found some metalink documents which shed light on this issue. The reason is UTL_FILE_DIR and the environment variable $APPLPTMP are pointing to the same directory but that mount is already used by the grid software in my environment. Insight on the Issue The EBS environment variable $APPLPTMP is set to temporary directory path on the 'Database' node. The $APPLPTMP path is needed only on the Database node and not required on the Application node The $APPLPTMP path needs to be the first path in the UTL_FILE_DIR database parameter. If multiple databases runs on the same host, then use a unique value for this temporary directory(i.e.  All DB should not use the same directory and also the directory should not be owned by a different user. Normally the owner for this directory will be root. ) If there are more than one d...