logs archiveIRC Archive / Freenode / #oracle / 2010 / February / 17 / 1
pedronero
any OSB expert in here?
:)
hi 2 all btw
Reign1
hi, how to check java_pool_size?
dsdel
select * from v$sga;
select name,value from v$parameter(s) (?) where name like 'JAVA%';
show parameter java_pool_size;
Reign1
thanks
dsdel
but only available if you don't use autosga/automemory
then the parameter will be determined from oracle
autosga up from 10g, automem up from 11g
Reign1
11.2 here
stede
hi
SilSila
why this "userid=username/password@orcl" in formsweb.cfg is not working in oracle application server? i restared everything...but still its not working...when i open the form in the browser nothing is coming..at the same time if i remove userid part in the formsweb.cfg...the form is working but its asking for username and password...i gave the same username and password where i mentioned in the formsweb.cfg then its working....what might be the reason?
idletask
No idea, I don't use AS at all
         

bartavelle
hello
when i enter the following line in sqlplus, and press return, it writes the dreaded ' 2', meaning i somehow missed something
create library xxxx as '%windir%/system32/kernel32.dll';
however i can't see what i am doing wrong
(same problem with create function or create procedure, standard queries like select work fine)
a clue on what i am doing wrong would help a lot
idletask
bartavelle: try / then enter aftet the 2
bartavelle
it works
thanks a lot, even i have no clue why :)
idletask
I have no clue either, I have learned it the hard way a few days ago when I had to resort to writing PL/SQL procedures
bartavelle
what does the '/' character mean ?
idletask
It ends the input
bartavelle
ok
idletask
You could select something <no semicolon>, then enter, then /
bartavelle
i found out that '.' seem to end it too, but ignores what it typed
idletask
It would act the same
Yes, exactly
A good thing to have is a decent EDITOR variable
bartavelle
thanks a lot !
idletask
I set it to vim
And when I want to edit a command again, I just press ed
It launched vim, not ed ;)
Also, set editfile /home/oracle/tmp/scratch.sql is nice too
By default it's $(pwd)/afedit.buf or the like
Blah
bartavelle
i never knew about this external editor thingie
mator
heh... fedora lock up (I think its kernel) - first time in about 2 years :)
bartavelle
this will save a lot of time
idletask
bartavelle: oh yes, it does
bartavelle: you may also want to have a look at rlwrap
Command line history with sqlplus!
bartavelle
!
idletask
With all readline possibilities
sqlplus for the 21st century
bartavelle
i however usually have to work with what's install on a given computer :/
luckily, i mostly never touch oracle
idletask
Yeah well, you can do a lot to customize sqlplus already
Like, changing the default prompt
11:14:25 SYS@o2t > <-- that's my prompt
No need to "show user" to tell who I am at any given point in time
http://paste.pocoo.org/show/179208/ <-- here's my login.sql
         

bartavelle
i'll keep this around
power
hi,ive just installed oracle fallowing http://www.oracle.com/technology/pub/articles/smiley-11gr1-install.html
it went perfect,however this is what i get : http://pastebin.com/m5f99a29
tnsnames.ora seems OK to me
usn_work
qwak
Rudemeister
?
dsdel
power: adjust the trace setting of the listener, then restart the listener
afterwards retry to reproduce the problem and check if you can find something inside the listener trace
idletask
Question
Due to the JVM being installed in the database, I have a hc_xxx.dat created in $OH/dbs each time I start an instance
How can I _avoid_ the creation of this file?
Rudemeister
I believe you dont
and its nog jvm related
idletask
Really?
What is this due to then? Only when I have the JVM in an instance this file is created
Rudemeister
Healthcheck files, which seem to exist only to confound your efforts in enterprise manager.
idletask
Ah
Interesting
As I do NOT use EM, is there a way of getting rid of these files altogether?
Rudemeister
why would you wantto?"
idletask
Because I don't _need_ them, and ultimately I want to mount $OH read-only
Rudemeister
idletask: http://kkempf.wordpress.com/2009/12/16/whats-in-your-dbs-directory/
idletask
Rudemeister: interesting, but low on details for my particular point though :/
I don't even have the EM schema in the database!
Rudemeister
and yet you determine you don't _need_ it:P
idletask
No I don't
I know how to monitor the health of my machine and the instance well enough without this
Rudemeister
delete it
:P
ah my new password: o%VQvkPa$7CK
power
MyN3wP@$$w0rD is better
hali
Password1 ftw
Rudemeister
:>
superlinux
hi all. I am a little bit beginner in oracle, about to be of intermediate level, that's cos I know SQL very well. what I want is: how can I create a new user who can be as a normal OS user? I mean he should be able to create his own tables and delete them ..etc... without harming the oracle system, as if he is in his home folder
Rudemeister
for exercise purpuses, unlock the SCOTT schema;
superlinux
Rudemeister, more than that.
I did all that
Rudemeister
then create a new user
superlinux
ok
then which roles should I grant the new_user?
Rudemeister
grant session/connect thingy and he she can do many things in its scheme
superlinux
ok
Rudemeister
see scotts perms as an example
superlinux
as if he is in his home folder? like a unix non-root user?
Rudemeister
what do you mean, as if
yes, he she has a session
should not be able to elevate hisher privs
superlinux
what i mean is in unix generally a user can delete files and make files in his home folder without harming other people's folders.
Rudemeister, cos when I set a user as DBA role, s/he can do what the oracle user SYS can do
I want him with less privileges than SYS
RJarett
super dont touch databases
you arent beginner level yet. let alone intermediate
or pickup an intro to oracle book and read it cover to cover before you change permissions
Rudemeister
:>
superlinux
thanks guys
idletask
superlinux: you have to learn about privileges then
Try and create a user without any privilege, he or she won't be able to even connect, this requires the create session privilege
Once this privilege has been granted, connect with the user, try and create a table: (s)he cannot, because (s)he doesn't have the create table privilege
superlinux
idletask, i use the Enterprise manager (web based interface)
idletask
Grant the privilege, try again: (s)he still can't, since (s)he has no quota available to write anywhere
superlinux
so there are names which are very vage to me
idletask
superlinux: don't, use the command line
This is how you learn
superlinux
what I know is that always there is the connect+resource roles available for every user.
idletask
Every user? This is not so with the command line
Rudemeister
how do you now?
idletask
And the "connect, resource" is obsolete afaik
Which Oracle version is that?
Rudemeister
superlinux: how do you now?
superlinux
10g on the EM
RJarett
resource shouldnt be used...
idletask
(What is the "resource" privilege exactly BTW?)
RJarett
resource is basically create anything priv
idletask
superlinux: how did you create these users?
RJarett
delete anything too
some versions select any table
idletask
RJarett: ah, I see, create table, create procedure, etc
Ow!
superlinux
idle not a privilege
it's a role
idletask
superlinux: a role is a set of privileges
superlinux
true
RJarett
superlinux: are you guys licensed for every module in OEM (the web interface)? those are like thousands of $ per cpu per module
even the management tab is a licensed feature you need to pay for
you should learn to use sqlplus to admin the db.
power
tnsping gives OK (1563210 msec)
superlinux
RJarett, i just downloaded the 10g from the oracle website. i use the Linux version. I don't anything about licensing
i donno anything
RJarett
superlinux is this for a work project?
superlinux
no
I am teaching SQL using oracle
RJarett
then use XE
not the full one
just for the love of god, dont teach plsql
let it die
superlinux
well it won't look attractive to the students, it's private lessons
RJarett
shut the fu*k up
you havent used it
idletask
RJarett: why so (use XE)? You don't have to pay any license as long as you don't make it available to the public
RJarett
you dont know
idletask
XE sucks
RJarett
idletask: because he wastes the students time on trying to get it running
superlinux
part of the course is giving PL/SLQ
RJarett
superlinux: i feel bad for your students
superlinux
otherwise i won't be paid well
RJarett
lol
very very bad
idletask
RJarett: eh? An environment is supposed to be working prior to teaching
RJarett
if you know nothing about permissions, and need to use OEM to make users, your teaching will be terrible
Nothing like teaching with no thought put into security
superlinux
RJarett, it just runs perfectly .. don't worry about it
usn_work
folks ....
DiscordianUK
(Action) shudders
usn_work
be friendly
superlinux
usn_work, thanks
RJarett
idletask: ive just seen 14 years of bad code because of teachers like superlinux
wait until september and oct in #oracle channels here and efnet
idletask
superlinux: I don't agree... Like an author put it, "what is understood is clearly explained, and words to put it down come easily"
RJarett
you get the biggest bunch of fresh db class inept students
because the instructor is just as inept
idletask
superlinux: you say you want to teach SQL, not Oracle admin right?
RJarett
Spouting their mastery of Codd and Date, while not knowing anything about a real database and real life usage
superlinux
yes. but they want th PL/SQL too
RJarett
use XE
bartavelle
in my experience, oracle dbas do not give any care about security anyway, so it would be no use telling them about it
usn_work
I don' know superlinux, RJarett. But here at work are lots of SQL gods who can't touch a SQL*PLUS prompt without scaring the cat and burn the DBA out
idletask
bartavelle: hey, _I_ am a DBA and care about security
superlinux
RJ i don't mid letting them use the DBA roll
bartavelle
there must be exceptions
idletask
superlinux: you should
RJarett
of course you dont
superlinux
but I asked for my own sake
idletask
superlinux, a dba can do shutdown abort
RJarett
You know nothing of security
you should be teaching them from the start about POLP
idletask
And I disagree with RJarett
_DON'T_ use XE
RJarett
eh
he's all yours then ;)
superlinux
RJarett, admin IS NOT the target of the subject
RJarett
sql and plsql work the same in it. plus you have the benefit of letting them create real world situations
thats why i say use XE
idletask
PL/SQL is complicated :/
« prev 1 2 3 next »