logs archiveIRC Archive / Freenode / #oracle / 2010 / April / 22 / 1
chuckh1958
If I run an EM agent on a host that has no other oracle production running on it, do I need to pay any licensing for the agent? IOW can I deploy agents anywhere like I can with sqlplus and the oracle clients.
I mean "no other oracle product"
bencc
how do I create a user that can create tables?
archangle25
#joomla
Junior
yello ;)
TheBonsai
y0
Junior
yello bonsai :)
deebo
how do i print the contents of a ref cursor?
i just want like first 100 rows from a cursor named 'xyz' via dbms_output.put_line
how do i limit the rows that 'pring my_cursor' prints?
electric1lan
hey can anyone help me with this question maybe
it's for a uni assignment
i have to wrote a bunch of select statements
http://pastebin.org/167051
that is my schema
i have to find all instances of two chains both having a store in the same suburb
so how do I select two different stores?
anyone here?
KeiKurono
morning
         

electric1lan
hey hey
ive been tryign to get someone to help me here
without much luck
xiaoshen
hi
:)
electric1lan
hello xiaoshen
xiaoshen
anybody using db2?
i hope i can find someone experienced in db2 here coz nobody active in #db2
electric1lan
nobody is active here either from the looks of things
xiaoshen
ic
electric1lan
xiaoshen: do u know much about oraclesql queries?
xiaoshen
i'm a newbie
but i try to help if ican
:)
i usually have a very nice firend here helping me in oracle ,
electric1lan
yeah
i found one of them yesterday
he wsa good
xiaoshen
"TheBonsai"?
electric1lan
xiaoshen:
http://pastebin.org/167051
that's my schema
Which chains have a store located in the same suburb (address)? List the names of the pairs, their common suburb and eliminate redundancies
that's my question
i need to select the two chain names obviously
phimic
hi all
i have a oracle two node rac 10.2.0.4 using the dbconsole
my problem is that the dbconsole only show one instance but both instances are running
here is a screenshot http://img263.imageshack.us/img263/9420/racx.png
and here http://img718.imageshack.us/img718/4561/rac2.png
i miss the 2nd instance VPX_VPX2
balek
hi i search a tool on oracle to format a partition on oraocfs but i don't find this tool if you can help me please . i want to formation this partition to create a second voting disk thanks
phimic
balek: are u using SLES or RHEL?
balek
phimic : i use sorry windows isee it's not the best solution :)
phimic
balek: i only found http://oss.oracle.com/projects/ocfs-tools/
balek
phimic : yes it's for linux system i search but i don't find for windows system :( thanks
phimic : i just found a tool for this OCFSFORMAT very thanks for your help
phimic : last question the best solution is to create a ocfs disk or raw disk for the voting disk please and i want to make the same for ocr disk thanks
phimic
balek: i use raw devices and ASM
also raw devices for voting and ocr
balek
phimic : the choice raw device for voting and ocr are better than ocfs device or there are not difference?
because actually i have voting disk and ocr disk on the same disk (ocfs partition) i want to make mirror ocr and voting disk
phimic
balek: i would not use ocfs2 on a productive rac
         

balek
i don't know if there are a best solution or it's only a choice to make a raw device or ocfs device
phimic : ok i think i move both disk on raw device thanks for your help
phimic: i just read more documentation all tell raw device is better than ocfs2 very thanks
phimic
balek: no problem
dsdel
if the databse in which the OEM repository resides not starting - there are no error messages from the OEM through smtp, right?
balek
hi anyone have already add an ocr device pelase because i try to add an ocr device by this command : ocrconfig -replace ocr \Device\HarddiskVolume7 i have this error : PROT-16: Internal Error thanks for your help ( i shutdown the oracle rac to do this manipulation)
ygip
Whn using the JAVA JDBC driver and a prepared statement is there any way i can just set a to_date('', '') when setting one of the parameters?
phimic
how can i activate flashback logging without restarting the whole rac database
balek
hi is it possible to make the first ocr on ocfs partition and the second on the raw device please thanks
npmap
hello
I'd like to use Oracle-XE along with ASP.net for an application. what would be the recommended .net provider?
dsdel
the oracle ones?
ygip
Can i execute a .sql file from command prompt with the sqlplus program?
In the parameters
phimic
someone using oracle enterprise manager with a oracle rac?
ygip
without having to open the app
Nevermind i figured it out, was missing a @
npmap
dsdel: is the oraclexeclient enough? that's what I was asking, basically. does this connector have the same APIs like http://www.oracle.com/technology/software/tech/dotnet/utilsoft.html ?
phimic
usn_work: hi
dsdel
npmap: http://www.oracle.com/technology/tech/dotnet/index.html
npmap: not sure if it is distributed with oracle xe
npmap: C:\oraclexe\app\oracle\product\10.2.0\server\ODP.NET check that path of your installation
teite
i guess i need to learn more about hash join and sort merge join
usn_work
hi phimic
phimic
usn_work: do you use the enterprise management console?
usn_work
database control or grid control?
dsdel
today sent a licensing offer for database control and all management packs from 10g r2 to a customer using 2 cpu licenses
for alle 3 packs ~ 23000 k eur
listprice
very heavy hehe
phimic
usn_work: database control
npmap
dsdel: thank you, it seems that the oracle xe client is pretty much the same - it has the same connector - just for future reference in case someone else asks what I asked
dsdel
:)
phimic
usn_work: since i updated to 10.2.0.4 i only see 1 of my 2 rac instances in the database control
balek
hi anyone have already add an ocr device please because i try to add an ocr device by this command : ocrconfig -replace ocr \Device\HarddiskVolume7 i have this error : PROT-16: Internal Error thanks for your help ( i shutdown the oracle rac to do this manipulation)
ocrconfig -replace ocrmirror \Device\HarddiskVolume5 i have The input OCR device either is identical to the other device or cannot be opened
i don't know why i can't create an ocr mirror
thanks
usn_work
phimic, use emca to recreate the service and the repository
the commanfd has special RAC options
dsdel
balek: PROT-16: Internal Error thanks for your help ( i shutdown the oracle rac to do this manipulation)
?
if it is already shutted down I would fill a SR
balek
dsdel : sorry i don't shutdown the rac when i do this manipulation
i have an ocfs partition with voting and ocr disk i try now to make a mirror of ocr but i have there problems
dsdel
'internal error' doesn't sound very good
balek
i have this : PROT-21: Invalid parameter on the log file : The input OCR device either is identical to the other device or cannot be opened
i see there are a patch for this number: 9233832 i install this patch but i have the same error
dsdel
sorry I'm not very inside ocr :/
balek
dsdel: no problem thanks
neilkod
is there any way to estimate how long an online reorg will take?
RJarett
hey dude
neilkod
hey
long time
i never remeber to log on to irc
Davedan
I'm a bit confused about env variables
I'm using oracle enterprise linux 5
and installing xe and instant client
what should ORACLE_HOME and LD_LIBRARY_PATH set to?
RJarett
where you installed it
and LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
Davedan
RJarett: xe is under /home/oracle/app/oracle/product/11.2.0/dbhome_1
RJarett
ok then
try that as your ORACLE_HOME
Davedan
basic client, sqlplus and devel under /usr/lib/oracle...
RJarett: but both sqlplus and xe require ORACLE_HOME
RJarett
if you have XE installed why use the instant client?
Davedan
RJarett: I need sqlplus for django
RJarett
XE has all that
Davedan
it has sqlplus in the xe server rpm?
RJarett
yes
Davedan
I'll try it. thanks
plantain
select * from *; doesn't seem to work, is there an alternative?
RJarett
wtf is that?
are you a mysql user or something?
you really need to learn sql, because that should work in no databases
plantain
no, a student with a ridiculous assignment
RJarett
reading an intro to sql doc for 5 minutes is rediculous?
you cant * a table name
plantain
I'm trying to get _everything_
I have to find every string in a database of length 20 where the third letter is e
RJarett
dont
are you sure you just dont want to query all YOUR tables?>
did the teacher teach you about permissions?
plantain
hmm, you mean user_tables?
ahh yes, that works
hmm, but how can I use a WHERE clause on a wildcard, i.e. WHERE * LIKE '__e%'?
RJarett
read the docs
plantain
I've read the docs, quite thoroughly, but I can't find anything relevant to crazy things like this
RJarett
actually i know at least 4 ways to pull this off
plus what about views and materialized views?
those can hold string data too
what did the instructor say about that?
this assignment is more about making you think how to do it than making you figure out a way to do it
since if you try to figure out the usecases and how to do it the way to do it becomes automatic
its a multipart lesson
#1 the STUPID part of querying every table and column of the type that holds this type of data
next the reduction
if i EVER had a developer query all tables and all columns for 1 bit of data id try to get them fired
plus what about E vs e?
plantain
it's not specified what to do, so I'm assuming just lowercase 'e'
RJarett
if you query for all columns, and automatically eliminate any columns that arent char/varchar
and then eliminate columns varchar2, char 19char and smaller
and then what abotu clobs?
well you gather all the tables and columns
plantain
clobs...?
RJarett
character large objects
objects which can handle data up to multi GB in size
plantain
we haven't covered anything like that and there's nothing like that in the database
we have the data, it's all char(n)'s
RJarett
really?
instructor is a diposh*to
plantain
yes, I'm very unhappy with how the course is taught tbh
RJarett
everyone write your congress people to vote against HR 5034 http://thomas.loc.gov/cgi-bin/query/z?c111:H.R.5034:
plantain
I've answered all the other questions, but I can't figure out this one
RJarett
im unhappy with the students
not the teach
you totally fail at critical thinking and finding things on your own
so what would you do next now that ive told you 1/2 the answer?
2 parts left
lol
he is such a pansy ass
hope he fails his class
Davedan
RJarett: what the xe client gives me that the xe server doesn't?
RJarett
Client software to be installed on client systems for remotely accessing Oracle Database 10g Express Edition. You do not need to install the client onto the same computer as Oracle Database 10g Express Edition.
right from the download page
Davedan
because this guy installs both: elif [ -e /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh ];
sorry I meant http://www.davidpashley.com/articles/oracle-install.html
he is probably doing it wrong
RJarett
plus he is on debian
if you are on oracle enterprise linux, you can just install the rpm and be done
Davedan
will the rpm set the env variables?
I don't think the rpm creates the oracle user
I'm on oracle enterprise linux
RJarett
is it that freakin hard for you to type 2-3 lines in your bash profile?
pb30
newbie question: can cache related headers be overriden by oracle webcache?
eoliva
I'm using Pro*C to build a program that makes a select and an update every half second in Oracle, this works fine, but when I reach some time running the program, I get an error, from nothing...just saing that "ORA-01013: user requested cancel of current operation"...I cant debug it with gdb, cause actually my program didnt fail and didnt issued a SEGFAULT...so I think I should see in the Oracle's part of story...could someone help
me to achieve this?? How can I monitor a session, can I see what went wrong from Oracle???
« prev 1 2 next »