ITPub博客

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

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> startStarting /oracle/prodora/8.0.6/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 8.0.6.3.0 - ProductionLog messages written to /oracle/prodora/8.0.6/network/admin/apps_pko.logListening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=172.17.11.72)(PORT=1526))Attempted to listen on: (ADDRES

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:[@mo

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 dblinknameconnect to testidentified by newpsw;And if

There are three ways to quickly login into the Oracle EBS 11i as below:http://URL:PORT/dev60cgi/f60cgi?colorscheme=bluehttp://URL:PORT/OA_HTML/fndvald.jsp?username=XXX&password=YYY&langCode=UShttp://URL:PORT/OA_HTML/AppsLocalLogin.jsp?cancelUrl=/OA_HTML/AppsLocalLogin.jsp&langCode=US&username=XXX[@more@]

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)[@more@]SpecificGoals should be straightforward and emphasize what you want to happen. Specifics help us to focus our efforts and clearly define what we are going to do.Specific is the What, Why, and How of the SMART model.WHAT are you going to do? Use action words such as direct, organize, coordinate, lead, develop, plan,

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.[@more@]To: XXXFrom: YYYSubject: ITIL and ITIL implementationXXX, as you know, I recently discover ITIL, the best practice, process-based approach to quality IT Service Management. This framework will provide out IT/IS department with many benefits, includ

What is 4C?This is a question for you if you're gonna be a supervisor or you have been in a management position.Maybe you have lots of understanding about how to be a good manager, but 4C could be a basic skill for you to grasp and keep it in mind.[@more@]4C = Clarity+Competence+Commitment+ControlClarity:Clear and easy to understand - tasks,objectives and results,responsibilities and performance expected.Communicate with subordinates to clarity tasks.Competence:The employee responsible for the t

AD configuration is an utility(adconfig.sh), also known as autoconfig, which is located in the $AD_TOP/bin directory. When we use adautocfg.sh script in the $COMMON_TOP/admin/scripts/$CONTEXT_NAME directory to serve as a wrapper to adconfig.sh, the location of the context file is not required, but adconfig.sh command will prompt for the location of the context file and the password of APPS.[@more@]Go to $APPL_TOP/admin/$CONTEXT_NAME/log/MMDDhhmm directory to review adconfig.sh log files on app

I taught two days Oracle database OCP training courses last weekend with good performance my students told me that. The Oracle database training is a practical course for learner to do a lot of scenerios and understand the theory of Oracle database, so do not make your goal with obtaining the OCP certificate only. It's very important for you to get not only experience on how to manage and maintain Oracle database, but also learn Oracle from Oracle, because Oracle database has huge places for you

Recently when we reviewed the result of IT SLA, we found the comments regarding to IT services:Sometimes, our XX printer had problem, we have tried to solve it by ourself first, but failed. You know, we are not the professional person. So, we called IT colleague, but sometimes, he said, why it happed again? What do you do with it? Have you checked it by yourself? Or he said, I am busy, I will solve it when I have time (until we called him second time he was not come and solve the problem)Even he

Benefits of ITIL to the customer/users:1.The provision of IT services becomes more customer-focused and agreements about service quality improve the relationship;2.The services are described better,in customer language,and in more appropriate detail;3.The quality,availability,reliability and cost of the services are managed better.[@more@]Communication with the IT organization is improved by agreeing on the points of contact.Benefits of ITIL to the IT organization:1.The IT organization develops

Last year I did a migration for three nodes' RAC DB from old machine into new machine.The whole replacement is wonderful with no risk and providing 7/24 HA, but I encountered a little problem about Web dbconsole that I couldn't reconfigure dbconsole successfully.[@more@]Some errors from emagent.trc as below:2011-02-06 10:03:07 Thread-4135253696 ERROR util.files: ERROR: nmeufis_new: failed in lfiopn on file: /local/bin/oracle/product/10.2.0/db_1/rac1_PRD11/sysman/emd/agntstmp.txt. error = 2 (No s

When having a try to print non-manual invoice by printing manual invoice,We got an error just like this:Current system time is 10-FEB-2011 07:31:42**Starts**10-FEB-2011 07:31:42ORACLE error 20100 in FDPSTPCause: FDPSTP failed due to ORA-20100: File l0042269.tmp creation for FND_FILE failed.You will find more information on the cause of the error in request log.ORA-06512: at "APPS.FND_FILE", line 407ORA-06512+---------------------------------------------------------------------------+St

We all know that cloning EBS is a huge operation, it will make you to down APP and DB tiers in order to copy files to the destination environment.These days I got an request that need to clone the source EBS environment PROD into a temporary TEST environment. When I got into this issue I found that no any changes on APP tier and the database oracle files on DB tier, so doing a data recovery from PROD into TEST is a good choice.The following steps I involved as below:[@more@]1.Delete all files un

I took a management skill training some months ago and there are so many important tips for me to understand and apply. Here I'd like to give some key points on how to be a successful manager as below:1.To know the responsibility of manager;2.To manage subordinates to finish tasks;3.Clarity the tasks via communication;4.Make assure that the subordinates are able to do tasks;5.To encourage subordinates to make committment;6.Control the procedure and achive the goal.[@more@]

The TAF service name can not be registered into CRS,please see the below info:[oracle@racdb1 ~]$ crs_register ora.RACDB.racdb_taf.RACDB2.srvSyntax error in /oracle/crs_1/crs/public/ora.RACDB.racdb_taf.RACDB2.srv.cap, line number 1: "CRS-0210: Could not find resource 'ora.RACDB.racdb_taf.RACDB2.srv'."(File: caa_profile.cpp, line: 155[oracle@racdb1 ~]$ cd /oracle/crs_1/crs/public/ora.RACDB.racdb_taf.RACDB-bash: cd: /oracle/crs_1/crs/public/ora.RACDB.racdb_taf.RACDB: No such file or direc

Some days before, I helped my clients replace nodes in RAC DB. The replacement procedure was finished successfully, but I met a failure during the web dbcontrol reconfiguration.The following is the main output info, you could see that the process was terminated because the port 3938 is already used.[@more@]Some days before, I helped my clients replace nodes in RAC DB. The replacement procedure was finished successfully, but I met a failure during the web dbcontrol reconfiguration.The following i

In the past couple of months, I taught two serials of Oracle 10g OCP courses for WDP students in CNTIMES. A period of OCP course is 10 days and I took 20 days giving training during two periods. The happy thing is that the performance of my training is very good and my students have all made great improvement in Oracle Database. Here,I'd like to introduce a great chance for you to learn Oracle database and get certificate with easy and low-cost access.It's Oracle WDP which allows education insti

ITIL is the most widely accepted approach to IT service management in the world. ITIL provides a cohesive set of best practice, drawn from the public and private sectors internationally. It is supported by a comprehensive qualifications scheme, accredited training organisations, and implementation and assessment tools.[@more@]