logs archiveIRC Archive / Freenode / #oracle / 2010 / March / 9 / 1
markl_
working on failover issues between two data centers
how painful is it (or is it even possible) to have listeners on two sites that hit the same database, so if either end goes down the one that is still up can immediately take over?
nevermind the routing issues for the moment, just trying to think about how the oracle part would work
rek55
Anyone alive?
Never...
Why do people even idle in this channel?
DiscordianUK
Why not
rek55
Heh
I'm having an issue because I have a REF type which I want to use as a foreign key. This isn't allowed, so I created an actual foreign key but I want to be able to find the record the foreign key points to, or alternatively create a new column for the ref which will be filled automatically for ease of use
DiscordianUK
(Action) has no idea
rek55
ok. To finish posting my Q anyways right now i'm thinking about defining my own constructor, but i'd rather not rewrite the rest of the constructor and just call the default one to begin with and then have my added behavior
Heh. Maybe the reason so many people idle in here are because they've been waiting for their Q to be answered. Like purgatory :P
DiscordianUK
In the UK where I am it's 01:18 (am)
rek55
late
on the west coast it's only 5:13pm
DiscordianUK
aye
         

rek55
but i've got 2 hours left before this is due
DiscordianUK
(Action) has no idea about the problem
rek55
Yeah
thanks for the company anyways :P
DiscordianUK
i'm a sysadmin not a developer
j3g
a friend of mine was having trouble doing an EXP from an old oracle install (10.1) using a release 2 client... is it really troublesome or was something that he did wrong? He said it worked after he changed to 10.1 client
anyone knows a way to download older versions of the client?
Xgc
j3g: Why not use expdp?
DiscordianUK
I never have had problems with exp
j3g
Xgc: can expdp handle different versions well? the data is on a 10.2 into a 10.1 .. i know that EXP/IMP require you to use the exp.exe of the older version (ie from 10g to 9i, use 9i's exp on 10g then 9i imp)
DiscordianUK
(Action) shudders
That's doze
Xgc
j3g: No. 9i can not use the result of expdp.
DiscordianUK
I doubt very much you can migrate exports to earlier releases
Xgc
j3g: That's because 9i has no impdp.
j3g
Xgc: expdp comes with oracle administrator tools?
Xgc
j3g: Otherwise, you could use the VERSION option to export objects compatible with any corresponding version.
j3g
version option is for DP or regular exp?
Xgc
j3g: It comes with the Oracle server install.
j3g: I'm only talking about expdp and impdp.
j3g: This is new to 10g and beyond.
j3g
Xgc: ok let me look into it
Xgc: the DIRECTORY= clause of expdp, does it point to a regular dir? like DIRECTORY=c:\dump
?
Rudemeister
j3g: y
TheBonsai
m00
solar_sea
If I declare a variable, can I later declare a variable with the second name in an execute immediate block, and would it be correct ?
with the same name*
How do I escape single quotes when using an execute immediate 'statements;..' ?
         

usn_work
rizzo!
rizzo, you are flapping
corpsicle
ok so i had two servers with rac on them, and at one point i changed the ip addresses, what are some places i might have forgot to change
the ons doesnt seem to work quite like i want
Reign1
hi, how to check present shared pool memory size
mator
Reign1, V$SGASTAT ?
Reign1
mator: thanks, and also, alter system set shared_pool_size = 256M (egzample), is this correct, i dont remember
mator
Reign1, yes, try to google :)
Reign1
worked, thanks ;)
mator
rizzo_, fix your connection
miss :)
usn_work
flapping connections are THAT annying
mator
will live with it for a day... then I'll unban him
usn_work
ack
RuslanPopov
I have a table with consistent data (id, pid, the rest), I want to merge it with other table of the same structure, I do it with MERGE statement, but sometimes got FK error
usn_work
FK errors with merge have the same reason as in INSERT or UPDATE statements
RuslanPopov, make sure that the appropriate values are in the referenced table
RuslanPopov
I sure
I solve this so: disable FK, merge, enable FK - profit
so the reason is inside unpredictable merging order
usn_work
ah, ok
solar_sea
Why does "ALTER TABLE T1 ADD CONSTRAINT FK_T1 FOREIGN KEY ( A1 ) REFERENCES T2 ( A2 ) on delete no action" gives me an ORA-00905: missing keyword, but it works without "on delete no action" ?
From what I've read oracle supports on delete {restrict, cascade, set null, no action}, however on XE only restrict seems to work
steelnwool
maybe i'm a bit slow, but i can't see how to get to a metalink article from my SSO account.
usn_work
steelnwool, log in on support.oracle.com
steelnwool
aye. i'm there.
usn_work
what do you see?
What do you look for?
steelnwool
dashbaord/knowledge|service requests.
specifically i'm looking for 294212.1 metalink article.
usn_work
top right there's a search filed
TheBonsai
no text imput box at the top right?
usn_work
field
steelnwool
there is, but i enter 294212.1 and i get something about shipping methods.
i was hoping to find the article about vmware support.
referenced from this http://blogs.vmware.com/virtualreality/2009/05/chris-wolf-blog-post-oracle-now-fully-supports-non-oracle-x86-hypervisors.html
usn_work
its the wrong article
steelnwool
fair enough.
ah found this: https://support.oracle.com/CSP/main/article?cmd=show&id=794016.1&type=NOT
that should help/
usn_work
and, its a lie
steelnwool
so its not supported? there seems to be so much FUD around this topic its annoying.
usn_work
Its a tristate
TheBonsai
"supported" might not be the right term
usn_work
They support known errors. But if the error is new, you have to proof that it happens on hardware as well
steelnwool
except this came from the support statemnt
TheBonsai
additionally, VMWare counts as "soft partitioning" afair, which might be (or not) a license hell
steelnwool
"What this means is that while these technologies are not certified, Oracle will not turn away a customer reporting an issue solely due to the use of these technologies. When possible Oracle will triage and attempt to diagnose the issue reported ? Oracle support may attempt to replicate the issue in a non-virtualized environment and work with the customer to verify if the problem exhibits in such an environment. "
usn_work
(given, they did recognize that you are on Vm at all) ;)
They support known errors. But if the error is new, you have to proof that it happens on hardware as well
(given, they did recognize that you are on Vm at all) ;)
steelnwool
well, ps aux|grep vmware kinda can give it away in a hurry if you have vmware tools installe.d
usn_work
Licensing has nothing to do with certied platforms and/or support
steelnwool
ah.
usn_work
No OSS supporter will connect to my machine at all, and no RDA will leave the house
If they want something, they have to ask.
steelnwool
RDA?
TheBonsai
a information collection tool
*an
usn_work
All my SRs are that way, and I#ve been working well this way
steelnwool
i'm new with oracle acronyms, so what is OSS and SR ?
usn_work
OSS= Oracle Support Services
SR = Service Request, also known as TAR or iTAR
TheBonsai
usn_work: (licensing on VMWare) hence the word "additionally"?
steelnwool
vmware also lists a fairly decent list of companies running oracle on vmware. doesn't mean its well supported i guess. just that it works.
usn_work
licensing on VMware means to license the full box, and consider the full box for your edition choice
steelnwool
http://www.vmware.com/solutions/partners/alliances/oracle-database-customers.html
usn_work: yeah i'm okay with that part actually.
usn_work
And VMware has vast perfromance penalty, compared with XEN
TheBonsai
usn_work: in the worst case, the full cluster
usn_work
(OracleVM is XEN as well)
steelnwool
we don't use oracle for its performance. we use it cause our market dictates that oracle is what you use.
usn_work
TheBonsai, ack
steelnwool
postgres would do what we need 100% fine :)
usn_work
steelnwool, if you want to save your nerves, switch to oracle supported platforlms, use OEL on Oracle VM
steelnwool
OEL , enterprise edition?
usn_work
no licensing cost for the hypervisor, fully supported stack, full performance
OEL= Oracle Enterprise Linux
steelnwool
yeah fu*k OEL.
it sounds like the dumbest idea ever really.
usn_work
It's RHEL
works like a charm
steelnwool
i plan on using actual RHEL.
when i see OEL i think "larry the grabass"
usn_work
RHEL + Oracle VM is worlds better than VMware
steelnwool
so oracle vm is free?
hali
usn_work: what?!
oracle vm is sh*t
the version i tried about a year ago was at least
doesn't even compare to vs4
usn_work
Did you compare Io performance as well?
hali
plus close to no 3rd party vendor support
io performance is the only thing i can imaging xen being better at
but then again, kvm is even better
doesn't mean i would use kvm in production
usn_work
Oracle VM 2.2 uses XEN 3.4 core now
it's a lot more usable with the features now
And IO performance is all I need from a database ;)
Maybe my view on the topic is one-eye-blind ;)
steelnwool
all i need is the Oracle sticker.
hali
i need vmotion, drs etc
monk12
hello all, i installed the 11.2 instant client, (and a bunch of other stuff like sqlplus, odbc) on my linux test box. i was about to test a connection to a test oracle 11 server our company has up and running... but i noticed i had no tnsnames.ora on my system, or a $ORACLE_HOME/network/ folder unlike the other prod machine i saw that currently connects to the server...
Should i have a tnsnames.ora if i installed the client or should i manually make one and copy someones updated tnsnames.ora into it (think i read you can connect with sqlplus without a tnsnames.ora file, but its annoying to type that whole string on the command line)?
and ... what is that network folder for (hopefully im not missing some important folders)?
usn_work
its for tnsnames.ora and sqlnet.ora
you can create tnsnames.ora manually or by using netca
but you only needit if you want to use TNS names. jdbc connectors or easy connect are working without it
sqldeveloper does jdbc, as well
monk12
hey usn_work... what do you mean 'by using netca'? k maybe i shall create it manually.
usn_work
netca is a tool
network config assistant - nice java for the non-vi guys
monk12
k thanks, ill check it out. i see i can connect now with a straight up tns-string via sqlplus... windows was... sqlplus myUsername/myPass!1@tnsstring ... linux needed... sqlplus myUsername/myPass\!1@'tnsstring'
usn_work
??
I'm on linux.
I connect with "sqlplus user/pass@tnsname"
or "sqlplus user/pass@1.2.3.4:1521/servicename
always without the "
monk12
oh... well, i dont have a tns file yet on my system... i am using the longggg string just to test quickly... aka... sqlplus user/pass@(description=(address_list=(address=(protocol=TCP)(host=$ourdbhost)(port=$ourport)))(connect_data=(service_name=$ourServicename)))
usn_work
one possibility
monk12
on linux i needed to put that string in qoutes after the @. ... plus it still didnt connect... i needed to escape my password which had an exclamation point in it with a \!
usn_work
but for simple cases, try my syntax above
sqlplus user/pass@1.2.3.4:1521/servicename
MaL0_
sqlplus user/pass@tnsname
usn_work
sqlplus user/pass@1.2.3.4:1521/servicename
it's called easy connect
monk12
ahh, gotcha. u specifiy the host so should work. let me see...
usn_work
no specialties work hre, like TAF, but for simple cases ...
monk12
yes that worked :).
usn_work
bit easier to type
ok guys, got to go. Bye
monk12
lates!
so my other question... my prod and dev box are really different, http://paste.org/pastebin/view/16116 what are all those other folders from my prd box?
thought they would have same folder structure since i installed what i thought were the same rpms (my dev box has slightly newer client)
rizzo
huzzah
sorry about the network noise everyone
Windows 7 did something with my network overnight
I just instaled Win7 last night, so it's all new to me
plus xchat is somehow set to auto-rejoin and I can't figure out how to disable that
Guest87020
ehr
:P
Xgc
rizzo: /set irc_auto_rejoin off
http://xchatdata.net/Using/FAQ#autojoin
rizzo
Xgc: thanks
you'd think it would have a GUI for it
at lesat I couldn't find one
monk12
so anyone familiar with my question about an oracle linux install... my dev box is really different than prod after installing what i thought were the same rpm's (instant-client rpms), http://paste.org/pastebin/view/16116 ... what are all those other folders from my prd box?
Xgc
monk12: You probably installed the client package over the server package on the production box.
monk12: or over some other packages.
TheBonsai
make sure ORACLE_HOME is what you expect it to be, you ls $ORACLE_HOME, not the current dir
Xgc
monk12: echo $ORACLE_HOME ... on both machines.
monk12
Xgc, so the server is installed on the prod server. where should the server installed directory normally be? and ORACLE_HOME should be where the client is right? On prod it looks like '/home/oracle/app/oracle/product/11.1.0/client_1' and on my dev box i set it manually to /usr/lib/oracle/11.2/client (where i thought it should prob point to)
Xgc
monk12: I suspect you didn't install instantclient where you thought. You probably installed instantclient in $ORACLE_HOME/instantclient on the prod machine.
Just a wild guess.
monk12
yeh, gotcha. well its a good guess, i didnt setup that machine ;). just trying to figure out what to install and not install for my test box to duplicate that box.
TheBonsai
clone it.
« prev 1 2 next »