logs archiveIRC Archive / Freenode / #oracle / 2010 / April / 19 / 1
MrWGW
would any of you folks happen to know where I could find an RPM for RHEL/CentOS/etc for ocfs2console?
I found several for Fedora but none for Red Hat/CentOS etc
the Oracle docs say to look on oss.oracle.com but dang it if I can't find it
DiscordianUK
get the .src.rpms for Fedora and build those on CentOS/RHEL
are they in EPEL?
RJarett
FYI: kickass was a pretty good movie.
DiscordianUK
EPEL is Fedora stuff rebuilt for RHEL/CentOS
MrWGW
DiscordianUK: I'll check that
EPEL is a good idea
the real WTF is Oracle's docs sending me to the wrong place
RJarett
well oracle is starting to ditch oss w/ their recent sun purchase
DiscordianUK
indeed
It's all a mess right now
MrWGW
except OCFS2 predates the Sun purchase
RJarett
yeah ocfs2 is pretty freakin old
http://oss.oracle.com/projects/ocfs2/files/ 2008
http://oss.oracle.com/projects/ocfs2/files/RedHat/RHEL5/x86_64/1.4.4-1/
looks like its been updated alot though
http://oss.oracle.com/projects/ocfs2-tools/files/RedHat/RHEL5/x86_64/1.4.3-1/
theres the console rpm
found with a very basic google search
         

MrWGW
(Action) looks
RJarett
searching for ocfs2console
and just going to the project page for it :P
also a link from the ocfs2 on linux oracle base link #1
Junior
yello ;)
KeiKurono
morning
usn_work
good CEST morning
cofeineSunshine
:)
usn_work
I want to delete several rows, when one special row is deleted. (deleting rows with status 30 should delete rows of status 31 and 32 as well)
A delete trigger does not work, since it would trigger itself
is there a way to solve this problem on DB level?
KeiKurono
you could use another table, duplicate to the one you want to delete rows, and two triggers
maybe
when the first table has deleted rows, it trigger for deleting that rows in the duplicate table, so the second trigger is called, that will delete the rows on the first table so you have no recursion
ronf
twantakur
hello
what's the quickest way to backup oracle data
i have 128 Giga size data
usn_work
the quickest way at all is a split mirror backup on your storage, but might be oversized for you
have a look at RMAN
twantakur
is oracle have data file like microsoft sql server (.mdf) or mysql .frm .myd
dsdel
twantakur: sure, only if you use raw devices then not :)
emboss
Hi, I was wondering, I'm going through an Oracle 10g Cluster setup to test a bit of software, reading the documentation there's no mention of setting up windows clustering first, is this not needed or?
RJarett
#1 why would you use oracle on windows #2 why would you if you wanted it to be reliable? #3 windows cluster isnt needed if you use RAC
emboss
RJarett: I do as I'm told :)
puuck
we have some instances on windows that are pretty solid
RJarett
yeah, loading a critical db on an OS that give you no visibility into tuning the IO or memory stack
emboss
RJarett: It's not critical, I'm just testing
RJarett
if its nto critical why bother clustering it?
unless you have 3x more money to burn
emboss
RJarett: Because it will be critical when it hits production :)
         

usn_work
test it on a performable platform
uns some unix, there are enough commercial unices supported by oracle - Oracle on Windows is PITA ;)
RJarett
centos.
usn_work
You are right, but some people don't like OSS. Fr sh*tty reasons
emboss
usn_work: I want to test it on what the customer will eventually use, There's no point me testing in on RHEL when they're going to use windows
RJarett
how do you know exactly what they will use?
yuo didnt even know if it needed mscs
why doesnt the customer hire a real dba to do this?
emboss
RJarett: Our software has nothing to do with DBA what oracle uses for clustering is really irrelvant
RJarett
then why would the OS it runs on any any relevance as well?
from an application standpoint, it doesnt know its clustered. or if you use TAF all it really is is a different connect string entry
nothing more
usn_work
Customers often tell you what platform to use
RJarett
doesnt matter
emboss
RJarett: it doesn't, but I want to make sure it works tested on the platform they're going to use, I don't care what they use, it's not my problem nor concern
usn_work
Not? If you have to support different platforms, and you want RAC, you have to test it on all platforms.
RJarett
he isnt doing any of the setup or db side it seems
not for the customer
or i hope not
all he needs to do is be able to connect to it
emboss
RJarett: no, I'm not :)
RJarett
so in terms of his app the only difference is the connect string it uses
and that it is smart enough to handle recreating dead connections on TAF
emboss
RJarett: Indeed
usn_work
so why not testing on Unix/Linux?
emboss
usn_work: Because I want to test on the platform it will be used on, simple
:)
usn_work
Again, why Windows?
Why will it be used on Windows?
emboss
sigh, I have nodea, maybe they have no linux/unix admin?
usn_work
<usn_work> Customers often tell you what platform to use
...
emboss
They want Windows, that's what they use, what's the mystery?
RJarett
it doesnt matter the host os for the db
usn_work
it does
RJarett
how YOUR app will connect to the db does not
usn_work
true
RJarett
usn_work: stfu
he is just an app developer
usn_work
no
puuck
it doesn't matter to the app, but it might matter to the sysadmins
usn_work
RJarett, customers have sysadmins. And the zoo of admins makes the customer to fix the platform
sad but true
RJarett
usn_work: you are pertty dense
usn_work
very constructive argument
RJarett
all he needs to do is test failover capabilities
usn_work
do you geuss or know?
RJarett
with RAC, it does not matter in the slightest what host OS the db is on
failover is the same from the app standpoint
puuck
oracle doesn't care, but configuration of all the components is different between OSes
RJarett
puuck: his app doesnt care
it sees nothing beyond or behind the db
puuck
so he wont' be setting up the DB?
in prod?
RJarett
not on the customers systems
puuck
if this isn't a test run for the DB setup then you're right it doesn't matter...the failover will happen the same way
RJarett
plus its easier to test failover and debug everything from a non windows install
pee-kay
is there some kind of "oracle simulator", or something similar, for learning purposes?
RJarett
oracle xe
why use a similator when they let you use it for free?
pee-kay
thanx!
RJarett
you can download the other DBs
but xe is easier for learning
pee-kay
i'll get that and try
anyone knows of a simpler tutorial about resolving functional dependencies? everything i'm finding seems to be very technical / engineering oriented
full of maths stuff, closure and such...
it all seems easy when you read it, but when you come to apply it to your own diagram it looks more complicated than it seemed
:D
KeiKurono
i had a set of algo for that i remember pee-kay
taken from a university course..
i remember i found difficult to extrapolate the correct f.d.
pee-kay
it's a mess when you have dozens of relations
KeiKurono
i can imagine...
RJarett
or just use a tool to map the relations for you
pee-kay
there's a tool for that?
RJarett
yeah for the last 20 years there have been
pee-kay
it can be useful, but i'd prefer to understand the concept
RJarett
and what does understanding the concept have to do with diagramming it?
zasz
he's a visual learner!
pee-kay
i found a program called DbVisualizer
but it's commercial
i'm off now, thanx for the help, see you later :)
bencc
how can I change all the DATE columns in my db to TIMESTAMP columns?
RJarett
dbms_redefinition
but are you sure you want to?
bencc
RJarett: why not?
RJarett
alot of side effects
timestamp are a tad hard to work with. esp with java
bencc
I'm using Django which I hope abstract it for me
the problem is that Date doesn't have fractional seconds and django DateTimeField expects fractional seconds
emboss
anyone know common problems for "nodes are not clusterable" I've made sure all accounts have passwords and all network settings look "good" 10g on win2k3 R2
it complains about user equivalnce not set for one of the nodes tho
vinse
we have a server with two instances. one of them is much slower than the other: i have a script that iterates through all schemas on both instances. the script takes .3 seconds for the b0 instances, and 2 or 3 seconds each for the b1 instances
but the *query* takes the same on both, it seems as though what takes longer is getting the connection?
i wrote a java program that does nothign but get a connection from each schema, and i see no difference there
so i dont know what to think!
TheBonsai
does one connect to a shared server, the other to a dedicated?
vinse
TheBonsai: to my knowledge, they are identical
TheBonsai
can you reproduce it with a normal sqlplus logon?
vinse
TheBonsai: not sure what you mean? we have two instances on one server. i'd say they are sharing the server, is that what "shared server" means?
TheBonsai: no
TheBonsai: they take the same time to log in to from the command line in sqlplus
TheBonsai
how does that script connect?
vinse
heh ... sqlplus :/a
we're adding some output to time exactly where in the script the difference is
TheBonsai
ipc or net? tns and stuff
vinse
god i dont even know what that question means :(
TheBonsai
sqlplus can connect locally through inter process communication
or via sql*net
setting ORACLE_SID and _HOME and connecting with sqlplus foo/bar is IPC, for example
vinse
i do "sqlplus foo/bar@instance"
TheBonsai
that means there's a TNS entry for "instance"
tnsnames.ora
vinse
hrmm, interesting: connecting to sqlplus takes the same on both instances, but *disconnecting* takes longer on the slower instance
TheBonsai
hm. that kinda blows away my shared/dedicated theory
vinse
:(
TheBonsai
was the cpu_count set for caging?
vinse
that question mystifies me even more than your previous one :(
how could i check that?
TheBonsai
do you have SYS or SYSTEM access?
vinse
yes\
TheBonsai
show parameter cpu_count;
you can tell the instance another number of cpus, to kind of limit it
vinse
hrmm i guess i dont have SYS access on these dbs, i'll ask some one who does
TheBonsai
in any case check your TNS descriptors first
though i never saw any *logoff* taking so long
vinse
well, it's for sure: disconnecting from the b0 instance is instant, disconnecting from b1 takes 4 seconds
that's in sqlplus. i wrote a small java script that connects to everything and it takes the same time on both instances
s/script/program/
« prev next »