logs archiveIRC Archive / Freenode / #oracle / 2010 / March / 18 / 1
converge
what can i use to model a ERM ? using linux..
usn_work
good morning,
it's on AIX 6.1, we are using iSCSI on a NetApp filer for the ASm disks
if the filer is disconnected, the disks have huge timeouts until IO errors are displayed. How can I configure that?
As a result, the ASM disk-offlinic "process" takes ages, at least 45 minutes at the moment
hali
usn_work: what does lsattr -El on the disk say about timeouts?
usn_work
# ls -l /dev/rhdisk14
crw------- 1 oracle oinstall 13, 17 Mar 17 17:16 /dev/rhdisk14
# lsattr -El /dev/hdisk14
lsattr: 0514-519 The following device was not found in the customized
device configuration database:
/dev/hdisk14
hali
just hdisk14
usn_work
same for rhdisk
(it was hdisk)
hah
the /dev was too much
# lsattr -El hdisk14 | grep -i time
dist_tw_width 50 Distributed Error Sample Time True
max_retry_delay 60 Maximum Quiesce Time True
reassign_to 120 REASSIGN time out value True
rw_timeout 30 READ/WRITE time out value True
start_timeout 60 START unit time out value True
hali
seems like rw_timeout = 30 is minimum setting, nothing lower allowed :(
vmnew
hey, used dd to copy entire drive (with oracle 10g dbf files and everything included), now I'm getting inconsistancy errors and such. I want to overwrite it all with a clean export file I got. Will it import only the data/structure itself or also the control files and such? how do I verify that?
balek
hi i have a question please i have a rac oracle cluster 10.2 i want to shutdown one server but i have a session actif is it possible to swtich there session on the server one to the second server because i don't want to kill there sessions thanks for your help
usn_work
no
if the session uses TAF, it can continue its reading operations, but transactions will be rolled back
         

balek
usn_work : ok thanks for this information
sytse
select r from (select r from (select level r from dual connect by rownum <= 10000000) order by dbms_random.random) where rownum <= 5
database abuse 101 :-)
vmnew
copied dbf files from production server to a backup server, Oracle doesnt want to come online, says dbf files are bad. recovered some but others cannot be recoverd, still, those dbf files are exactly the same byte size..
MaL0
check with md5sum
vmnew the md5 is the same on both sides ?
vmnew
MaL0: didnt check, brb
MaL0
ok
Reign1
hi, how do i check what components are installed? i dont mean this one "select comp_name,status,version from dba_registry;", i mean when i install oracle and select custom installation, i select components as part of oracle installation, i need that exactl list as need to make identical install
vmnew
MaL0: md5 differ :(
brb
MaL0
vmnew how did you transfered the data ?
hali
ascii ftp? :)
Reign1
how do i check what components are installed? i dont mean this one "select comp_name,status,version from dba_registry;", i mean when i install oracle and select custom installation, i select components as part of oracle installation, i need that exactl list as need to make identical install
usn_work
they are in xml format in your oraInventory directory IIRC
monk12
hey all, curious... Does anyone have issues with selinux with oracle?
RJarett
well considering they request you to disable it or set it to permissive... i would say yes.
monk12
I had a php oci module that assume the oracle-instantclient to connect. and i got errors on web server about the dynamic link library not being able to load/execute. so I tried allow_execstack=on as some forums suggested .. but that wasnt enough i think. had to use setenforce=0 (permissive as you said)
so should it always be off then on that server? the linux guys didnt seem to like turning it off completely.
RJarett
tail -f /var/log/audit/audit.log | tee oracle.log
then do what you need
then
audit2allow -M oracle < oracle.log
nmuntz
hi all, i have a very noob question: is there any way for this query to return the datatype of each column? SELECT column_name, comments FROM ALL_COL_COMMENTS WHERE table_name; i know ALL_COL_COMMENTS doesnt return type, so what should i use instead?
RJarett
semodule -i oracle.pp
but id say just turn it off
nmuntz: just join the query on dba_tab_cols and link the table_name and the col_name
monk12
hah k, ill do that for now ... if i do 'setenforce 0', it gets turned back on on restart... how can it be set permanently off?
RJarett
vi /etc/sysconfig/selinux
         

monk12
ahhh, k ill take a look. guess its maybe a service i can stop?
gotcha, i turn permissive there.
RJarett: cool, it worked. So why would you recommend turning it off completely? Is it a hassle with side issues after running those commands you told me to check out? is that what you personally do, or def not on a prod server.
Necrosporus
Does downloading latest oracle require registration or only accept of license agreement?
DiscordianUK
As far as I'm aware as always download is free for non-commercial use
usn_work
Its free, but you need to register
Necrosporus
I don't like registring somewhere without a reson
DiscordianUK
Then don't use Oracle
usn_work
Mh, you are downloading expensive software, that's the only reason
Necrosporus
Software can't be expensive
RJarett
its not free for noncommercial use...
Necrosporus
Isn't linux kernel or something more comlex then oracle database?
I would prefer something libre/opensource for commercial use
usn_work
nots, but people writing the kernel decided to work without being paid for, the oracle developers did not
the use postgeSQL
then
postgreSQL
gnah
Necrosporus
> people writing the kernel decided to work without being paid for < not true, because Linus, i.e. is a millionare
usn_work
many developers are working for companies, that are allowing them to work on the kernel or other OSS. But the software itself is not paid
DiscordianUK
He is?
Maybe someone should tell Linus
I believe he still has a day job
usn_work
(Action) thinks that Necrosporus is just annoyed that he has to give away an email address for stealing software ;)
DiscordianUK
heh
Necrosporus
usn_work, software is immaterial and can't be stolen, unless you remove it from original location
DiscordianUK
Software is also Intellectual Property
hali
linus was far from a millionare when he started writing the kernel, took a good 10 years before he saw any money... plus he never asked for it
plus one of the main reasons for registering is so that oracle can make sure you have ticked the non-export agreement
no oracle for iraq!
Necrosporus
DiscordianUK, intellectual property is a lie: http://www.gnu.org/philosophy/not-ipr.html
usn_work
If you are downloading via edelivery, registration guarantees for a sales call within two days time ;)
DiscordianUK
Mustn't use it for Nuclear Arms either
Necrosporus
hali, probably any iraq user can use torrents or something
So stupid restrictions
DiscordianUK
Oracle is not licensed under the GPL
usn_work
Write your own RDBMS, or use PostgreSQL
hali
Necrosporus: but that would be illegal
Necrosporus
Is Oracle forced to require such registration?
By law, I mean
DiscordianUK
They require it
usn_work
It's the right of an author
DiscordianUK
why is this noise continuing?
usn_work
because we feed it
DiscordianUK
(Action) will say no more
usn_work
<°)))><
Necrosporus
DiscordianUK> Oracle is not licensed under the GPL // article I linked is not about gpl, but about false term "intellectual property", proving why it is false
DiscordianUK
(Action) ignores the RMS propaganda that has been misunderstood
Necrosporus
Software is not intellectual property, but it is subject of some restrictive laws, yes
vmnew
I've deleted all database files in my backup. I cannot shutdown my production server, how can I scp my dbf files from my production to my backup server without corrupting them?
TheBonsai
alter XXXX begin backup
(db/ts)
vmnew
TheBonsai: I have yesterday's .dmp file, could I just import that?
TheBonsai
what now, database files or database content (exports)?
vmnew
oh, hmm.. dbf files also contain .exp data, doesnt it?
Necrosporus
Anyway, I find oracle terms too restrictive and would not download it unless it would changed
TheBonsai
as database file, yes
of course oracle is not GPL
if you want a GPL database, use MySQL
other FOSS db include Postgres
vmnew
TheBonsai: cool, now I dont have any dbf files. Got my .exp export and my dbf files on another machine (production).
TheBonsai: got my licences :)
sytse
why oh why
TheBonsai
good question :/
sytse
doesn't oracle forms pl/sql support max keep(dense_rank) :S
(oracle forms record groups support it just fine, as does oracle database PL/SQL
)
vmnew
sytse: why what? I want to make a backup of my db. trying to make it so.
TheBonsai
rman doesn't work?
Necrosporus
TheBonsai, thanks, but I suppose, Oracle DB should became at least semi-free sofltware (source is freely available for any non-commercial use)
TheBonsai
and why?
usn_work
would be nice
vmnew
TheBonsai: it does, will try it.
dddh
Necrosporus ;D
Necrosporus
It would not broke source of oracle profit, but would allow people to examine source and adapt it better
DiscordianUK
(Action) is not listening la la la la
Trengo
its their source, they can do what they want with it
stede
hey folks ... i need a if-condition inside a trigger which checks a data-field for a specific string, i tried: IF INSTR( :NEW.colname ,'mystring') > 0 THEN ... but it won't do the job ... whats wrong?
TheBonsai
i doubt it would be nice. regarding that SQL server still is a waste of ressources, and will be fine after that (WITHOUT redmond respecting the GPL)
plus what Trengo said, of course. it's their product, they make the rules
Trengo
licenses are very expensive yes - perpetual ones that is
one year licenses are much cheaper than other commercial cr4p
as for enhancing it, why dont people help enhance pgsql instead? that one really does need help - and its FOSS
usn_work
but all PG arguments here are ignored you know ;)
Necrosporus
Why does people use Oracle if Postgre isn't worse?
DiscordianUK
Oracle is a far superior Database
Necrosporus
AFAIK, PG is more feauture-full then oracle, but I'm not completely sure
Trengo
troll
TheBonsai
heh
usn_work
hali, mator, would you please...? ;)
Necrosporus
Don't know, I haven't tested it
xzilla
Necrosporus: you should ask in #postgres, I am sure they can explain why pg r0ckerz oracle
vmnew
I have a working production server and cannot shut it down at the moment, trying to copy (scp) my control file but get different md5 :( file size is the same. What can I do?
xzilla
vmnew: pull the plug?
vmnew
xzilla: no
xzilla
that will shut it down
usn_work
RMAN it
rman duplicate database
Is it in archivelog mode?
vmnew
usn_work: yes
Necrosporus
vmnew, maybe oracle support replicating on fly?
usn_work
vmnew, try RMAN, it's perfect for you
xzilla
RMAN is the answer to so many problems
vmnew
usn_work: I am. RMAN tutorial saying I need to copy the control file..
usn_work
backup it
RMAN> backup current controlfile format 'path/file';
backup database
backup archivelogs
vmnew
nice, 1 sec. we RMAN everyday... maybe I got it all on my storage...
usn_work
copy the backup pieces to the new box, startup nomount a nonexistent DB with a SP file copy from production
there are lots of papers describing RMAN duplicate
search for them
stede
solved
vmnew
usn_work: thanks, brb
stede
mhm ... grrr
dont work
still:
hey folks ... i need a if-condition inside a trigger which checks a data-field for a specific string, i tried: IF INSTR( :NEW.colname ,'mystring') > 0 THEN ... but it won't do the job ... whats wrong?
tried it with a CASE block, but then nothing! will be inserted o-O
any idea?
vmnew
usn_work: got all kinds of bk_10464*,arc22_*,ctl_sp_c* files - is this RMAN? how do I use it?
usn_work
please read a good howto on rman duplicate
you need to learn it, and I've got work to do
vmnew
yeah.. will do k, thanks
stede
my problem as a paste: http://privatepaste.com/512b03242f
Necrosporus
Why did Oracle rebranded Sun Solaris to Oracle Solaris? I suppose, it's wrong, because Sun Solaris sounds much better
They now have the brand or Sun, so probably they can use it
* of
usn_work
<°)))><
Necrosporus
usn_work, fish? What does this fish mean?
Also, Sun Virtualbox sounds better
avaia
it represents the struggle of constantly fighting to swim upstream, of course
usn_work
"don't feed the troll"
Necrosporus
Why do you call it troll? I'm really wonder
And suppose, they can do opposite, rename Oracle DB to something like "Oracle of Sun"
or Solar Oracle
stede
how stupid is that? grrrr sux
still don't work ... can it be that it's impossible to compare for a specific string ?
dddh
Necrosporus: you think bdb should have been rebranded as odb?
Necrosporus
Do you mean Berkley DB? No
dddh
Necrosporus: yes
stede
nowbody knows how i can check a col for a given string in a before insert trigger? :-/
« prev 1 2 next »