logs archiveIRC Archive / Freenode / #oracle / 2010 / April / 23 / 1
eoliva
when I start a session, I set the SQL_TRACE = TRUE, and issue some sqls, in the same time, I log on the server and watch the sys.v_$session table...I see the new process, but the SQL_TRACE field, is always disabled. I saw that my init.ora does not have a user_dump_dest, could be it?
Mr_Grim
has anyone ever got: OAUTH marshalling failure connecting with java?
pb30
is anyone familiar with oracle webcache?
_Maru_
is there a way to assign the result from a HOST(sql*plus) command to some variable?
RJarett
huh?
when you use host, you are out of sqlplus
_Maru_
yeah but it outputs the result... is there anyway i can catch it?
RJarett
so you go in sqlplus, and then host out
and then run a script?
wtf are you talking about
_Maru_
I want to get the dir sql*plus is using and output spool files there
RJarett
yeah thats pretty stupid
         

_Maru_
I see... stupid cause you can't do it?
RJarett
your logic is flawed
_Maru_
how so?
RJarett
how much is the answer worth to you?
_Maru_
my pride
RJarett
not worth enough
but ill give you a hint. it involves pwd
sileni
how do i get sid of my database through a query?
r0
(Action) zzzzzzzz
electricalan
hey can somoen help me with a query or two?
here is my schema http://pastebin.org/167051
RJarett
no free items huh?
electricalan
-- f) List all items on sale, their wholesale price, together with each item's percentage markup. Use the alias 'Markup' for the markup column. Include only the Store's Name and Address, the Item's full Name and Brand, the wholesale price and the markup. Sort the result in descending order of markup.
select Store.storeName 'tore', Store.address, Item.itemName 'Name', item.Brand, Item.wsprice, 1000((saleItem.price - Item.wsprice)/item.wsprice) as 'Markup' from SaleItem, Item, Store where saleItem.product = item.code and saleItem.SIStore = Store.SID group by Store.storeName, Store.address, Item.itemName, item.Brand, Item.wsprice order by Markup desc;
RJarett
heh homework
electricalan
yeah pretty much
anyway my query looks fine
but i get the error, from keyword not foudn where expected
RJarett: any idea what im doing wrong?
i'm pretty sure it's identical to one of my peers but it doesnt work
RJarett
wtf is 1000((saleItem.price - Item.wsprice)/item.wsprice) ?
plus your () are all screwed up
electricalan
ohrly
sh*t didnt notice that
was meant to be 100*
RJarett
and notice how you are doing sh*t like as 'whatever' and then 'whatever'
which are you going to use?
electricalan
yeah
does it mater
RJarett
yes
electricalan
do i have to be consistent?
and my brakets r fine
bah
i still getthe same error
RJarett
its your as and '' crap
         

electricalan
select Store.storeName as 'Store', Store.address, Item.itemName as 'Name', item.Brand, Item.wsprice, 100*((saleItem.price - Item.wsprice)/item.wsprice) as 'Markup' from SaleItem, Item, Store where saleItem.product = item.code and saleItem.SIStore = Store.SID group by Store.storeName, Store.address, Item.itemName, item.Brand, Item.wsprice order by Markup desc;
that's what it is now
i would format it better but when i copy it into the sql prompt it doesn't like the newline chars
what's wrong with the ' marks RJarett ?
RJarett
www.google.com sqldeveloper
electricalan
oh but that's time consuming
andi have to leave in 30 mins
Junior
yello ;)
electricalan
hello yourself
KeiKurono
morning
mgolisch
omg
cofeineSunshine
what omg?
:)
mgolisch
shouldnt i get more than 5k IOPS out of a striped metalun with 45 disks?
i wonder what is the limiting factor here
:(
usn_work
.
Trengo
hi
KeiKurono
lo
mich3l_
o/
balek
hi when i try to create ocrmirror with ocrconfig i have this error : PROT-21: Invalid parameter on file ocrconfig.log i have : [ OCRCONF][5020]The input OCR device either is identical to the other device or cannot be opened and on file orcd.log i have : OCROSD][2724]utdvch:9:failed to open new OCR file/disk \Device\HarddiskVolume5 OCRRAW][2724]dev_replace: master could not verify the new disk (8) if anyone have any idea where i can search please thanks
usn_work
does metalink speak about it?
please copy and paste to pastebin your fill command and error message
your full
with prompts and all stuff
balek
usn_work : ok i do that now thanks
usn_work : i think i past full information : you can see on http://pastebin.com/xPe0RjY6 and i see on metalink the same error on : ID 1059663.1 very thanks
usn_work
are you sure that the way you specified your device does work on windows?
never did OCW on windows, so I've got no experience with tit
dsdel
should :)
it's the path to the harddisk volume direct without any partitions
checking
balek
usn_work: yes i use a tool to see the path of the symbol link
i use winOBJ to see the path and i found this \Device\HarddiskVolume5
usn_work
obviously the process can't see it with this path specification
dsdel
you aren't using vmware right?
balek
dsdel : i use vmware
usn_work
wuahahahaha
have a lot of fun
oracle clustering on vmware is PITA
balek
usn_work : it's the test platform the production platform is on physical computer
dsdel
balek: check the article from tom Oracle 10g RAC On Linux Using VMware Server
balek
i try to create a mirror on the test and if it work i make this on the production
dsdel
it's linux but perhaps there are some hints for vmware in general
balek: scsi.sharedhost setting for the vm?
er sharedBus
balek
i think the problem is not vmware no i think it's a problem configuration no ?
dsdel
it is vmware :D
cause vmware abstracts the physical harddisk layer with a virtual one
ocr is working directly on the hardware/harddisk layer
balek
i use this documentation to do that : http://www.oracle-base.com/articles/10g/OracleDB10gR2RACInstallationOnWindows2003UsingVMware.php
dsdel
less, I would assume the problem is vmware
balek
but actually i have a ocr and voting disk with this oracle rac on vmware and it work
dsdel
so, recheck your vmware settings of the vmx file
usn_work
and, in the note, the paths are specified with \\·\𬒢¬\ßøµ¬g'’nK
nøg \Ь’¢¬\ßøµ¬g'’nK
sh*t
and, in the note, the paths are specified with \\.\Device\Something\
dsdel
yes, with the other drive enumeration possiblity
dd -list should print them (last time i've seen them :D)
usn_work
I don't know anything about this windows stuff
just excluding possibilities
dsdel
dd for windows
usn_work: there are differen enumeration possibilities for harddrives - one from the 'windows sight' and one from 'hardware'
I think winobj is returning the windows side but oracle may use the hardware ones
balek
for information i use this : scsi1.virtualDev = "lsilogic" scsi1.sharedBus = "VIRTUAL"
dsdel
kk these should be correct :)
balek: get dd for windows, use dd -list and try the \\.\Device\Volume... thing
balek: your first path was also indirectly 'wrong'
i've re-checked and it should be in notiation of \\?\Device\HarddiskVolume5
alternativly the other one is \\.\Volume{DUID}\
where duid is the device unique id
which you should get through the device manager also
balek
dsdel : this path for your is wrong :\Device\HarddiskVolume5 ok i modify this by \\.\Volume5\
dsdel
\\?\Device\HarddiskVolume5
you need the \\? in front
usn_work
...
dsdel
usn_work: ? :)
balek
dsdel : i try this : ocrconfig -replace ocrmirror \\?\Device\HarddiskVolume5 i have the same error
usn_work : sorry if i am long
dsdel
k then try the other one :D
balek
i try the second i have the same error
RJarett
what are you trying to accomplish?
dsdel
RJarett: http://pastebin.com/xPe0RjY6 on windows running under vmware
RJarett
why would anyone run rac on windows?
balek
RJarett : a ocrmirror and i use windows 2008 64 bits and vmware
RJarett : it's not my choice
RJarett
BS
grow a set of balls
windows has some of the work disk performance and io scheduling of any OS. and, i bet within 6 months your raw devices get corrupted because windows goes and tries to initialize them or so something to change the mapping
balek
RJarett : my problem is i can't access the raw device to create the miror ocr i use ocrconfig to create this but i have the same error i try \\?\Device\HarddiskVolume5 and \\.\Volume5\ the same problem
RJarett
yeah, have fun. i wont touch rac on windows
dsdel
RJarett: luckily that stopped happening with windows 2003 :) (initalizing/mapping changes)
RJarett
dsdel: no it hasnt
ive seen many many cases of it in 2k8
dsdel
a partition/harddisk will never intialize else demanded
it will ask/prompt on opening the disk management
RJarett
ya hope
dsdel
and i've removed harddisks, put back 4 months again and they got the same id again
but, yes anything can happen anywhere
balek
ok i must find a solution of this and the solution is not migrate to linux the oracle rac :)
there are no more documentation to do that on windows :(
thanks for your help
RJarett
balek: you have win2k3 on this?
in windows you should initialize but not convert the disk, then make a logical partition but not format. and then use that partition
just make sure you select not to have a drive letter
balek
RJarett : ID 1059663.1 this on metalink ?
RJarett
i dunno im not on metalink
balek
ok sorry
when i create the logical partition it want to give me a drive i delete it
drive letter
RJarett
new partition > logical > size > "do not assign a drive letter" > "do not format" > finish
just checked and thats my flow
since you need to use \Device\Harddisk#\Partition1
balek
i just try this : \Device\Harddisk4\Partition1 i have the same error : PROT-21: Invalid parameter
RJarett
screenshot your disk management
balek
ok
dsdel
\ will always lead to an error doesn't it?
\ is filesystem notation
balek
RJarett : http://imagebin.ca/view/djj0Ax.html
i paste the disk manager you can see all harddisk and partition
dsdel : RJarett thanks for your help
dsdel
balek: does it work?
balek: if disk 5 is your disk for the mirror remove the drive letter
balek
dsdel : the disk is 4
i try to use the disk 4 to mirror ocr the disk5 is the partition who there are voting disk and ocr disk
dsdel : no it not work i don't know why but it not want
dsdel
balek: tried with which argument now?
switching oracle from an hp-ux to windows 2008
'the customer wanted to. hp-ux is to expensive' :D
TheBonsai
well... maybe pray a bit :) "God rot windows and all its ugly, clunky badly-designed horror"
nope
and yet people run oracle on it
:p
TheBonsai
hehe
balek
i just try this : ocrconfig -replace ocrmirror \Device\Harddisk4\Partition1
dsdel : i just try this : ocrconfig -replace ocrmirror \Device\Harddisk4\Partition1
sorry
dsdel : i just try this : ocrconfig -replace ocrmirror \Device\Harddisk4\Partition1 and ocrconfig -replace ocrmirror \\.\Device\Harddisk4\Partition1 but nothing work
RJarett
you could have reloaded the host to linux or solaris and been done by now.
dsdel
balek: it was \\?\Device\\Harddisk4\Partition1 or \\.\Volume{DUID}
er
it was \\?\Device\Harddisk4\Partition1 or \\.\Volume{DUID}
Luckys
'lo all
samble
http://www.dba-oracle.com/images/auth_pic_don_burleson_120_140.jpg
for inspiration in times of oracle-fueled frustration and exaspiration
ZaiS
search for his wife
samble
ZaiS
%)
samble
she trains tiny seeing eye horses for blind people
TheBonsai
i have a picture of burleson @office. a bit tuned..
Luckys
samble: don't they both look like siblings
samble
TheBonsai: @office?
Luckys
(Action) hates burleson BTW
« prev 1 2 next »