Search found 7 matches

by shhuang
Wed Mar 12, 2008 2:39 am
Forum: Application DBA & System Administration
Topic: How to find applied family pack in oracle apps
Replies: 2
Views: 2259

which product's family pack? 1. Financials Family Pack using select substr(bug_number,1,10) BUG, decode(bug_number, '1807809','11i.FIN_PF.A', '2218339','11i.FIN_PF.B', '2380068','11i.FIN_PF.C', '2629235','11i.FIN_PF.D', '3016445','11i.FIN_PF.D.1', '2842697','11i.FIN_PF.E', '3153675','11i.FIN_PF.F', ...
by shhuang
Tue Mar 06, 2007 11:25 pm
Forum: Oracle Databases
Topic: plz send me the query ans
Replies: 2
Views: 1697

maybe this is not a perfect idea........share to everyone select * from ( select sno from num where sno <= 5 order by sno asc) union all select * from ( select sno from num where sno > 5 and sno <= 10 order by sno desc)
by shhuang
Tue Mar 06, 2007 11:11 pm
Forum: Application DBA & System Administration
Topic: Need help to backup
Replies: 41
Views: 10388

maybe you should check your DB's status?? ORA-01034: ORACLE not available Cause: Oracle was not started up. Possible causes include the following: - The SGA requires more space than was allocated for it. - The operating-system variable pointing to the instance is improperly defined. Action: Refer to...
by shhuang
Thu Dec 28, 2006 11:27 pm
Forum: Purchasing & Inventory
Topic: Contents of 11i Vision database
Replies: 1
Views: 1581

Oracle version is 9.2.0 when I installed EBS 11.5.10.2
It contain some of test data in db.
you needn't insert any data before you use it....
by shhuang
Fri Dec 22, 2006 3:07 am
Forum: Application DBA & System Administration
Topic: Need help to clone
Replies: 12
Views: 4878

It just let you know ...what situation will change your configragion.

just clone successful on 11.5.10.2
by shhuang
Wed Oct 11, 2006 2:12 am
Forum: Application DBA & System Administration
Topic: 11i does not allow incoming sqlplus connections
Replies: 1
Views: 1686

the following parameters to your sqlnet.ora file: tcp.validnode_checking = yes tcp.invited_nodes = (www.aq.com,172.16.1.4) tcp.excluded_nodes = (199.16.1.21) The first line enables this features. The invited nodes is a list of the hosts, either DNS name or IP address, that are allowed to connect. Th...
by shhuang
Wed Oct 11, 2006 12:49 am
Forum: Application DBA & System Administration
Topic: Apps Performance Monitring Tool
Replies: 4
Views: 3560

I heard Quest Spotlight .....

it's a good tool....

but I am trying it ......