ERPstuff - Oracle EBS Community

Hi Haseeb The COPY command is a sqlplus command only. It is facilitated by the fact that sqlplus can connect to different databases simultaneously. PLSQL cannot. I'm giving an example to use it as a shell script hope it could be helpful. Amir #!/bin/sh sqlplus -s user/password[@]prod_db <<EOF copy f...

Hi there If you've oracle client installed in windows then you should be able to find the same utility in ORACLE_HOME\bin\sqlldr.exe. You could create your control file in notepad with extention .ctl. Create a batch file to load the .csv data file into database. From Control Panel->Schedule Task you...

Hi there I'm not sure the module you are trying to access is certified with IE7 and Vista. You could try workarounds below: Open I.E. 7 > Tools > Manager Add-ons > Enable or Disable Add-ons Take add-ons currently loaded in I.E. in drop down. Disable all those which not really required. You may have ...

Hi there What's the use of database, it's TEST or PROD? It looks like some data file(s) got corrupted. If it's PROD then should be in ARCHIVED LOG mode try to use following commands sequence to recover database before it got crashed. SQL> STARTUP MOUNT; SQL> RECOVER DATABASE UNTIL TIME '2008-12-15:2...

Hi there You have to have any kind of oracle installation either server or client to access the oracle database. You could use ODBC though to access your database through Excel or other application. From DB Server You could do "$ORACLE_HOME/bin/isqlplusctl start" and all client can access ...

Hi there You can use Grid Control if installed or Database Console to setup notification Rules and email Alerts. To set up table space Alert, go to Admin-> Tablespace click on your desired tablespace-> edit->Threshold. See site below for how to access OEM through URL: http://cs.scu.edu.cn/~zuojie/or...

Hello there Please run Database Configuration Assistant for creating/removing database. WINDOWS: Click start -> Oracle OraDB10g_Home1 (your Oracle Home) -> Configuration and Migration Tools -> Database Configuration Assistant UNIX/LINUX: $ export ORACLE_HOME=... $ export PATH=$PATH:$ORACLE_HOME/bin ...

Please do get your copy it's a good book written by a Pakistani origin guy. He has a over 15 years of working as a Unix Administrator and teaching experience. http://www.amazon.com/HP-Certified-Systems-Administrator-11i/dp/1606436546/ref=sr_1_2?ie=UTF8&s=books&qid=1224682604&sr=8-2 His L...

Hi

Do you mean the interview questions about plsql? here's a good site for your review.

http://www.coolinterview.com/type.asp?iType=61


Thanks
Amir

It looks to me the Library path problem. Please check below the order in which oracle look for libraries at your and client side. Hope that would be helpful. 1) If Lib.plx is in your working directory - take it 2) If not found, search in the FORMS_PATH for Lib.plx 3) If not found, search in the work...

Hi there

I like site below for RAC info.

http://www.puschitz.com/InstallingOracle10gRAC.shtml

Thanks
Amir

Hi there

Did you meet all sys requirement. What's system configuration (M/Board etc) and BIOS version? you could try unplug the internal HDD. I was able to install it that way.

Thanks
Amir

Hi there

Please follow the link below and let us know if you need more info.

Thanks
Amir

http://www.exforsys.com/tutorials/oracl ... ation.html

Hi there

There are many tables available to know job status. You could either check ALL_JOBS or DBA_JOBS and TOTAL_TIME column will tell you how much time processing time was allocated to a particular job.

Thanks
Amir

Hi there

You need to find WFT file and then modify the path through Workflow Builder.
After saving changes you could use "wfload" or WF Builder.


Thanks
Amir