logs archiveIRC Archive / Freenode / #oracle / 2009 / December / 15 / 1
bijoo
Hi, anyone know how to prevent WebLogic 10.3 from hitting the dirty cache in $base_domain/servers/AdminServer/tmp? Thanks in advance.
Other than routine server restarts and clearing out the cache and tmp folders, that is.
TomJ-
Why cant I use ORDER_BY in one half of a UNION ALL query?
*order by
Oh, it was a local moron error
no it wasnt
Refefer
I've got a quandry for those who know the ins and outs of oracle: I would like to set up a summary table that contains an up-to-date last modified for other tables. I've tried many different solutions without success and am looking for fresh ideas
dgs_
hi. not sure if this is the right place for sql/plql questions, but . . .
can anyone tell me why I cant get regexp_like(email_subject, '((Policy)|(Client))([[:graph:]]*)[[:digit:]]+', 'i') to match => 'Client Test 1234'
without the test word in the middle, i can get it to match, by leaving out the [[:graph:]] bit, but i need to cater for there being random text in the middle...
argh, was print i needed, not graph
sorted =)
paissad-hp
hi all
i did this --> CREATE VIEW DQNMPN AS SELECT r.dragon, n.produit FROM REPAS r, NOURRITURE n MINUS SELECT dragon,produit FROM REPAS;
i got this error ERROR at line 1:
ORA-01031: insufficient privileges
i went here http://www.orafaq.com/forum/t/72902/0/
i did --> connect sys@IC (IC is my database)
i entered the password correctly, but ..
SQL> grant select on nourriture to paissad;
grant select on nourriture to paissad
*
ERROR at line 1:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
how can i solve that :s
sytse
paissad-hp: hmm, you're sure that you're logged in as sys?
paissad-hp: btw, I'd think the problem wouldn't be that you can't select from nourriture, as nourriture is owned by paissad (which also means, that as sys, you need to refer to nourriture with paissad.nourriture)
paissad-hp: but that the problem would be create view privileges
paissad-hp
sytse, ok, i think that IC belongs to paissad
sytse
I don't think a database can 'belong' to a user..
you do need to be aware of that every user has his own namespace, so if you create a table as paissad, you need to refer to it by paissad.tblname if you're logged in as another user (including sys)
grant create view to paissad; <-- but, have you run that?
TheBonsai
sytse: well, strictly spoken it can. SYS :)
paissad-hp: connect as SYSTEM and GRANT the stuff
         

sytse
sys just has lots of privileges, it doesn't technically -own- everything
TheBonsai
that's wrong
sytse
ok
TheBonsai
SYS is the owner of the data dictionary
sytse
heh, I forgot that ;-)
paissad-hp
TheBonsai, i do connect system@IC ?
TheBonsai
yea
paissad-hp
TheBonsai, but when i do that, and the enter the password, ... i cannot grant for my tables
SQL> desc repas;
ERROR:
ORA-04043: object repas does not exist
sytse
paissad.repas
paissad-hp
ohhhhh
TheBonsai
you know what a "schema" is?
sytse
btw, I think all you need is to grant 'create view' to paissad
paissad-hp
TheBonsai, actually, i'm new to oracle ..
don't really know what's a schema
TheBonsai
the namespace of objects belonging to a specific user
what did you do before? mysql?
in mysql, the closest to a schema is a "database" IMHO
paissad-hp
TheBonsai, yes mysql
TheBonsai
(that's why they have an alias CREATE SCHEMA for their CREATE DATABASE)
paissad-hp
ok
http://www.techonthenet.com/oracle/grant_revoke.php
i don't see how to grant view privileges
sytse
08:26:16 < sytse> grant create view to paissad; <-- but, have you run that?
there you go, paissad-hp :P
http://msdn.microsoft.com/en-us/library/ms152547.aspx <-- btw, curiously, even microsoft has documentation about how to do that in oracle ;-)
paissad-hp
sytse, ok thanks
TheBonsai
<paissad-hp> i don't see how to grant view privileges
maybe because the very first line of that page says "Grant Privileges on Tables"...?
         

paissad-hp
lol, of course :D
got it
btw, i would like to know if there's a sort of phpmyadmin for oracle
i installed tora on my system, but i just see mysql
or how do you manage your databases if you don't use the console ?
DiscordianUK
tora should see Oracle
phimic
tora is cool but for ubuntu it have to be compiled manually
paissad-hp
phimic, i installed on debian and buntu, but on both system, when i run it i just see mysql
where it's noticed 'connection provider'
phimic
paissad-hp: hold on
Xgc
paissad-hp: It's usually up to you to provide the connection details.
paissad-hp
Xgc, oh ok
phimic, i hold on
phimic
paissad-hp
phimic, ok thanks
GaMo
help the beginner plz
Serge_HID
Hi, volks! :) My question is about RAC. I read that sometimes it can even decrease performance of a application. They say it can happen if your application is not appropriate for RAC. I would like to ask what criterias I should use to determine if my application fits for it?
hali
huge amounts of exclusive locking is usually a warning signals
signal
both in the app and db side
we had an app that used ejbs with heavy locking and odd isoloation levels.. caused it to run slow even though there wasn't any load on either app or db boxes
TheBonsai
in general, a sane OLTP app should scale well
Serge_HID
ok, thanks, now I'll try to understand if my application is a sane OLTP :)
TheBonsai
hehe
GaMo-0
are the oracle official study materials enough for a beginner to start with?
Serge_HID
GaMo-0, for example, http://www.oracle.com/pls/db102/homepage
In brief, it is a integrating application. That is, different threads get data from different sources in different formats and publicate (insert, update, delete) this data concurrently (doing some converting to the internal format). Users just search for publicated information. Could it be a good candidate for using RAC?
GaMo-0
is it enough or i need something else?
Serge_HID
GaMo-0, for a beginner I think it is enough.
GaMo-0
my last question
is it enough 4 the membership exam?
Serge_HID
I don't know :)
usn_work
good morning
Serge_HID
usn_work, Hi
usn_work
is there a way to shrink a LOB segemnt in 9i, except the way hali described on his blog?
http://halisway.blogspot.com/2007/06/reclaiming-lob-space-in-oracle.html
I'm afraid of the time the comments are claiming
and of the space
GaMo-0
thx Serge_HID
eueu
Hello! Any way to easily escape quotes in a variable? TRANSLATE(var, '''', '''''') does not work.
Serge_HID
"translate function replaces a sequence of characters in a string with another set of characters. However, it replaces a single character at a time. For example, it will replace the 1st character in the string_to_replace with the 1st character in the replacement_string. Then it will replace the 2nd character in the string_to_replace with the 2nd character in the replacement_string, and so on." (http://www.techonthenet.com/oracle/functions/translate.php
Franek_Kimono
hi!
how can i run Enterprise Manager?
i've started Oracle with `startup open`, but the web console isn't accessible
how should i run it? :]
djeday
emctl status dbconsole
Franek_Kimono
[Oracle Enterprise Manager 11g is not running.
:/
djeday
http://tinyurl.com/ycvfv6z
ps: emctl start dbconsole
Franek_Kimono
djeday: big thanks
i've got it myself, but without you i'd never thought about emctl
(yes, im a real newbie to oracle)
cmug
usn_work, thanks for html metalink :-)
eueu
Serge_HID, I have used the replace() function. Thank you :)
usn_work
;)
mator
4/sc
phimic
usn_work: hi
usn_work
hi phimic
phimic
usn_work: i need you help :(
usn_work
what's your billig address? ;)
billing
phimic
usn_work: :)
usn_work
I won't promise you help without knowing the question
phimic
ok i start from the beginning, i setup a two node rac 10.2.0.3 with RDM and raw partitions using asm
hali
but you will promise to charge a large amount for project management time
phimic
all works fine until i reboot the machine
usn_work
what OS are you operating on?
phimic
usn_work: SLES-10 SP3
usn_work: 1st issue crs come not up after reboot, ps faux looks like http://pastebin.com/d1159eebc
usn_work
what happens if you reboot?
phimic
/etc/inittab looks fine
usn_work
how?
phimic
h1:35:respawn:/etc/init.d/init.evmd run >/dev/null 2>&1 </dev/null
h2:35:respawn:/etc/init.d/init.cssd fatal >/dev/null 2>&1 </dev/null
h3:35:respawn:/etc/init.d/init.crsd run >/dev/null 2>&1 </dev/null
usn_work
can you show us the whole stuff?
phimic
usn_work: the whole inittab?
usn_work
yes
phimic
i will start crs as root using /etc/init.d/init.crs start
usn_work: inittab is on http://pastebin.com/d3cfb6750
usn_work
okay, known error
try to place the init* entries between runlevel 2 and runlevel 3 forks
(lines l2 and l3)
phimic
usn_work: ok i did and reboot now
usn_work: crsctl check crs returns Failure 1 contacting CSS daemon, Cannot communicate with CRS, Cannot communicate with EVM
mator_
phimic, no need to reboot (on linux) when you change inittab, just do "telinit q"
phimic
mator: thanks
usn_work: i found http://forums.oracle.com/forums/thread.jspa?messageID=2412563
mator
if you're on older linux versions, since newer ones are using event based management (/etc/event.d/)
phimic
usn_work: on SLES-10 i have to disable RUN_PARALLEL in /etc/sysconfig/boot
usn_work
cool
did not know that, I solved it with a sleep AFAIR
hali
suse, jibbrish
usn_work
hehe
hali, how would you reduce a LOB segment size in 9i?
I know your blog entry
hali
update table set data=empty_blob();
shrink
done!
:)
usn_work
mh
and if I want to reuse some of the data? ;)
mastro
usn_work, hum.. i see.. and is there a way to change that choice on a database that already exist?
mattboll
I've installed a database orcl following basic how-to. I've been asked to create a new database and import data. with other databases I would just do "create database newone" etc. but with oracle I'm not sure, may I do the same thing or create a new tablespace or& ?
by other databases, I mean postgresql or mysql
mator
mattboll, new database in oracle is a new scheme
or by other means, just a different username
mattboll
ok&
mator
mattboll, this link http://www.oracle.com/technology/obe/10gr2_2day_dba/schema/schema.htm provides a basic understanding what is scheme and how it can be managed with EM
i'm suggest you to read a bit more about oracle concepts... i.e. for example full version of "2 day dba" book
mattboll
I would so much like to have time to read this book, but asked at 5pm today, must be done tomorrow& but thanks for the link
just for my information, does a lot of people use oracle with something else than windows ?
e.g. in a server -_-
mator
depends on your clarification of 'use' word :)
running a db or running oracle apps, while db is being run on some other host
there's indeed windows version of oracle db, but most people here in channel running it over some version of unix, like linux or solaris
sometimes even under vmware server
mattboll
we are full open-source here, and it's quite a pain to use oracle
with debian for example
snake007uk
hey guys, I am trying to install oracle RAC on a NFS filesystem. everything goes fine, the install starts, but it always gets stuck at 56%, linking JAVA? there are no errors in the logs and I dont have a clue?
anyone have any ideas/suggestions
idletask
Hello
GaMo-0
hi Serge_HID
mfilipe
how do I do to see users logged with Enterprise Manager?
monk12
hey all, I was curious. i have a stored procedure in a package. I see it being called from jsp page. I want to login the tomcat box to see the user name so I can see the schema where that package probably is... but i dont have access to the box currently and dba too busy to help, doh! Is there anyway i can search the database for that package or function and see what schema its in?
qnix
Hi folks
monk12
hello qnix
qnix
There is something I don't understand.... I have a table... if I do a describe mytable;. I see that the field LONG exists and its type is varchar(7).
However... as soon as LONG is in a select statement, the query fails with : missing expression.
Even a simple select LONG from mytable; just fails.
Any idea?
boingolov
monk12, look in all_source or all_procedures
monk12
k thanks boingolov. ill take a look
« prev 1 2 next »