logs archiveIRC Archive / Freenode / #oracle / 2010 / February / 16 / 1
sileni
hey guys in a UML representation of a database, i have two classes and in the child class there is a primary key from the parent class. mainly the customerID from the Customer class
in UML do i show these references?
placydo
hello thar! I have Oracle database which is bigger than 20gb. So my application that are using it are getting slower and slower. I would like to make it smaller (ie. move records older than xx to separeted file or something) - Any adivices?
usn_work
Hi, dos somebody know, if NetApp's SnapDrive is supported with Oracle ASM?
hali, maybe? ;)
hali
no idea, it integrates with rman
so probably
sorry snapdrive, don't know and wouldn't think so
i was thinking of snapmanager for oracle
what do you want it to do more specificly?
it will obviously work to create luns that you can use in asm
usn_work
Mh. A customer wants to use ext3 "to make sure that SnapDrive works". I consider journaling File Systems for a databas as a PITA, and I want to us Orale Clustrware there
hali
well a lun is a lun
if ext3 works asm will work in that basic sense
usn_work
But as far as I understand, is SnapDrive for consistent snapshots, quiescing the LUNs for that. So I was wondering if that may work with/for ASM
hali
do you have a now login?
usn_work
A now login?
         

hali
http://communities.netapp.com/thread/6309 shows people using
netapps online community thingy for support etc
not sure if you need one for the forums or not
usn_work
nots, I've seen this thread before. BUT I CAN'T SEE ANY OFFICIAL REQUIREMNT/denial list for ASM
oops, caps broken
sorry
hali
i'd open a case with netapp
usn_work
okay
hali
are you using RAC?
or anything else needing voting disk and ocr?
stick that on NFS
pwns
usn_work
okay
sounds good
for a fallback strategy: ext3 for th customers peace, and NFS for voting/ocr
hali
i can't say i've used snapdrive much as everything works pretty well without it
usn_work
;)
don't worry, you've helped more than you think. :)
thank you
hali
i guess it does make people feel slightly cosier as you don't have the oracle user ssh'ing to the netapp
which i have, to snapshot stuff
i guy i know wrote half of snapshot in perl using the netapp http api
snapdrive*
usn_work
hehe
.
dsdel
.
usn_work
silly dsdel ;)
crono-
When i use this connection prefix can i add a service name? user:xx@\\server.nki.no
With the instant client, theres no server folder in the oracle installation directory, and thus no /server/admin/tnsnames.ora path... I went ahead and created it but i guess that might be wrong
The only populated directory is this one, and it has no .ora files lying around: /usr/lib/oracle/xe/app/oracle/product/10.2.0/client
usn_work
maybe instant client is not what you need
crono-
well i found the syntax now... docs got it wrong aswell for some reason; its user:pw@\\server\instance (according to the docs its the other slash..)
usn_work
you did not tell us what kind of connection you try - odbc, jdbc, oci, sqlplus ...
crono-
sorry, oci8
dsdel
usn_work: aren't they the same format for every provider? :D
Rudemeister
usn_work: aren't they the same format for every provider? :D
usn_work
...
         

stede
hi
Rudemeister
usn_work: ;)
stede: hi
stede
how i can give a pl/sql function a parameter with N values?
or, how i can use a varchar parameter inside the function, e.g. to use it in a select-query?!
or if i have a complete select-statement in e.g. foo VARCHAR .. how can i execute it?
mac-
hi there
how can I change working directory ?
in sqlplus ?
hali
!cd
mac-
great
and it is possible to i.e. run ViM and edit file, then close and back to sqlplus ?
hali
export EDITOR=vim
start sqlplus
in sqlplus use ed
ed starts of a vim session with your buffer
mac-
buffer ?
hali
your current sql query in buffer
list to list it
get file.sql to load a file in to thebuffer
mac-
SP2-0734: unknown command beginning "!cd c:\mac..." - rest of line ignored.
hali
save to save out
hm, no idea on windows :)
mac-
on which OS are you working ?
hali
Linux
95% of everyone in here are
mac-
I wish too, but my company loves windows
Rudemeister
hi
moarning
!aq hali> list to list it
hali
yes
idletask
Hello
I have just noticed that you can make tables read only with 11g
Now that's cool
usn_work
but there's no write-only mode for Oracle
idletask
Well, using dbvault and a command rule, yes, you can do that
But that's really far fetched
No, in fact, you don't even need a command rule
You can grant insert on thetable to auser; if you're a realm owner (but this requires that the owner of the table is not the one which will write in it)
usn_work
http://en.wikipedia.org/wiki/Write-only_memory
idletask
Argh, alter table read only/read write is not considered a DDL command :/
Ah, OK
SYS is special
Good to know
stede
i want to select one col with N rows inside a function and then work in a (for?) loop with each row ... which declaration i have to use for the variable i want do select into?
cursor, table .. i dont get that
idletask
Declare a cursor
cursor mycursor is select foo from bar;
Then in the for loop, reference foo as mycursor.foo
usn_work
for can do this implicitely
Look at the example in http://www.usn-it.de/index.php/2009/03/30/oracle-convert-a-partitioned-table-into-an-unpartitioned-one/
should do for simple cases
hali
any suggestions of backup solutions that use encrypted tapes?
or encrypt rman in some way
usn_work
secure backup by oracle :P
hali
sort of sucks doesn't it :)
usn_work
but I'd choose hardware encryption due to offloading. I don't like CPU eaters on my DBs
hali
im using netbackup now but the media server encryption option is about 10k
stede
usn_work: assume X like i (as in most other for-loops?)
hali
i never use local tapes or anything on oracle boxes
usn_work
stede, X is my iterator here, yes
but I must confess, I did never think about its data type ;)
stede
usn_work: but i don't get how i can work with the result from the select i used on top on the for-loop
idletask
stede: I found http://plsql-tutorial.com/plsql-cursors.htm to be a good guide
usn_work
if the select delivers columns a, b and c, just refer to X.a, X.b and X.c in the loop
idletask
stede
usn_work: it returns ONE columns lets say A with rows 1 to N
ahh
ok
get it
rows are the loop ;)
usn_work
hehe, yes
it's made for working through a table
or result set ;)
stede
i'll try this ... after a cup of coffee :D
usn_work
good idea
stede
usn_work: X.a => 'a' is e.g. 'uname' in your example !?
whatever .. coffee! -> this dont work: FOR X in (SELECT DISTINCT box_id FROM rfm_meas WHERE acqtime >= ts AND acqtime < te ORDER BY acqtime) (compiling error)
babo1
i've created a database babo but i can't connect to it from sqlplus
connect babo as SYS
connect babo as sysoper
password: mypass
or something to that effect ...
why can't i connect to my database ?
anyone got any ideas ?
Rudemeister
L<
usn_work
M>
chuckh1958
Anyone here running Oracle on 64 bit RHEL? I've heard discussions in the past that 64 bit linux is not stable. Is that true? Wondering what people's experience has been with Oracle on RHEL 64 bit.
Rudemeister
64b<
idletask
chuckh1958: excellent as far as I'm concerned
hali
never had any problems with recent version of 64bit rhel
bit specific that is
linux is still linux
idletask
chuckh1958: not a single crash
In three years, Oracle has crashed more often (twice) thant the kernel (0 times)
chuckh1958
Thanks. I'm wondering if those previous discussions had to do with desktop apps on 64 bit linux.
usn_work
all by databases run on 64bit, partially AIX, partially Linux of all supported colours. I'd never go back to 32bit
stede
usn_work: the for-loop line brings up ORA-01791 if i try to use the function
usn_work
why don#t you try something simple first?
hali
chuckh1958: yes, the flash player plugin may not work ;)
chuckh1958
I hate flash. Wish they'd just do away with all that crap. More often then not it gets in the way of working with a web page. Unfortunately support.oracle.com requires it now. :(
stede
usn_work: i guess the select don't return anything .. i will check that with output ..
mator
hali
chuckh1958: htmlsupport.oracle.com
using oracle on anything 32-bit these days would be a massive waste of resource, except for very basic dev/test of course
chuckh1958
There's stuff not available on the html site.
hali: There's stuff not available on the html site.
babo1
i've created a database babo but i can't connect to it from sqlplus
connect babo as sysoper
usn_work
why don't you try sqlplus / as sysdba first?
idletask
babo1: did you read at least the basic admin guide? It doesn't look like it
usn_work
heh
babo1
idletask: the docs aren't working at the moment
at least not for me their not
idletask
The docs are in the install zips
babo1
i read the part about connecting to the database ...
crono-
i guess i really dont understand oracle + TNS
babo1
usn_work, that doesn't work either ...
usn_work
I think the web can fix this better than we can do, time is money ;)
crono-
when i connect to "febmaster/pw@febhoest" with sqlplus, it tries to lookup "febhoest.searchdomain.tld" because thats the default domain.. right, but i thought the @ part was the TNS name, and not a DNS name?
usn_work
it is
but tns names can have domains too
keywords: tnsnames.ora, sqlnet.ora
chuckh1958
hali: That URL doesnt' work. Are you sure its correct? Seems that they've removed the html site link from support.oracle.com too.
hali
https://supporthtml.oracle.com/
crono-
hmm whats ONAMES (in directory lookup)
idletask
crono-: if you don't use OID, don't bother
crono-: the most simple sqlnet.ora you can have is NAMES.DIRECTORY_PATH= (TNSNAMES)
crono-
yeah
im cutting it down to that now, thanks
idletask
In this case, you need a tnsnames.ora too
crono-
this environment is only meant to access a single instance
idletask
crono-: I advise you set a TNS_ADMIN environment variable and put sqlnet.ora and tnsnames.ora in there
It's a much better place for them than $OH/network/admin (but ymmv)
crono-
yes i did that and some other environment fixing so things are easier to get to
i suppose i can i set a default host and sid in the environment aswel?
idletask
Hmm, I don't know if ORACLE_SID only refers to a local SID or to a TNS name
hali
local SID
TWO_TASK is for TNS i think
idletask
What a bizarre name
usn_work
what a cool feature
NHB
crono-
http://dpaste.com/159937/ <- does that look right? its from tnsnames.ora
i'm guessing this means tnsname febhoest is set to the information there (host, port, service_name).. however is sid/service_name the same or different aspects?
with juser a username sqlplus sais the service name is incorrectly specified.. so i guess i'm still missing something in there
if you look at this: http://dpaste.com/159948/ doesnt it become any more obvious what im doing wrong?
« prev 1 2 next »