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.

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

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

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 =)

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

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

sytse, ok, i think that IC belongs to paissad

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?

sytse: well, strictly spoken it can. SYS :)
paissad-hp: connect as SYSTEM and GRANT the stuff

sys just has lots of privileges, it doesn't technically -own- everything

that's wrong

ok

SYS is the owner of the data dictionary

heh, I forgot that ;-)

TheBonsai, i do connect system@IC ?

yea

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

paissad.repas

ohhhhh

you know what a "schema" is?

btw, I think all you need is to grant 'create view' to paissad

TheBonsai, actually, i'm new to oracle ..
don't really know what's a schema

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

TheBonsai, yes mysql

(that's why they have an alias CREATE SCHEMA for their CREATE DATABASE)

ok
http://www.techonthenet.com/oracle/grant_revoke.php
i don't see how to grant view privileges

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 ;-)

sytse, ok thanks

<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"...?

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 ?

tora should see Oracle

tora is cool but for ubuntu it have to be compiled manually

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'

paissad-hp: hold on

paissad-hp: It's usually up to you to provide the connection details.

Xgc, oh ok
phimic, i hold on

paissad-hp: take a look at https://help.ubuntu.com/community/HowToBuildToraWithOracle

phimic, ok thanks

help the beginner plz

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?

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

in general, a sane OLTP app should scale well

ok, thanks, now I'll try to understand if my application is a sane OLTP :)

hehe

are the oracle official study materials enough for a beginner to start with?

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?

is it enough or i need something else?

GaMo-0, for a beginner I think it is enough.

my last question
is it enough 4 the membership exam?

I don't know :)

good morning

usn_work, Hi

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

thx Serge_HID

Hello! Any way to easily escape quotes in a variable? TRANSLATE(var, '''', '''''') does not work.

"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

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? :]

emctl status dbconsole

[Oracle Enterprise Manager 11g is not running.
:/

http://tinyurl.com/ycvfv6z
ps: emctl start dbconsole

djeday: big thanks
i've got it myself, but without you i'd never thought about emctl
(yes, im a real newbie to oracle)

usn_work, thanks for html metalink :-)

Serge_HID, I have used the replace() function. Thank you :)

;)

4/sc

usn_work: hi

hi phimic

usn_work: i need you help :(

what's your billig address? ;)
billing

usn_work: :)

I won't promise you help without knowing the question

ok i start from the beginning, i setup a two node rac 10.2.0.3 with RDM and raw partitions using asm

but you will promise to charge a large amount for project management time

all works fine until i reboot the machine

what OS are you operating on?

usn_work: SLES-10 SP3
usn_work: 1st issue crs come not up after reboot, ps faux looks like http://pastebin.com/d1159eebc

what happens if you reboot?

/etc/inittab looks fine

how?

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

can you show us the whole stuff?

usn_work: the whole inittab?

yes

i will start crs as root using /etc/init.d/init.crs start
usn_work: inittab is on http://pastebin.com/d3cfb6750

okay, known error
try to place the init* entries between runlevel 2 and runlevel 3 forks
(lines l2 and l3)

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

phimic, no need to reboot (on linux) when you change inittab, just do "telinit q"

mator: thanks
usn_work: i found http://forums.oracle.com/forums/thread.jspa?messageID=2412563

if you're on older linux versions, since newer ones are using event based management (/etc/event.d/)

usn_work: on SLES-10 i have to disable RUN_PARALLEL in /etc/sysconfig/boot

cool
did not know that, I solved it with a sleep AFAIR

suse, jibbrish

hehe
hali, how would you reduce a LOB segment size in 9i?
I know your blog entry

update table set data=empty_blob();
shrink
done!
:)

mh
and if I want to reuse some of the data? ;)

usn_work, hum.. i see.. and is there a way to change that choice on a database that already exist?

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

mattboll, new database in oracle is a new scheme
or by other means, just a different username

ok&

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

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 -_-

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

we are full open-source here, and it's quite a pain to use oracle
with debian for example

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

Hello

hi Serge_HID

how do I do to see users logged with Enterprise Manager?

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?

Hi folks

hello 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?

monk12, look in all_source or all_procedures

k thanks boingolov. ill take a look