logs archiveIRC Archive / Freenode / #oracle / 2010 / May / 12 / 1
vincs
hey, is there big performance differences btw nested tables and varrays
KeiKurono
morning
solar_sea
when doing a select from sqlplus, how do I set it to print all the results in one list. (it's currently printing them in batches of 10)
BfrOv3rfl0w
solar_sea: e.g. set pagesize 1000
solar_sea: set pagesize 0 (for infinite)
BrixSat
Hello is there any way i can only return data since midnight, having in a table a column date?
ygip
Is there any dfference performance wise to have a conbstraint on a table and add rows or add the rows and then add the constraint? Are these two ways of ending up with a table which follows the constraints equally fast?
e.g. adding a foreign key
DoubleString
good afternoon guys
yegz
lo.
hali
rizzo: what active/passvie cluster failover products do you see these days? do people use anything "new"?
or everyone else for that matter
         

Trengo
for oracle?
hali
yes
Trengo
no idea...
solar_sea
BfrOv3rfl0w, thanks
and how can I print something from a pl/sql block ?
BfrOv3rfl0w
solar_sea: look at the DBMS_OUT package
solar_sea
do I need any special roles or sys.privs on my user to use it ?
hali
dbms_output.put_line('dog')
not dbms_out
rizzo
set serveroutput on
is also required
hali
rizzo: ^^
rizzo
hali: I have no cluster cred
hali
ok
people seem to go for rac
i have a few SE One installs with close to no load and due to compliance can't virtualize
just need something to kick them back and forth between the nodes
dsdel
hali: http://www.libelle.com/en/ perhaps that what you search for?
never used it though but recommended to me from several partners of us which are also partners of oracle
rizzo
I'm of the opinion that RAC is usually not the solution people think it is
hali
i have a DR site with netap snapmirror replication for the actual failover, rac is simpy local failover... i can even mount NFS over the WAN (dual gig)
clajo04_
I've got an x64 installation of 11g, but the application I want to use to access the database needs a 32 bit client - are there any guides on how to install a 32 bit Oracle client for my app without causing problems in my x64 environment? It all has to run on the same machine.
Sorry - should clarify - I'm in a Windows 7 x64 Ultimate environment.
RJarett
put it in a new oracle home
use the oracle home selector
or use instantclient
clajo04_
RJarett: How does instant client resolve TNS names?
RJarett
with a tnsnames.ora
clajo04_
RJarett: just drop a properly formatted tnsnames.ora into the same directory as the client libraries?
RJarett
read the docs
         

clajo04_
RJarett: Okay - will do. Thanks for the pointers.
RJarett
TNS_ADMIN var will come in handy. google it
zasz
RJarett: just built my first rac cluster :)
OCR and voting disks are on raw devices, database files on ASM
RJarett
cool
zasz
hmmm just noticed that the raw devices in /dev/raw permissions have been reset when i rebooted the node
RJarett
set the udev entries for them?
zasz
chown root:oinstall /dev/raw/raw1
chown root:oinstall /dev/raw/raw2
chmod 640 /dev/raw/raw1
chmod 640 /dev/raw/raw2
just that
RJarett
udev ftw
zasz
didn't see anything about udev for them in the manual
yep looks like that's what I need
yea that did it
RJarett
yep
dev sucks since the crap switches up on reboot or when you add new devices
udev locks it into place
zasz
1. Add udev permission rules to /etc/udev/rules.d/65-raw-permissions.rules file
2. Add the udev permission rules to the /etc/udev/rules.d/65-raw-permissions.rules file, for example:
# Set permissions of raw bindings to Oracle Clusterware devices
KERNEL=="raw2", OWNER="oracle", GROUP="oinstall", MODE="640"
KERNEL=="raw1", OWNER="root", GROUP="oinstall", MODE="640"
did that
another odd thing is that user equivalency is not persistent
ie, if I log off and log on on node1, if I ssh node2 date it asks for the key password
User equivalence will need to be enabled on any new terminal shell session before attempting to run the OUI. If you log out and log back in to the node you will be performing the Oracle installation from, you must enable user equivalence for the terminal shell session as this is not done by default.
lame
how can you configure persistent user equivalence
Dormir
user equivalence with ssh should be persistent
there are quite a few articles on the web on how to do it
zasz
yea, but the article even says you have to re do it if you start a new session
and it's behaving that way
this is how it does equivalence,
$ exec /usr/bin/ssh-agent $SHELL
$ /usr/bin/ssh-add
same way as the manual does it
but say i exit that session and login again, equivalence is gone
well, time to test out patch set 10.2.0.5 on this
Dormir
there's a way to do with without ssh-agent and ssh-add
I did something similar to this: http://linuxproblem.org/art_9.html
delewis
just do a ssh-keygen, take the id_rsa.pub, and toss it in the authorized_keys file on both sides.
ssh to/from both nodes to get the keys placed in known_hosts
and boom. you're done.
Dormir
yep, that's what that website says
DiscordianUK
ssh-copy-id is a very useful tool
« prev next »