logs archiveIRC Archive / Freenode / #oracle / 2010 / April / 26 / 1
r0
(Action) zzzzzzzzzz
Junior
yello ;)
KeiKurono
morning
deebo
is it possible to use sub queries in stored procedure calls somehow?
i have aa stored procedure with a curors parameter and id like to {call procedure(CURSOR(select * from temp_table))}
oracle deprecated .setCursor from their jdbc drivers and didnt document what to use in its place
so now i cant make plain jdbc statements
stede
hello. i installed succesfully 11g and set up listener/db and an user with a tablespace, grant him connect ... but i cant connect from a foreign system with sqldeveloper. are there other important things to know to get this working?
deebo
how do i populate a sys refcursor in a pl/sql statement?
OPEN my_cursor FOR 'select * from temp_table'; produces nothing
stede
how to create a listener aufter db installation in my console? (without) gui? rsponsefiles have not worked for now
dsdel
stede: if you don't have a listener already:
vi $ORACLE_HOME/network/admin/listener.ora
vi $ORACLE_HOME/network/admin/tnsnames.ora
after editing this files: lsnrctl start
lsnrctl services
lsnrctl status
:>
stede
dsdel, the file listener.ora doenst exist
and the content of tnsnames.ora looks fine for me: http://pastebin.com/VWaZvXj5
sry .. my fault .. it's there ..
but i still cant connect from another machine
however, for installtion i can note to copy this 2 files and and then use lsnrctl - so i dont have to use netca? right!?
         

deebo
how can i declare a cursor rowtype?
so i can loop it without defining each of the columns
phimic
hi all
how can i enable Automatic Shared Memory Management on a RAC without restarting the database?
how can i enable automatic pga memory management on a rac?
nobody around here?
hali
phimic: set pga_aggregate_target to whatnot
phimic
hali: is there a best practise value for the max. sga size
i use oracle 10.2.0.4 rac on a 2 node cluster
each node running SLES10 with 8 GB RAM
hali
give it a gig or so
and then keep an eye on v$pga_target_advice
gig pga, 2 gig sga
and keep an eye on v$sga_target_advice
phimic
hali for earch db instance, 1 gb pga and 2 gb sga?
hali
good start, but keep an eye on the advisory views
stede
i just restarted my machine and now i cant luch dbca anymore!? whats wrong? It tells my "No protocol specified"
ok ... i've to redo "xhost +"
phimic
hali: if i want to commit to spfile and on both instances without restart which value must i choose in SCOPE and SID?
ALTER SYSTEM SET sga_max_size = 2G SCOPE=BOTH SID=??? ?
hali
stede: xhost + is very insecure, you should consider using ssh X forwarding
phimic: yes, max_size first then sga_target
'*'
phimic
hali: thanks
usn_work
.
stede
hali: i use it just for the installation on a local system ;) and want to keep ist as easy as possible (i keep trying fpr almost one week .. without success so far :$ )
phimic
i tried ALTER SYSTEM SET sga_max_size = 2147483648 SCOPE=BOTH SID='*' but i get an error
ORA-02095: specified initialization parameter cannot be modified
is it possible to change the value without shuting down the rac
seb__
hi everyone
a friend of mine has ORA 00023 error, he doesn't figure out what's going wrong
usn_work
~> oerr ora 0023
00023, 00000, "session references process private memory; cannot detach session"
/ *Cause: An attempt was made to detach the current session when it contains
/ references to process private memory.
/ *Action: A session may contain references to process memory (PGA) if it has
/ an open network connection, a very large context area, or operating
/ system privileges. To allow the detach, it may be necessary to
/ close the session's database links and/or cursors. Detaching a
/ session with operating system privileges is always disallowed.
sytse
ummmm
I do revoke execute any procedure from public
I log in as a new user with no roles assigned, and *only* create connection granted to it
I do select * from session_privs
and I get... 'EXECUTE ANY PROCEDUR'?
+E
do I need to restart the database or something?
(and yes, I verified, the grant to public doesn't appear in dba_sys_privs anymore)(
tijnie
sytse, how is this user created?
The workaround is maybe "revoke execute any procedure from <user>"
sytse
nope
teite
hi
         

sytse
I checked everything (I think) tijnie, he really *doesn't* have any grant, directly or indirectly, for execute any procedure
teite
what does * SQL Analyze(404,1) */ SELECT ... do?
i get a ora-7554 for this statement, it tries to access an old archivelog
how weird is that ;)
sytse
https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=39338
RJarett
if you remove the hint does it work?
sytse
apparently, metalink note 153788.1 has information
(about ora-7554)
teite
sorry its a 7445 of course
sorry ;)
sytse
gheh
teite
ORA-07445: exception encountered: core dump [evaopn3()+129] [SIGSEGV] [ADDR:0x0] [PC:0x7C4BF03] [Address not mapped to object] []
the archivelog is already applied on the standby, backed up and deleted
wonder why the sql optimizer is trying to access it
sytse
http://dbaspot.com/ora-7445-exception-encountered-core-dump-s-s.html
"When an ORA-07445 occurs in an oracle database, the error is written to the database alertlog. Along with the error, a trace file is written to the background or user dump dest directory of oracle. Also a core dump may be created in the core dump destination directory"
ie, try looking at the alertlog
teite
ORA-00308: cannot open archived log '+FRA1/gme/archivelog/2010_04_25/thread_1_seq_36984.537.717285063
RJarett
are you sure you arent in flashback or anything?
or are you sure thats related?
sytse
I suppose it might be the -result- of oracle encountering an ora-07445, not the -cause-
btw, you could also take gdb and have a look at the core dump ^_^
RJarett
or use metalink to analyze it
sytse
(dunno how many symbols oracle retains in their binaries)
RJarett: also, metalink has an ora-07445 search tool, in case this bug is known
teite
sytse: a dbms job tries to access the old archivelog unsuccessfully and throws the 7445 afterwards
sytse
teite: try going through the suggestions that dbaspot article gives you, and eventually try resolving it with oracle support
hmmm,
might be useful taking it up with oracle support anyway, even if you resolve it, (well, at least unless the ora 7445 search tool gives you a match) as this should never happen
teite
ORA$AT_SQ_SQL_SW_5342
COMMENTS="automatic sql tuning advisor task"
sytse: true, the 7445 is probably a bug
just never heared that a optimizer is gonna try to read old archivelogs
sytse
except when you're in flashback mode of course (dunno about when you flash back the whole database)
teite
i'm starting to hate oracle ;)
11g has so many bugs, we have already a half a dozend open SR
is it possible to see if a oracle process has still a file handle on an archivelog in the asm?
dsdel
stede: no you don't have to use netca :) use google with tnsnames.ora / listener.ora for further informations
rizzo
(Action) <3 trying to figure out jre problems with Oracle 9i on hpux
!@$%!
hali
i have 10g on an rx2660 somewhere
hm, hp are a bit funny with jdk's
as noone who makes a proper jdk actually support hp-ux on their own
hp bodges it
sytse
rizzo: hmmm, 9i, huh...
mm, reading some awrrpt reports
interesting stuff
sinesio
hi, does anyone know how to configure FAN to write to a text file the up and down events of a cluster?
I've been trying some samples but I think oracle FAN is not active
next »