logs archiveIRC Archive / Freenode / #oracle / 2010 / May / 10 / 1
wulfgar|laptop
hi, ive set $ORACLE_HOME to the bin directory .. but i still cannot run sqlplus from the cli
any tips ?
Trengo
yeah you want to set ORACLE_HOME to your oracle home, and PATH=$PATH:$ORACLE_HOME/bin
wulfgar|laptop
i see
i got it working
thanks Trengo
TheBonsai
Trengo preferrable $ORACLE_HOME/bin:$PATH :)
stede
hi
Trengo
TheBonsai i'm used to setting "base" dirs first, *then* app dirs :P
stede
what syntax to use if i want to copy most cols of one row from tab1 to tab2 inside a stored procedure?
or which topic i should search the doc?
cmug
haha, asktom is down because "unable to extend table ASKTOM.ATE_QUESTION_LOG$ by 1024 in tablespace FLOW_19246"
Trengo
DBA fail
EDISKFULL
         

stede
why i cant use dbms_lock.sleep() in a procedure?
it thats dbms_lock.sleep() has to be defined
dddh
hm
ORA-01653
stede
dbms_lock.sleep(3) -> must be declared?
some hitns are to grant "a" rule .. but i do not find any which i can identify as related to this problem
Dormir
you have to grant privs to the user so that he can execute the procedure
mgolisch
ORA-19573: cannot obtain exclusive enqueue for datafile 3 what does this mean?
i did shutdown immediate followed by startup mount in rman before issueing the restore database command which produces this error message
what am i doing wrong?
anyone?
mugwort13
Is oracle linux free to use? Or is there a license fee?
b_52light
hi
ppl how could i print all character of a string ?
cofeineSunshine
dbms_output.put_line(v_string);
you should enable dbms_output
Caelum
oracle seems to have types like FLOAT(25) but they're not documented
are they aliased to BINARY_FLOAT/BINARY_DOUBLE ?
kaylee_work
morning
is there an easy way to specify the date format on the date columns when performing a "select * from ..."? or do I have to list out every column to set the format?
Dormir
you can set the format for your current session with alter session set nls_date_format='format';
kaylee_work
ah, thanks!
zasz
i am amazed by hwo the oracle documentation site is ALWAYS slow
b_52light
anybody could help me with this fct plz
http://pastebin.com/U0q6cENv
i got problem in the min function level
mick_laptop
hi everyone, i'mtrying to configure the listening interface for oracle xe. if i do sudo /etc/init.d/oracle-xe configure it only asks for the listening port - but nothing about the interface - is it that itcan only listen on lo?
of course looking online yeilds no usable results
DiscordianUK
Hmmm
What OS is this?
obviously it's linux but RHEL/centOS or Fedora?
mick_laptop
ubuntu
TheBonsai
*shiver*
mick_laptop
does it matter what distro?
DiscordianUK: if you can point me in a direction, then i'd probably be able to adapt it to what I'm using
TheBonsai
check what listener.ora is generated
         

DiscordianUK
well it does because I know those three OSes
And I know the gotchas for them for Oracle-XE
mick_laptop
that just had the port number the last time i checked
TheBonsai
so it listens where?
DiscordianUK
what does lsnrctrl status say?
mick_laptop
a bunch of Message errors, let me pastebin
DiscordianUK: http://pastebin.com/raw.php?i=79iuYHgU
TheBonsai
set your environment
mick_laptop
sorry that that took so long, i'd not have thought to look in /usr/lib/oracle ....
TheBonsai
especially ORACLE_HOME
mick_laptop
ok
http://pastebin.com/raw.php?i=xYPg3Ki3
i know that it currently is listening on lo - but i see the HOST parameter
now i know what to grep for
DiscordianUK
tada
It's listening
TheBonsai
it listens on whatever IP lakshmi-laptop resolves to
mick_laptop
though I see that it looks like it goes by the FQDN
right
thanks DiscordianUK and TheBonsai
and sorry that you don't like ubuntu :P
DiscordianUK
by the looks of it on your external ip too
Does it matter
mick_laptop
does what matter?
DiscordianUK
RHEL and CENTOS is where the work is
mick_laptop
depends
DiscordianUK
It's linux anyway
mick_laptop
right
that is how i see it
for the most part
except centos is more of a pain (i had to package too much myself for it)
DiscordianUK
(Action) is also a Solaris/Unix[tm] sysadmin
mick_laptop
so am i
those jobs are disappearing though :(
DiscordianUK
I did RHEL stuff at the BBC one contract, packaging stuff
TheBonsai
i didn't say i don't like ubuntu
mick_laptop
you just got shivers :)
TheBonsai
i just refuse it as a server
avaia
<TheBonsai> i don't like ubuntu
DiscordianUK
I choose Fedora as a desktop/laptop os
mick_laptop
the only solaris job within 200 miles of me -- i've already had
TheBonsai
avaia: damn :)
DoubleString
gn guys
bekks
hi
someone please can clue me on some doc or explain it whats the difference between startup mount and alter database open?
how is it possible to rename datafiles using startup mount, when the database is not open?
drdimitri
bekks: http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/start.htm#sthref523
bekks
thank you!
So "startup mount" is needed for distinct operations like recovery, etc. while "open" means, the instance is started, the db is mounted (all datafiles are "opened"), but no user besides the sysdba can do anything (not even connect) to the db instance?
usn
idle = nothing active
nomount = some processes online, shared memory segments allocated
mount = controlfile is online
open restrict = everything is online, but only special granted users can connect
open = everything is online ans usable
bekks
everything means: Datafiles and last processes
bekks
usn: thanks! that clears up a lot :)
so with mount processes like logwriter arent online?
fail.
so with nomount...?
usn
nomount just means that anything is functional, but without controlfile all the online config is missing
the processes may be there, but they will be idle
pmon works, and parts of smon I think
bekks
thinks like correct destinations for paths etc in the initINSTANCE.ora are evaluated?
So whats the control file actually for?
or "the control files"?
usn
the control file registers all the datafiles used in a DB
and it keeps up the "database time", called "system change number"
bekks
I do know little about oracle i have to admit. Things like "redo logs are 'transferred' into the archive logs when sgutting an instance down" are logical for me.
usn
nice
drdimitri
Also the checkpoint is written into the controlfiles when dirty Blocks are written to disk.
usn
init.ora is used to start up the basics, like SGA/PGA
bekks
and IIRC correctly, redo logs are transferred into archive logs when using alter database switch logfile(s);
usn
nope, not necessarily
bekks
So the init.ora is basically needed for "startup nomount" then?
usn
the system changes the current(ly used) logfile
archiving can happen later
init.ora: true
bekks
I'm having three redo log groups on the box I'm working on.
usn
create 10 of them, and see what happens if you switch 5 times
bekks
They are switched from A to B to C, each time a switch logfiles occurs?
usn
look into v$log
with three, not all cases are possible
they may jump over ACTIVE logs as well
bekks
what does that mean?
usn
making sequnces on 1, 2, 1, 2 ,3
redo log files are overwritten if DBWn synced the dirty blocks connected to it to disk, AND ARCn has archived the log
bekks
So for savely shutting down an instance, and copy it over to another box, I'll have to switch logfiles several times and the shut the instamce down?
usn
if one of both is delayed, it's possible to continue with a log out of the order
no
if you shutdown regularly, oracle takes care for syncing anything
bekks
So how can I achieve a safe state then, for shutting down an instance?
usn
usually you should not need any redo information
SHUTDOWN IMMEDIATE
and copy all datafiles plus control files
bekks
After shutdown immediate, do i need the archive logs and redo logs as well?
usn
you CAN copy the redos to be safe, but you do not have to
bekks
Or just the datafiles and controlfiles.
usn
but to copy a DB from one host to another, modern DBAs are using RMAN duplicate
bekks
I have no chance to use RMAN on that box.
usn
What version are we talking about?
bekks
Old box, Solaris V280R, Oracle 9.2.0.5, new box: M4000, Solaris 10U8, Oracle 10.2.0.4, CPU patches 10-04 applied.
usn
do you plan a migration?
bekks
Using startup upgrade; and afterwards updating the catalog, as well as recompiling invalid objects using utlrp.sql, there should be no problem on "migrating" the old database?
I have to, yes.
usn
I'd guess. But make sure that anything works well on the new box before patching it
bekks
before patching?
why so?
usn
make 9i go before 10g comes into the game
to give yourself a chance to find the cause of possible errors
bekks
no, there is no chance on using 9i on the new box,. because of "political issues".
I have to rely on the "old box" entirely if something irreparable happens on the new box.
usn
then: "good luck"
bekks
thank you :)
Kinda suicide, i know...
usn
but in theory it should work
you don't sound very familiar with Oracle concepts, why do you have to do such a "intimate" job?
it's risky, you know
bekks
Because I have to... wasnt my decision.
I just rely on the old box with "shutdown immediate", to able to fire it up again and having a "way back".
DiscordianUK
that sounds well iffy
bekks
And for sure, I'm having a backup of the old box after shutting it down.
usn
it may be advicable to try some restart on the old box before copy
startup and shutdown 2 times
just to be sure
bekks
without starting the listener to avoid changes by users?
yes, that is advicable.
usn
nope, with startup restrict to avoid changes by users
bekks
ah ok.
so "manually bring it online" all the way?
usn
no, just "startup restrict" in idle mode
and "shutdown immediate"
and again. Just to see it works
bekks
startupso first startup idle, then startup restrict, then shutdown immediate?
gna. "so first ....".
usn
another hint: Go to 9i final release (should be 9.2.0.8) first
bekks
Will i run into sever issues if not?
usn
You will be vunerable to issues if you don't
bekks
ok.
usn
it's just good practice
and at least supported :)
bekks
;)
« prev next »