logs archiveIRC Archive / Freenode / #oracle / 2010 / January / 20 / 1
Spec
Is there a way to query something from someone else's instance, in the middle of transaction that hasn't been commited yet?
Dormir
someone else's instance or session?
Spec
Dormir: doesn't matter anymore
Dormir: let's say i log in as user1, and run a big transaction. if i login as user1 and query, i don't see any changes until that transaction has been commited, right?
Dormir
correct
Spec
Dormir: so there's no way to peek? :)
Dormir
not that I can think of
RJarett
kick off a session level trace on the dudes session with binds enabled and read the binds from the trace file
Dormir
that would get what he does from then on, but not what he has done
Spec
hmm, would be able to figure out what i've done based on what i'm going to do
         

SilSila
can i use windowsxp as a oracle database 10gR2 server for 10 clients?
phimic
hey all
our oracle-rac database uses 15 GB space in ASM, i have setup a 2nd archlog destination to local disk
how many size should i reserve for this second archive log destination?
TheBonsai
does not depend on the size of the database, of course.
phimic
TheBonsai: is there any rule for that?
TheBonsai
amount of changes per time, and your archivelog keep time (on a backup, you usually would delete archivelogs)
phimic
TheBonsai: ok thanks for that info, we do rman backups every night
TheBonsai
do you run a BACKUP ARCHIVELOG ... DELETE INPUT; there?
phimic
TheBonsai: backup as compressed backupset current controlfile database plus archivelog delete input;
TheBonsai
ok. the amount of archivelogs between these nightly backups is the amount of database changes
(+/- NOLOGGING operations)
phimic
TheBonsai: ok thank you for that info
TheBonsai
if you count and get X GB, just multiply it by 200%
minimum...
or you will be here in a few days and complain that the instance stopped working, and we will find out that archivelog space is full...
m00 hali
knandan
Hi..
Is there something wrong with this sql command?
http://sql.pastebin.com/m511e3744
jagadish
TheBonsai: i have installed oracle on linux system, and i want to connect to that from windows ,
i have os authenticated in windows
can i connect with same authentication to the db on linux
knandan
jagadish: yes ..you can connect..
TheBonsai
no idea. i use *operating systems* ;)
knandan
use some client application..
sqldeveloper is a good client application..
jagadish
knandan:how to connect
knandan
you need to install some client application on your windows box..
best one is sqldeveloper..
then you need to provide the ip/port of the oracle server
JPavleck[Laptop]
Hey gang, is there a way of doing a sql query that will get one field to wrap? Trying to import this into excel and the length of one field is messing up the "fixed width" import
TheBonsai
knandan: he asked for SSO i believe
JPavleck[Laptop]: and you thing a wrapped field (i.e. inserted a newline) will fix your fixed-width import?
         

knandan
TheBonsai: yes..the same credentials can be used ..
JPavleck[Laptop]
Not sure, hoping it would, since the field that's causing excel to import it oddly is the jdbc strings
knandan
ok..i am getting the problem now..
TheBonsai
knandan: SSO is a way to sign on one time, and never sign on to (other) services again. "same credentials" is something else. but anyways, i'm not sure what he really *wants*
knandan
sorry..no clue about the SSO feature..
TheBonsai
JPavleck[Laptop]: i'm not sure (and i can't try it), but i gues sthe field length is not the same as the field width. no idea which differences excel does there. but i could imagine there's a FUNCTION() you can use in the query around that field to alter the result
JPavleck[Laptop]
now I feel a bit silly, I found the 'export to' bit. Sorry. Not used oracle sql yet
blaamann
How do I dump desc of a table to file?
Or better to mail so it can be sent directly to my inbox (this is on a unix system).
TheBonsai
just redirect the output of sqlplus maybe
sytse
knandan: yes, there's something wrong with that query.. you're not grouping by stamp and guid, so you need to do something like max(stamp) keep(dense_rank first order by sequence desc nulls last) and the same with guid
superlinux
hi all
for all those who has troubles downloading from oracle.com, Do clear and delete all your cookies , and restart your browser. On firefox, do not save your pages when your asked at quit time.
sytse
yeah yeah, you said that just five minutes ago :P
superlinux
sytse, good to be kept aside
sytse, sorry if i annoyed anyone.
sytse
never apologise! It's a sign of weakness
or maybe I've been watching too many episodes of NCIS :P
superlinux
sytse, hehe
i watch egyptian playes
i watch egyptian plays
phimic
how can i delete databaes in emca which has already deleted
sidh
greetings gentlemen
i'm on a solaris 10 oracle 10gR2 server, and i would like to see all the instances that are running
Discordian
uhuh
sidh
as i have ssh access only , and didn't have elinks installed, i can not look at emctl dbconsole
is there a command that list running instance ?
Discordian
ps -aef|grep ora will show you all oracle processes
knandan
is select statement a DML statement?
Discordian
No
It's an SQL one
cofeineSunshine
dml- data modification language
giusef
Hi there, can I make a question about identity management?
I don't know if this is the right place
knandan
Discordian: all the dml statements are sql ones only..
LFC_fan|ZNC
Hey how do I install Oracle XE in Ubuntu 9.10 AMD64?
DiscordianUK
from the .deb?
srm
there's even a page about it on oracle. http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html
LFC_fan|ZNC
Well the repos dont respond :/
"Err http://oss.oracle.com unstable/non-free Packages
404 Not Found"
apt-get update output
DiscordianUK
Can't you download the deb and install it?
LFC_fan|ZNC
It's i386
Mine is AMD64
DiscordianUK
Correct
LFC_fan|ZNC
Also it doesn't let me login :/
DiscordianUK
Oracle-XE isn't available 64 bit
LFC_fan|ZNC
Hmm
DiscordianUK
But 32bit apps run on 64 bit OSes
LFC_fan|ZNC
yeah :/
DiscordianUK
I run Oracle-XE on a 64 bit fedora box
You have to register to download the .deb but registration is free
LFC_fan|ZNC
well it doesnt register :/ some kind of problem
http://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/
Downloading from here is OK?
DiscordianUK
Presumably
LFC_fan|ZNC
doing that now
monk12
hey all,
quick question... I have a package which has a global var... a stored proc sets this var, and another stored proc access/increments it. So in usual workflow, I run the 1st stored proc, then the 2nd a few times. [like setting a 'question' with 1st proc and then setting answer(s) with 2nd proc] but now need to run just the 2nd with a predefined global var (aka manually set, not set via 1st s.p.). is there anyway to do this? Basically to set a package's global, witho
sidh
have to create a new instance on an existing 11G server, so i wanted to check the init<instance>.ora for the instance that is already running (to check memory_target parameter), but i can't find it, is it normal ?
RJarett
running system dont use their initWHATEVER
search your oracle_home for spfileWHATEVER
specifically $ORACLE_HOME/dbs/
spfile$ORACLE_SID.ora
sidh
yes spfileSID.ora
RJarett
yeah thats what i said
strings the file
since ts pseudo binary
never edit it yourself
sidh
thank you very much RJarett , i thought i had to set memory_target in an initSID.ora i had to create
RJarett
nope
alter database or alter system set whatever scope=both
and that sets it in the running system and in the spfile
or you set memory crap usually scope=spfile and restart
sidh
when you say string the file , that mean i have to grep for memory_target ?
RJarett
no
you have to strings spfile | grep
so you only read in its ascii content
sidh
RJarett: sorry for my "n00byness" but i remember having create on my test 10g server a $ORACLE_HOME/dbs/init<SID>.ora file where i set the control_files path, undo_management/undo_tablespace, the db_name, db_block_size, pga_agregate_target/sga_target (now replaced by memory_target on 11G), so if on
RJarett
and?
sidh
so i don't have to on 11g, where ca i set those value for DB creation
RJarett
that should have been created on install
you havent created the db yet?
sidh
no
RJarett
then use dbca
the creation assistant
sidh
no i don't have X
RJarett
im not helping a newb with a manual db creation
then send your display to a remote box
that does have it
havent you heard of ssh tunneling?
use cygwin/x on your laptop or desktop. or Xmin
ssh tunnel to the db server
oracle REQUIRES a minimal subset of stuff like motif and all or else it wont run
ok heading off
sidh
on 10g after running the create database process, i only had to run the catalog.sql and catproc.sql and that was all
idletask
Hello
I attempt to install the 11gr2 database engine using the silent mode of the installer
Unfortunately, it forks to the background of the shell to proceed :/
Is there a way not to make the installer do that?
hali
what is the problem with that?
idletask
hali: well, what if you do the install within a script and want to wait for the install to end?
You can't
I don't really care for GUI installs
But for non interactive installs, I do care
sidh
idletask: if you use the manual way for creating the db, you can install tmux or screen on the DB machine
and lauch it in your ssh session
like this you can detach /attach your session when you want
idletask
sidh: this doesn't address my primary concern, though
I know I can use screen
hali
ah, i do the create database manually usually
after a script saved though
cmug
desc <tablename> should always print the columns in the correct order, that is required by an insert into .. right?
idletask
I am not talking about the database creation
But the database engine install
cmug
or is there something that might affect the printing order
Dormir
cmug: you should always use the column list. it helps avoid errors
but yes, desc outputs in the right order
cmug
Dormir, yes, but I am trying to debug 2 application installations, desc <table> prints the same columns, but in different order
I just need to verify that there is nothing other than table structure that can affect this?
its not desc/asc but the columns switch places
idletask
cmug: as Dormir just said, use explicit column names for insertion, it will avoid errors
Dormir
or you can look at *_tab_columns
idletask
Well, OK, that doesn't really matter, I have found a workaround
"zip" installs rock
Must go
Have fun
cmug
idletask, yeah, I wonder what the application does
hmm, it actually uses set column = value
"ORA-01461: can bind a LONG value only for insert into a LONG column
" is returned when executing SQL statement " what else could cause this?
Dormir
are you inserting into a LONG?
cmug
There is no long datatype column in the table
some nvarchar2's and nclobs thoug
it might be something like this http://vsadilovskiy.wordpress.com/2007/10/19/ora-01461-can-bind-a-long-value-only-for-insert-into-a-long-column/
however I am running 10g
the difference between the databases is that the other is 32b and other is 64b
but both odbc drivers on application server is 32b
Dormir
is it set as a multibyte character set?
cmug
how do I verify
Dormir
it may be the code itself is trying to work with more than 4000 characters internally
cmug
ah multibyte means utf8+
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#06_12 may also be the reason
Dormir
nls_database_parameters
yes, there are a number of ways to get the error
cmug
-
NLS_NCHAR_CHARACTERSET
AL16UTF16
I'm running 10.2.0.3
The error does not seem to happen on the 64b installation
and the 64b is actually 10.2.0.4
maybe something in there?
Dormir
what's NLS_CHARACTERSET set to?
and yes, I did see something about upgrading
« prev 1 2 next »