Search found 138 matches

by amirtai
Sat May 17, 2008 3:08 am
Forum: Application DBA & System Administration
Topic: server error.....help me admin
Replies: 2
Views: 1474

Hi

Can you please submit the error from log file. If it's Oracle application server then HTTP server logs should be in ORACLE_HOME/apache/apache/log.

Thanks
Amir
by amirtai
Thu Apr 10, 2008 12:41 am
Forum: Application DBA & System Administration
Topic: Failed to Start OSAgent
Replies: 1
Views: 2462

Hi there OSAGENT is a 3rd party product (Borland) that was used by Oracle to coordinate between jobs submitted through CORBA. If one process dies it looks for another in the subnet and does not find tries to start another one. As a root you need to kill the orphan processes within subnet work and th...
by amirtai
Thu Apr 10, 2008 12:13 am
Forum: Operating System
Topic: logical disk partition not showing on RAC instal
Replies: 1
Views: 3182

Hi there You didn't mentioned anything about shared storage device. What type of storage you are sharing between 2 nodes. It could be SAN/NAS or ASM. If you are using SAN then 3rd party Filesystem would be implemented. If you prefer to use Oracle Cluster FS for CSS+OCR then you need to format one pa...
by amirtai
Tue Feb 12, 2008 10:24 pm
Forum: Operating System
Topic: MKS ToolKit Not found!
Replies: 1
Views: 2914

Hi there

You should try "cygwin" http://cygwin.com
by amirtai
Thu Jan 31, 2008 1:36 am
Forum: Operating System
Topic: OS memory Usage
Replies: 3
Views: 3709

Hi Linux DB Server won't show you actual memory, because it reserves large portion of the memory in cache. You can issue "show sga" from sqlprompt to see actual memory utilized by database. However with "free" and "top" command you can check how much memory is free and ...
by amirtai
Thu Jan 31, 2008 1:18 am
Forum: Application DBA & System Administration
Topic: oracle apps 11.5.9 client installation win2003 64b
Replies: 1
Views: 1211

Hi

What's the browser and version of that browser? make sure you have disabled 3rd party tool bars (like google bar etc).

Thanks
Amir
by amirtai
Thu Jan 31, 2008 12:54 am
Forum: Oracle Databases
Topic: Oracle 10G Enterprise Manager
Replies: 5
Views: 4142

Hi It depends on your OS, if it's Linux box then you have to specify ORACLE_SID once you are starting EM. However Windows installation always puts an entry in the registry (under: \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleDBConsole<ORACLE_SID>). So you just need to start the EM either typing ...
by amirtai
Mon Jan 28, 2008 11:58 pm
Forum: Oracle Databases
Topic: Oracle 10G Enterprise Manager
Replies: 5
Views: 4142

Hi You can connect with a single database at a time through any client browser that has access to that database server. All you need to do is find the exact URL and status if EM is running. You need to type command below on DB server to know the status and URL as well that you can use to connect fro...
by amirtai
Mon Jan 28, 2008 11:44 pm
Forum: Oracle Databases
Topic: RMAN with different database version
Replies: 2
Views: 2236

Hi The compatibility level of the recovery catalog is determined by a parameter that is stored in the catalog itself. It specifies the minimum acceptable release of the RMAN executable that can function with the catalog. For example, if the recovery catalog compatibility is set to 8.1.4, then only a...
by amirtai
Mon Jan 28, 2008 11:31 pm
Forum: Oracle Databases
Topic: dba_tab_cols
Replies: 3
Views: 2775

Hi select owner,OBJECT_name,object_type from all_objects where object_name='DBA_TAB_COLS' and object_type='VIEW' OWNER OBJECT_NAME OBJECT_TYPE ------------------------------ ------------------------------ ------------ SYS DBA_TAB_COLS VIEW Thanks Amir
by amirtai
Mon Jan 28, 2008 10:42 pm
Forum: Oracle Databases
Topic: SQL TUNING
Replies: 1
Views: 1512

Hi Here are few examples to grasp some idea: select DEPTNO from EMP where (DEPTNO=10) or (DEPTNO=20); Same result could be obtain With IN or NOT IN: select DEPTNO from EMP where DEPTNO in(10,20); Likewise the use of EXISTS or NOT EXISTS must return TRUE if at least one condition is met. We want to c...
by amirtai
Mon Jan 28, 2008 10:28 pm
Forum: Application DBA & System Administration
Topic: How to telnet Windows to Linux.?
Replies: 2
Views: 1379

Hi At the time of Linux Server installation the firewall was enabled on that port. So you need to disable it for port 22 and start the telnet deamon on the linux server. They other way is download the putty software from link below to your windows server and connect it through ssh. http://the.earth....
by amirtai
Mon Jan 28, 2008 10:23 pm
Forum: Application DBA & System Administration
Topic: How to connect Oracle client 9i to Linux.- Appl DB
Replies: 7
Views: 3876

Hi Did you try connecting directly to your linux box through VNC viewer . Just double check both Linux Server and cleint 9i <Oracle_home> \network\admin\tnsnames.ora has exactly same entries. After matching all entries in both files trying using "tnsping <database name> from your client machine...
by amirtai
Sun Jan 13, 2008 4:09 am
Forum: Suggestions
Topic: Donation Procedure
Replies: 29
Views: 23360

Hi Admin Although I'm pure Oracle DBA and nothing to do with Oracle ERP but sometime I need to refer some Apps DBA stuff. I appreciate your work in this regard. I have some suggestions that would be great if you can expend your installation document to the multiple node/tier (for large/Medium scale ...
by amirtai
Wed Jan 09, 2008 12:53 pm
Forum: Suggestions
Topic: Donation Procedure
Replies: 29
Views: 23360

Hi

Is there any discount/incentive under consideration for one star *, two star ** and three star *** members? or it's only presenting those members interaction with "erpstuff.com". Just curious! [:)]

Thanks
Amir