There are two errors when completing a clone from PROD.

One is about the error “Xlib: connection to ":0.0" refused by server” , you should check the vnc server address and port number on app tier, they must the same as the value of $DISPLAY.

The other error is about “ORA-20100: File o0042978.tmp creation for FND_FILE failed” , you should check the environment variable $APPLPTMP on app tier, then to check the parameter value UTL_FILE_DIR. the $APPLPTMP should be included in the UTL_FILE_DIR, and you can using the following statement to check it:

exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'it's a testing!');

Recently I clone an identical EBS environment from PROD, but when I start app services I find that the concurrent manager can't be started due to the listener of app tier.the error is the following:

LSNRCTL> start
Starting /oracle/prodora/8.0.6/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 8.0.6.3.0 - Production
Log messages written to /oracle/prodora/8.0.6/network/admin/apps_pko.log
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=172.17.11.72)(PORT=1526))
Attempted to listen on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory

1)Shutdown the app tier using the SHELLscripts adstpal.sh;

2)APPS and APPLSYS accounts share the same password, so we can use the FNDCPASS utility to change their passwords:
$ FNDCPASS APPS/<apps_pwd> 0 Y SYSTEM/<system_pwd> SYSTEM APPLSYS <NEW_PWD>

3)Run Autoconfig to propagate the changed passwords into the following application server configuration files:
$ORACLE_HOME/reports60/server/CGIcmd.dat
$iAS_TOP/Apache/modplsql/cfg/wdbsvr.app

4)Restart all application tier processes:

In a distributed database environment, using database link is a good choice, but sometimes It's tough for us to manage and maintain it. for example, if we change the password of source db name, we need to change it in target db source as well. Before Oracle version 11g, we must delete the link then create a new link to do so, but from Oracle 11.2 on, we can directly alter the database link to change the password. like that:

alter database link dblinkname

connect to test

identified by newpsw;

And if your db link is created in PUBLIC schema, you should login into database using SYSOPER, then have the privilege of altering database link to do so.

There are three ways to quickly login into the Oracle EBS 11i as below:

http://URL:PORT/dev60cgi/f60cgi?colorscheme=blue

http://URL:PORT/OA_HTML/fndvald.jsp?username=XXX&password=YYY&langCode=US

http://URL:PORT/OA_HTML/AppsLocalLogin.jsp?cancelUrl=/OA_HTML/AppsLocalLogin.jsp&langCode=US&username=XXX

Hi,if you need to help set goals for your subordinates you should be familiar with SMART. What is it?

SMART=Specific,Measurable,Attainable,Realistic(Relevant),Timely(Time-based)

 查看全文

I saw a good template email which is about applying for training program. If you're the boss and probably receive this kind of email from your subordinates, how could you unkindly refuse it? :-P The following is the template for your reference.

 查看全文