logs archiveIRC Archive / Freenode / #oracle / 2010 / July / 6 / 1
kingping
Hello folks
I've failed to download Application Express from http://www.oracle.com/technology/products/database/application_express/download.html
Tried many ways to accomplish that. Is it downloadable?
PovAddict
hi, I'm playing around with Solution Beacon's public instance of Oracle Apps R12
Expense Reports is giving me "Please enter a valid cost center" when I click Next, but there isn't even a cost center field there
http://img411.imageshack.us/my.php?image=plasmadesktopty3009.jpg
any idea what's going on?
how would I make the cost center field show up?
progesterone
Question: how can I print out a variable value in java applet?
PovAddict
isnt that a question for ##java ?
progesterone
PovAddict ##java says 'no applet'. Where shoud I ask that question?
PovAddict
##java says "no applets" because you shouldn't be *using* applets, not because they won't answer those questions
and if they don't answer there, it's not a reason to ask here :P
"I tried to buy a Renault in a Renault shop, but there were no salesmen available, so I came into this Ford shop. Why won't you sell me a Renault?!"
Xgc
progesterone: Depends what you mean by "print out". An applet normally runs in a browser, so you typically use Swing or the like, unless you want to just stuff something in the java console: System.out.println(...);.
progesterone: Consider handling development within something like Eclipse.
progesterone: Since applets typically can be run as Swing applications, laern how to do this and ask all your questions in ##java. Just avoid the dirty (applet) word. Talk only about Swing and applications.
PovAddict
/me repeats his question in the hope that timezones made different people be awake now :P
I'm playing around with Solution Beacon's public instance of Oracle Apps R12
Expense Reports is giving me "Please enter a valid cost center" when I click Next, but there isn't even a cost center field there, any idea what's going on?
http://img411.imageshack.us/my.php?image=plasmadesktopty3009.jpg
hali
rizzo: you using configuration manager to hook up to metalink at all yet?
         

usn_work
hali, do you?
hali
usn_work: trying my first one now
doing a small se one database, thought i'd give it a try
you?
usn_work
I am still kicking it down the road, week by week ;)
volkerp
could anybody please tell how i get a horizontal (more table like) output in sqlplus, rather than the vertical one?
RJarett
check the asktom site for print_table script
or change your col setup
ygip
sqldeveloper for oracle is free
nice tool
dsdel
slow tool
usn_work
java tool ;)
dsdel
and buggy also :D
but I don't want to blame oracle for the free tool, just the developers :D
usn_work
but at least no .NET ;)
http://www.emok.tv/videos/java-vs-microsoft-net.html
dsdel
muahah 'portable and secure' together with java mentioned :D
ye, you can port the trash to every platform for more trash
but the vid is nice
usn_work
:)
blackcat73
hi, I want to dump a database from postgres and then create it under oracle, can anyone tell me what are the best parameters for this?
RJarett
"parameters"?
you cant just go from one to another
blackcat73
RJarett, sorry I meant arguments for the pg_dump
RJarett
not going to work
blackcat73
RJarett, if I only extract the structure in SQL?
RJarett
sql structure and syntax is not the same
blackcat73
maybe with some data types conversion
RJarett
easiest if there are not alot of table is to manually recreate all the objects in oracle
and then dump the data as flatfile
and sqlloader it into the new instance
         

blackcat73
RJarett, I see, is there any link describing the data type diferences?
RJarett
otn.oracle.com
tahiti.oracle.com
you can find all the docs there
blackcat73
ok, thx you
usn_work
hali, how long did it take until the system appears in the SYSTEMS tab in MOS?
I am waiting for more than 10 minutes now
hali
usn_work: logout and login, they cache it in the session scope i think
usn_work: did you do a emCCR collect?
usn_work
yes I did
mh, logoof/logon did not change anything. I have more than one CSI active, but I can't find how to associate a potential new system
hali
setupCCR CSI
i t hink
usn_work
okay, tnx
PovAddict
I'm playing around with Solution Beacon's public instance of Oracle Apps R12
Expense Reports is giving me "Please enter a valid cost center" when I click Next, but there isn't even a cost center field there, any idea what's going on?
http://img411.imageshack.us/my.php?image=plasmadesktopty3009.jpg
hypno
ALL_TABLES and ALL_TAB_COLUMNS are some special version of views?
OCILIB do not seem to approciate those two /at all/.
rednblue
test
hey i am software developer. more of coding sort. which is the best oracle certification for me?
please guide me
RJarett
java certified dev
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=365
doubletwist
So I've got a box running Oracle with 128GB of RAM. According to top, linux has 47GB cached, and it's got 11GB worth of app data swapped out to disk. Am I right in thinking I should adjust the swappiness? Seems a bit excessive to swap out that much when it would still have 30+ GB of RAM available for IO caching...
RJarett
swappiness isnt really used anymore
but the real question is, why do you think you need 128GB of ram?
seems like a huge waste to me. Most times on VLDB with massive amount of ram in use, 1/2 the ram would suffice and be better actually
doubletwist
Correction, this box has 64GB of ram. Though it will be getting 128GB soon. So that it can handle the memory load from the other database server if one of them fails and we have to run all the databases on a single box for a short time
I don't disagree btw. But that's what I'm working with.
RJarett
do you NEED 64GB?
how many TB is the instance?
20-40?
doubletwist
hah. Hardly
RJarett
or how many hundred k transactions per second are you running?
doubletwist
It's x86. RAM was cheap.
RJarett
when i see numbers like that, i just know there are glaring issues elsewhere in the setup
128gb isnt cheap no matter how you look at it.
doubletwist
I suspect there are. I'm not a DBA. I know jack-squat about Oracle.
RJarett
its not just oracle. its overall memory usage
doubletwist
Compared to the Sparc hardware we came from, the ram was practically free :)
RJarett
just like you said, 47gb are cached
meaning 64-47(cache)-2gb(os)-???buffer?
how big the the actual sga?
doubletwist
If I had to do it over again, I'd choose a few more servers with smaller cpu/RAM loadouts. But what's done is done.
RJarett
i run many a V:DB (very large db)
doubletwist
Mem: 63813256k total, 63488924k used, 324332k free, 19364k buffers
RJarett
ugh learn the -m handle
free -m
what os is this?
doubletwist
Oracle Enterprise Linux
RJarett
ick. ok
doubletwist
Though I think we're going to be migrating back to Solaris x86. We're not very strong with linux
RJarett
#1 go find collectl and put it on the box
linux is better
doubletwist
Actually, if we [sysadmins] have our way, we'll be going back to Solaris sparc
RJarett
why?
you will see a major drop in performance
and in increase in licensing costs
sparc seriously sucks for oracle
doubletwist
because that's what 90% of our environment is. That's what all our infrastructure is set up to support [historically]. That's what we're stronger in.
Honestly, these databases aren't large or terribly busy.
RJarett
well, youre going to have to suck it up and learn other stuff. Since solaris wont be around long
And VMWare/linux is the path to choose
you think oracle wants to take on a dying beast like solaris when they are pushing OEL?
doubletwist
There's a Sun blueprint out there talking about handling 14000 users on siebel with the front-end, app server and database all running on a single coolthread server. We've got at most 100 simultaneous users. I don't think it'll have a problem handling it.
RJarett
so this is for siebel?
doubletwist
Based on our experience thus far, Oracle's "support" for linux consists of "Go see what the docs say on RedHat's site"
RJarett
look at the blueprint for how much storage was on it
doubletwist
Siebel and a few other databases. Siebel is one of the busiest.
our Siebel db is only 300GB or so
RJarett
cpu and memory is the least of your worries
do you guys have a real dba?
normal sysadmins shouldnt ever really di*k with oracle
doubletwist
yeah. They're tough to work with :)
I don't touch oracle.
RJarett
and a normal sysadmin shouldnt ever touch a DBAs system
doubletwist
All I do is handle the OS, usually setting whatever they ask us to set [after some verification of course :) ]
RJarett
what sort of storage is connected to this?
doubletwist
The DBAs we have aren't strong on the OS side. Us sysadmins aren't strong on the database side. So we work together. Again, it's what we have to work with at this time.
It's a Fiberchannel SAN [Compellent]
RJarett
you are over spec'd for you server i bet
but its so misconfigured
doubletwist
I'm sure it is way overspec'd
RJarett
swappiness is dead. dotn touch it
unless its a OEL4 setup
doubletwist
I dunno, RedHat's own documentation for RHEL 5.1 suggests setting it 'if needed'
RJarett
god i hope not
its not even accepted on soem kernels
what problem are you trying to resolve?
just oracle swapping?
doubletwist
The box has been bogging down for periods of time ranging from 2-20 minutes. During which time the load average goes through the roof [200+]. The data I get from sar suggests that all 16 cores are pegged at 100% with most of the load being system time.
RJarett
go load collectl
sar = the suck
what was io wait during that time?
whats the filesystem this is sitting on?
pastebin your spfile
doubletwist
filesystem is ext3
RJarett
unless you have a major race condition, only IO is something thats going to do that to your CPU
doubletwist
right. Well the last time I got some top info during an incident, kjournald and kswapd were using a lot of cpu time. Which is why I started looking at the swap usage. 11GB seems a bit excessive to me, when there's 47GB worth being used for IO cachine.
RJarett
well all that could be because of how the sga/pga are setup
doubletwist
I'm not familiar with the spfile [other than what I'm just finding out about it online]
RJarett
pastebin your spfile, your /etc/sysctl.conf
su - oracle; cd $ORACLE_HOME/dbs ; strings spfile$ORACLE_SID*
how many FC HBAs does this box have?
doubletwist
2 HBAs
RJarett
hows are the luns split out?
oh and whats your io scheduler?
doubletwist
at the moment, there's a dbname-data lun which houses the data [and I only found out recently a copy of the logs], and a /var/oracletemp which houses tmp stuff and I believe another copy of the archivelogs.
RJarett: whatever OEL defaults to on the io scheduler
RJarett
cfq
which is really nasty
for i in sd* ; do cat /sys/block/$i/queue/scheduler; done
doubletwist
yeah well, the documents on Oracle's site at the time I set these up were pretty sparse. They were basically a simple linux install howto, with almost NO information on tweaking the system for running databases.
RJarett
there is ALOT of information online for all this
doubletwist
yup. cfq for all
RJarett
you cant say there isnt
find your largest heaviest oracle luns there
and echo "deadline" > scheduler
doubletwist
I said on Oracle's site, *at the time I set this up*. I asked oracle support for documentation. The only thing they could point to was that installation howto
RJarett
well theres so many blogs and help sites
deadline is a much nicer io scheduler for oracle
with cfq its almost first in first out and will hang others processes until its done
doubletwist
well, that's not something I'm going to throw onto our production boxes :)
RJarett
not like itll hurt it
doubletwist
But I will look into it [and collectl]
RJarett
you can make it perm with elevator=deadline in your grub
doubletwist
No changes are made to the production systems without going through a change process [outside of emergency fixes]
RJarett
im thinking #1 your pga/sga are not in line with what you set for your shm/sem settings
which is no different than solaris either
you would do about the same on linux in sysctl.conf as /etc/system
next, i doubt your default io scheduler is helping this
doubletwist
I'll talk to the DBAs about it. They gave us the shm/sem settings to use. :)
RJarett
they probably also said to set PGA/SGA sizes larger than like 8gb/ea
which is seriously bad practice in almost all cases
but most people think more memory is better
doubletwist
still waiting for a response but already asked the DBAs about reducing the amount of RAM they've got the instances configured to use. Seemed to me that 20GB is a bit overkill for a reporting database. or 16GB for a 100 consecutive user instance of Siebel.
RJarett
plus numa optimizations probably need to be disabled on this instance
im just against the dba/sysadmin split when it comes to oracle
there cant be 2 groups with split knowledge
it needs 1 person who knows all aspects.
storage, networking, db, os
doubletwist
well, the DBA's are too busy dealing with the databases, and we're too busy dealing with everything else. :)
RJarett
hell you really just need 1 good dba for a few TB of DBs
doubletwist
Well, it's a lot of small databases supporting various different business units [and some outside customers]. 2 DBAs.
RJarett
those are even easier. set it and forget it
doubletwist
not necessarily
« prev 1 2 next »