logs archiveIRC Archive / Freenode / #oracle / 2010 / April / 1 / 1
KeiKurono
morning
boos
:)
Reign1
hello, can i use both highmem and amm at a time?
as i dont see how these 2 interfer, yet was told i cant
anyone?
hali
http://andreas.scherbaum.la/blog/archives/657-PostgreSQL-9.0-Includes-the-new-MySQL-Emulation-Layer.html#extended
DTEIT
hi
i'm trying to use oracle db for learning on a windows box
install went ok, create listener ok,
but when i try to create a ned db, i always get
ORA-12560: TNS: errore dell'adattatore del protocollo
sorry it's italian installation
dsdel
tnsping <sid>
always use english version if it is possible :)
balek
hi i have a question please i use oracle rac all it work i have two database on cluster but my problem is i want to create a new database (on the cluster) with dbca tool but i can't i can only create on local of the computer not in the cluster have you any idea please thanks
DTEIT
dsdel: Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNE
CT_DATA = (SERVICE_NAME = TEST)))
OK (20 msec)
balek
is it normal i use oracle 10g standar edition
         

cmug
Any clues why I get in a fresh database doing impdp ? "ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling DBMS_METADATA.CONVERT []"
dsdel
DTEIT: sqlplus <user>/<pw>@<sid> doesn't work?
DTEIT: the remote server is correctyl configured?
balek
nobody see why dbca can't see i use rac oracle and when i want to create database it only want on the local computer please thanks
DTEIT
dsdel: no...sqlplus doesn't work...it gives me that error
oracle service is up
dsdel
DTEIT: check the alertlog
rsavu
hello all. how can i simplify this algorithm to be 1 step? select count(*) from ... where ; if count = 1 then select column from ... ?
balek
hi i have a problem with my rac oracle i use lsnrctl status on node1 i can see two instance its's ok on the node2 i use lsnrctl status i can only see one instance and wheni use srv_stat -f i see on the nod2 ora....T2.lsnr application ONLINE OFFLINE if you can help me please thanks
DTEIT
dsdel: i don't have any alertlog in rdbms/trace
KeiKurono
dteit trt rdbms/log
DTEIT
nothing here as well
KeiKurono
could you please point me to some doc which list all the v$ tables
found, nvm
uh..
SQL> desc all_constraints; ERROR: ORA-04043: object all_constraints does not exist
RJarett
remove the ;
desc all_constraints
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER
KeiKurono
no changes...
RJarett
desc user_constraints
dsdel
KeiKurono: with which user are you connected? :D
KeiKurono
rjarett: no changes
dsdel: conn / as sysdba
dsdel
select count(*) from user_constraints; ?
KeiKurono
it says the object doesn't exists
dsdel
select view_name from all_views where view_name like '%CONSTRAINT%';
?
if that doesn't work also - your DDIC is /smashed/
KeiKurono
ORA-00942: table or view does not exist
         

hali
KeiKurono: you're using oracle 7 or something like that right?
KeiKurono
all_views
yes, oracle8i, sadly
hali
yes. don't expect anything obvious to work
KeiKurono
i don't understand sorry
i expected this things to work honestly
hali
8i is about 10 years old, things change and improve
KeiKurono
but this things should be 8i compliant, right?
dsdel
i'm to young to know that heheh
hali++
hali
me too
i just ignore anything pre-9ir2
KeiKurono
i have some 8i docs, those things are listed.. uhm
dsdel
hali: hehe I also try to - luckily all our customers switched to 9i years ago
hali
im going live on my first 11gr2 in about a month, yay
and the lowest release i work with is 10gr2 fortunately
had 9ir2 until recently though
dsdel
most south american customers still got 9i :)
I hope 11g r2 is coming out soon for windows...
need to upgrade the customers who have currently 11g r1
KeiKurono
ugh i don't have any view at all
at this point i need a proof that oracle installation is broken
balek
hi i have a problem with the service lsnrctl on my oracle rac node2 is it easy to delete and recreate it please thanks
zambaboo
hey guys
is it normal that the number of open cursors keeps growing? oracle 10g SE, rhel4.
Xgc
zambaboo: Depends on DB usage.
zambaboo
Xgc: should it ever go down? i read this article:http://www.orafaq.com/node/758 and it sounds like the answer is yes.
Xgc
zambaboo: Ever increasing is usually a bad sign.
zambaboo: Yes.
zambaboo
so im looking at application code then
Xgc
zambaboo: The max is a fixed configuration setting, but the current open cursor count depends on usage.
zambaboo: Most likely.
zambaboo
understood. thank you,
Xgc
Pretty typical of a long running app that doesn't properly close resources.
r0
hi guys
spcshpopr8r
please help: my smon process has been performing tons of I/O for most of the day today, it seems to be cuasing performance problems, what can I, should I look for?
jedi1
is it possible to create 2 object types that contain references to each other?
« prev next »