logs archiveIRC Archive / Freenode / #oracle / 2009 / December / 18 / 1
Dormir
sidh: thought this was all in the same database
if it is, I responded on how to do that earlier. I gave you 2 options on how to copy the table
boingolov
Dormir, looks like he went with option 2
ea_suter
hi there
I have a question that I wasn't able to answer with google: does oracle express (the latest release) create indexes automatically on new tables that are created?
TheBonsai
i don't even understand the question, unless you mean the needed indexes for PKs or so
ea_suter
yeah
for the primary keys
TheBonsai
each UNIQUE or PRIMARY KEY column is indexed
ea_suter
ok thanks
TheBonsai
i don't know for "current release", but i really guess this years old basic stuff also exists
sidh
YESS that's done
thank you for your advice
(yes it was 2/)
         

Reign1
how to know which foreign key is causing problem? ORA-02297: cannot disable constraint (IRMS.CARD_PK) - dependencies exist
th3_w3b
elow i am new to oracle
TheBonsai
Junior: m00
th3_w3b
i would like to learn more about it.. maybe somebody could guide me
=0
:)
TheBonsai
maybe, if you actually would ask something
Junior
buu TheBonsai
boingolov
th3_w3b, http://www.oracle.com/pls/db112/homepage
th3_w3b
<boingolov> th3_w3b, http://www.oracle.com/pls/db112/homepage --> thanks
boingolov
yw
th3_w3b
its really a good site to start with oracle.. yohoo!!!
:)
TheBonsai
(Action) mumbles something about "oracle.com" and "no wonder"
Newbie
how to get the most repeated column value in a table
dormir: pls suggest
TheBonsai
GROUP BY that column and get the count
Newbie
TheBonsai, i am getting count of all distinct column values
i want only the columvalue with higest count
TheBonsai
then order by and get the first, maybe
kok
hi i have one question please is it possible to have more than one voting disk on the rac cluster oracle because i want to create two voting disk on two different share disk and if one is lost the rac oracle can write on the second disk voting thanks for your help
ChrisMcA
Hi all - I've just installed the Instant Client on Solaris - but I'm not sure how I actually connect to my database using it
hm, think I just worked it out :) sqlplus user/pass@host:port/sid
is that correct?
TheBonsai
yes, or using TNS (mh, maybe not with the instant client)
ChrisMcA
thanks
this may be a slight off-topic, but I'm trying to run some PL/SQL from a perl script and am getting the following error back from the DB; http://pastebin.com/d546b7497
can you spot anything obviously wrong with that SQL?
TheBonsai
sorry, no :) does the identical statement work in sqlplus?
         

ChrisMcA
ah, just got the answer from #perl - it was the braces apparently
TheBonsai
ah
awaad
How can I install oracle 10g standard edition not the express edition on ubuntu 9.10 ?
Any one can help, Please ?
mator
awaad, download se and install
awaad
mator : can you give me a link that is suitable for ubuntu ?
dballester
hi to all
Trengo
hello dballester
mator
awaad, I'm not sure that ubuntu packages exists for oracle db
Trengo
there arent, i dont think so
xe perhaps
dballester
awaad, searching for oracle 11g in ubuntu ?
mator
awaad, and your download link is http://www.oracle.com/technology/software/products/database/index.html
awaad
dballester : no , I want 10 g
dballester
http://www.akshaymehta.com/2006/12/10/installing-oracle-10g-r2-on-ubuntu-edgy/
awaad
mator : I downloaded oracle 10g for linux but while trying to install it I found it not suitable for ubuntu but for suse and other distros
DiscordianUK
How so?
hali
it is unsupported by oracle yes, but there are ways around it if you want to play around in a dev environment
dballester
runinstaller -ignoresysprereqs
DiscordianUK
I was about to suggest that flag
My how so was to awaad
awaad
dballester, DiscordianUK : But I think it might give me broken data base
dballester
awaad, google will give you TONS on links to sites explaining how to install 10g / 11g in Debian/ubuntu boxex
boxses
DiscordianUK
awaad: stop before you create the db
dballester
awaad> dballester, DiscordianUK : But I think it might give me broken data base <-- ¿?¿?¿?¿?
DiscordianUK
and use the db assistant to do that
awaad
DiscordianUK : My problem that I am a begineer in the database field, I only wants to practice on sql
dballester
virtual machine, install Centos, install Oracle, paractice :)
DiscordianUK
So why the instance on it not being 10 XE which is nicely package
d
and I agree with dballester
dballester
+1. DiscordianUK
DiscordianUK
10 XE+Centos 5.4 would be perfect to learn on
awaad
DiscordianUK : mmm, Now I am installing xe
dballester
and for XE you've a pacakge for debian/ubuntu
awaad
Thanks every one for your help, Now I am installing Oracle 10g on ubuntu
Thanks alot
DiscordianUK
Another satisfied customer
dballester
and awaad, don't forget to learn from a good source http://www.amazon.com/dp/0130123811 , http://www.amazon.com/Effective-Oracle-Design-Osborne-ORACLE/dp/0072230657/ref=pd_sim_b_6 , tahiti.oracle.com
DiscordianUK
He's gone
dballester
XXI century way of life. Give me it fast, fast, fast
DiscordianUK
Well yeah
dddh
yay!
(Action) has latest sqldeveloper
^_^
dsdel
unbelievable!
godlike!
:D
Franek_K1mono
iddqd!
:D
dsdel
fkfiut!
telles
hey, any one know about using multithread in sparc with RAC?
hali
oracle generally uses processes
and shared memory
telles
hali: hum... what does it mean? (sorry for the dump question)
hali
or are you talking about MTS?
telles
hali: well, i don't know much think about Sparc. I usually work with linux. My client make these question to me and I am completely lost...
hali: a google doesn't help me too much... metalink too.
mator
telles, why do you need to know that ?
telles
mator: my client want to know with opion (use or not multithread) perform better.
s/opion/option/g
mator
telles, there's no a different oracle versions on the oracle.com site (with multithreading and other one without), so there's just nothing to compare
TheBonsai
it does "multiprocessing", full-stop.
hali
oracle used to have MTS, but that is way deprecated now
kok
hi i have one question please is it possible to have more than one voting disk on the rac cluster oracle because i want to create two voting disk on two different share disk and if one is lost the rac oracle can write on the second disk voting thanks for your help
thanks
i want to make a mirroring disk voting
mator
there's no mirror for voting disks :)
just another additional disk/lun as voting disk
btw i don't know does oracle support more than one voting disk, but veritas does
idletask
Hello
With oracle rdbms 11gr2, is there a way (an environment variable or whatever) to put the $OB/diag directory somewhere else?
mator
kok, i think it possible to use more than 1 voting disks with oracle
crsctl add votedisk css /dev/raw/raw1
raw2, raw3, etc...
hali
kok: one way is to have a 3rd disk on a random machine somewhere, like on NFS
mator
but you should consult to rac guide on adding it
hali
kok: you need >50% of the voting disks online
Dormir
I thought it was required to have more than one
mator
veritas requires at least 3 to be online
hali
veritas sucks1
mator
:-p
hali
not that there are any nicer alternatives for some things
on x86 medium workloads i just use vmware ha these days
idletask
Also, why does the stupid installer says it needs 1 GB in /tmp when all it needs it not even half that? Gee
hali
why can't they just wrap it up in a couple of rpm's :P
idletask
Hmm
yum install oragenine-11gr2
Yes, that'd be nice :p
For the time I've been using Oracle 10g, I still haven't found a way to mount the LV with the engine on it read-only
Oracle always needs to write some obscure file to some obscure place
And 11g weighs twice the disk place as 10g :(
disk space
TheBonsai
the files it writes are process instance lockers i guess
cmug
our veritas cluster takes 40+minutes to failover a failed service to another node
I usually react alot faster
idletask
TheBonsai: well, there's /var/lock... I wish I could tell it to obey the FHS :/
mator
cmug, why so slow
we have HA installed, but all my service groups are parallel, so there's no actually any failover in my configuration
cmug
mator, i was told it is supposed to be like this. HOwever it is not Oracle related in our case
we use veritas for another application
TheBonsai
idletask: and the FHS guarantees that the oracle software owner has write permissions?
(infact the FHS is as thought-through as the LSB - not at all. but LSB handles everything difficult by referring to IEEE1003.2 :) )
idletask
TheBonsai: it doesn't, no, but you can do it right by yourself (install -d -m700 -o oracle /var/lock/oracle)
As the binaries are not supposed to move unless you patch them, you can just mount them read only and remount rw when patching is needed
Makes for a clean setup
Everything in its place
TheBonsai
"its place"
FHS is a farce :)
idletask
No it's not
When I'm looking for logs, I know where to find them
I cannot really say the same with Oracle
TheBonsai
your logs are where they are configured to be
with your system
with webservers
ftp servers
and oracle
idletask
Yes, but packagers are smart enough not to make a mess of it
cmug
that reminds me, how do you guys read 11gR2 alert logs? its in XML now so do you know of any nice console xml viewers
idletask
httpd on RHEL has its logs in /var/log/http
httpd
Logical
TheBonsai
cmug: there's a textfile
idletask
cmug: there's a text file in trace/
cmug
TheBonsai, really
even with R2?
idletask
Yes
TheBonsai
yes
cmug
ok, makes life easier then
thanks
kok
hali : ok if i have two votink disk and one is down the cluster is not break because the both server can write on the second voting disk ?
veru thanks for your help hali and mator
i must have 50% of voting disk is up if i have two votink disk i must have one is up ok thanks i search now how i can do that i think they are a oracle doc to do that thanks
TheBonsai
idletask: "logic" is subjective. really. you just wish to see everywhere what you're used to see, i think.
hali
kok: yes, if a node can't see the other node it will not start up without >50% of the voting online
if it can see the other node it doesn't need to care about split cluster etc
idletask
TheBonsai: well, yes, ten years of operating Linux machines with a standards compliance file system gives you some habits :p
kok
hali : ok very thanks for you help and your explication
idletask
TheBonsai: and it facilitates administration a great deal, especially if you use LVM
TheBonsai
idletask: i know that. but i also know why oracle doesn't care. the architecture is like an os-in-os, the assumptions towards the underlying system are minimalistic. the software stack is more or less portable, not only in terms of code. and: you're not the only one who has seen *X boxes 15 years ago ;)
sometimes i have the feeling oracle needs the OS just for the hardware drivers
heh
idletask
TheBonsai: it may not care, but why doesn't it give the means for users to customize this kind of things if they want to?
If it's documented somewhere in the 3000+ pages of documentation, I have not seen it yet
And fortunately, I didn't see Unix boxes from prehistory
TheBonsai
if you code and distribute in a really platform independent way, you have not much choices i guess
there's a bunch of linuxes around with extremely non-FHS structires (/Programs, /User, ...)
oracle can run there
idletask
Uh, which ones? I haven't seen any for now :p
TheBonsai
there were some projects about this kind of stuff the last few years
don't remember the names, i usually click such stuff away
and by the way, i won't like a distributed oracle
you remove 3 or 4 files and oracle is gone
at the moment
brb smoking
*pof*
« prev 1 2 next »