logs archiveIRC Archive / Freenode / #oracle / 2010 / February / 3 / 1
luisgrin
hi pablo
hi, after a power down oracle stop working i cant connect, im working on the same server (a dev server )
oracle seems to be on, but i cant connect
RJarett
windows or *nix?
luisgrin
windows
RJarett
is the process running?
luisgrin
i was talking to usn_work some minutes ago
i think the process is runnig
RJarett
you think
is the listener running?
luisgrin
:) i would need if it is working, but i dont know how to now it, the service is active
RJarett
your previous error indicated you didnt set your env variables
luisgrin
RJarett: but before the power failure it was working fine for 1 month or more
         

usn_work
did you check your alert.log?
luisgrin
how to put this env var ok again?
usn_work: no i did not
finding alert.log
i cant find alert.log
alert_orcl.log i found
usn_work
that's it
luisgrin
Tue Feb 02 06:05:15 2010 Thread 1 advanced to log sequence 112 Current log# 3 seq# 112 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
nothing seems to be wrong there
spcshpopr8r
any way to query dba_tab_partitions to select all tables that are "range" partitioned rather than "hash" or "composit"
?
in other words, how do I query dba_ views to identify all tables that are "range" partitioned?
Junior
yello ;)
JPavleck[Laptop]
I don't get how oracle db does regexp
I've got a table with a bunch of server names, and all I'm trying to do is return all of them that are SVR00(4|5)[09]-[09][09]
mamurdian
hey what is wrong with this trigger? http://pastebin.com/m751668c0
he says a must be declared, but i don't understand why. A is part of trigme
linkd
mamurdian: i assume you mean a as in the old value. use :old.a
mamurdian: as is now you're using a as a variable that indeed has not been declared or initialised
idletask
Hello
Using dbvault, is it possible to tell that a particular user can connect from a particular IP address _with any password_, even a wrong one?
hell
idletask: creating your own password verification function, i think.
idletask
hell: I'd rather use standard Oracle mechanisms... Given the complexity of dbvault, I'm sure there's an already existing solution
hell
idletask: it's standart oracle feature - provide pl/sql password verification function.
idletask
hell, any URL defining the feature? It may be of some interest
hell
http://www.psoug.org/reference/profiles.html
idletask
Hmm
Not what I thought about
Well, bbl
mamurdian
linkd> tnx
does a FOR EACH ROW TRIGGER makes sense with insert?
linkd
mamurdian: sure
mamurdian
i tried
linkd> why?
insert is always fired on a per row basis afaik
RuslanPopov
ppl, I need to auth in oracle 10+ through ntlm, does it possible?
         

RJarett
yes but not recommended
RuslanPopov
I need this
RJarett
why?
what do you mean exactly by ntlm?
RuslanPopov
I'll create separate scheme with users table, only OS users from MEGABOSS group may connect to it, other schemas will grant to select from this table
RJarett
just using a users already logged in session?
RuslanPopov
active directory
RJarett
active directory isnt exactly ntlm
RuslanPopov
huh, english is not my best ability, but I will try to explain :)
RJarett
NTLM is NT Lan Manager
mator
thanks C.O. :)
RJarett
its a very very old method, which may not even be available in win2k8 AD environments
RuslanPopov
I have ActiveDirectory and there is group MEGABOSS (for example), also I have MEGABOSS scheme in Oracle which has only one table - USERS
RJarett
If you want to use old NTLM: http://www.stanford.edu/dept/itss/docs/oracle/10g/win.101/b10113/authen.htm
If you want to use more AD based: http://stanford.edu/dept/itss/docs/oracle/10g/win.101/b10113/active_dir.htm
RuslanPopov
I need to allow all users from MEGABOSS group to connect into schema MEGABOSS
mator
RJarett, you're a cheater
RJarett
Or you use Enterprise Single Sign on
Or op$ based external authentication
Most AD administrators dont like adding pre-win2k compatible access though
RuslanPopov
reading about OPS$ way
sinesio
can someone tell me how to install Oracle Database 11gr2 but with a repository version 11.1.0.7?
RuslanPopov
but there is no auth by group :(
RJarett
No
sinesio
so it can be compatible with Grid control 10.2.0.5
RJarett
you will get no more functionality with that than just trying to run it as is
10.2.0.5 should be able to hook into it, but not see the new features
RuslanPopov
hmm, it seems Oracle 10xe can't work with AD, am I right?
RJarett
not easily
RuslanPopov
does it possible to authenticate the user in Oracle, given Active Directory group
?
RJarett
dont expect any advanced feature from XE
RuslanPopov
I guess the same
idletask
OK, I have my answer: impossible :(
Other PL/SQL question...
How do you use execute immediate statements within a for loop? :(
Uh, OK, PEBKAC, forget it
Grrr
Resetting the encryption key for a wallet doesn't work as the Oracle doc says it should
That's so frustrating
RJarett
lol
idletask
Not really, no :/
Oracle says a command is used to set and reset the password, the set operation works, the reset doesn't
How is the client supposed to reset, then?
I wonder if Oracle tries and eats its own medicine, sometimes
RJarett
anyone here use netapp 2040 or 3140?
hali
RJarett: i have a pair of 2040
RJarett
any PAM cards?
im pondering 1, just worried about performance for heavy IO
hali
no
RJarett
what about the snapmanager for oracle addon?
hali
nope, i use snapmanager for vmware though, works very well
last time i checked a pamII/512 was about 50 big ones
RJarett
i thought the pamII 256 was like 8-10k
since a fusionio 320 is about 6500 after discounts i wouldnt see how they could charge too much more for a similiar unit
hali
might have changed, it was 25k when introduces (after discounts, it was 40k list)
RJarett
any idea how many iops you put through the unit?
hali
not much yet, we only got them in jan
probably around 300Mbit per head in basic testing
not sure in iops
RJarett
ick
https://www.insight.com/search/ppp.web?materialId=X1937A-R5-C
6586 for a PAM II 256gb
hali
thats not too bad
RJarett
i was looking at 3 fusion IO cards for a server
but my main san is off support in June
no sense puttign 24k$ local when it can go on a small new san
but the netapps seem so freakin expensive
hali
2040 is a lot better than 2020/250
RJarett
I just hate HDS so much now
hali
2050*
RJarett
im probably going with a 3140 so i can get 10gigE and FCoE
idletask
Must be off
Have "fun"
hali
a 3140 with a couple of shelves will set you back a good 200k
RJarett
yeah i dotn need raw volume
just throughput
my backups and FRA are on my datadomain
26k for snapmanager for oracle is obscene
bda
Use ZFS? :)
RJarett
no
screw sun and everything about them
bda
itym screw Oracle.
hali
RJarett: as soon as you hit 3xxx or bigger the software price goes up a lot
plus snapmanager for oracle doesn't give that much (possible a little advantage if you have snapmirror)
on 2040 you can get the cheap'ish bundles
RJarett
yeah i probably wont go for any addons
i never get luxury feature money
But when i need to push 300gb/hr on it through 1 DB it gets iffy
and i dont have money or room for extra disk trays
takes me 3-4 hours to do it now with our HDS
next figure a way to have a standby db pulling it all in
hali: how many trays do you have on your units?
hali
12x300 in the head and 2xDS14 with 14x300 each
RJarett
ok. 12disk max in the head?
hali
yes
RJarett
your ds14 have FC, sas or sata?
hali
FC
RJarett
sucks the freakin head on the 3140 is 6u
hali
i don't even think it can take internal disks? does it
RJarett
im so limited on rack space. ill have to have one of my SAN outside the rack on the floor while i do the copy
im sure the datacenter will love that
hali: i hope it does some. if not im a bit screwed by the cost on that option
3140 with no disks in a/a setup it 73k inc 3 year support
20k of that is the damn nfs license
but FCoE or FCP i wouldnt need nfs
what did you ds14 cost you with the 300s?
hali
about 17k
USD
RJarett
not bad
ds4243 w/ 24x450gb was 49k
hali
because it's so new
and demand is high probably
RJarett
you have the mk2 or mk4
hali
mk4
RJarett
i wish the 2040 did 8gb
hali
bit surprised it doesn't, i would expect the chipsets to cost the same these days
RJarett
or at least if it took 1 io card.. ugh
hali
2050 does, can take a 10gE... but it's got a slower cpu and less ram than a 2040
RJarett
2050 is older and slower
hali
dedupe time on 2040 vs 2020 is grim
RJarett
what do you mean?
hali
a 512gig volume takes like a sixth of the time for the weekly dedupe scan job
RJarett
i wont use much dedup since its post processed and i have such high changerate
ok
hali
wonky celeron vs. a dual core low end xeon
a30a37
Hi! I am installing Oracle 11g on debian 5.0. Installer says that i should have make-3.80 to install software, but i have make-3.81 in debian... Is this normal? What to do in this situation?
the same situation is with another packages: binutils, gcc, etc
mator
proceed with installation ?
a30a37
i dont understand...
instalation stops on the package list and cant click "next"
« prev next »