logs archiveIRC Archive / Freenode / #oracle / 2009 / November / 30 / 1
l3thal
the installer of oracle 11gR2 hangs at Starting 'Oracle Database Configuration Assistant'
any idea ?
Xgc
l3thal: That might indicate you haven't satisfied the system requirements to install Oracle (missing patches, wrong OS / version, etc).
l3thal
Xgc: yeah its on archlinux
Xgc: are there any patches available for 11gR2 ?
infl
morning all,how can I startup oracle in windows without " net start OracleService...."
meadow1
hellow people
anyone volunteer for a little help ? i am really lost.
my ISP recently changed the website where i can lookup my broadband usage.
well the website doesnt load for me either in firefox or in IE 7
i ve called them up and asked abt it, but they say it shud load in IE
i was frustrated and decided to solve the issue.
so i looked up the web page's source and found that its using
Oracle Siebel CRM
CRM = Customer Relationship Management
so my question is - is there a specific browser or an addon etc thats needed to use websites that use Oracle Siebel CRM ?
here is the website - http://www.selfcare.sdc.bsnl.co.in
in Firefox the page loads , but the mouse cursor changes to a circle and keeps on rotating, not allowing me to type or click anything in the page
in IE 7, the page doesnt load at all, it seems to take infinite time
btw i am using Windows Vista Ultimate
I am sure its a little problem, i must be missing something.. Any help is much appreciated.. thanks :)
after searching many irc servers, i finally found a channel for oracle here ;)
spheniscus
mornin all
mator
morning
Egyptian[web]
morning all
Trengo
morning
         

siamba
should I use java-1.4-ibm, java-1.5.0-bea or java-1.6.0-ibm to install oracle10?
there is no java-1.6.0-ibm ..
mator
siamba, oracle is shipping JVM on its own
siamba
mator, it doesn't work with current linux'es
mator
please be more specific
hali
siamba: what "linux" is that?
i would recommend running a centos install if you want a trouble free(-er) life
siamba
there was a problem with oracle on sles10 and sles11 on itanium
*oracle10
I guess the most supported is java-1.5 bea?
mator, do you recommend jrockit or ibm jre?
hali, does centos ship sun java or there are choices?
hali
no
you don't need a java distro shipped with your os distro
oracle comes with whatever it needs
we are talking about oracle 10gr2 database now? not oc4j or something?
siamba
hali, are you sure?
10gr2 - 10.2.0.1.0
hali
yes im sure
having a non-oracle-provided jdk/jre in path usually causes problems even
siamba
hali, seems like bea 1.5.0 should be preferred over ibm?
hali
neither
what is the problem?
have you tried ./runInstaller without any java specified? (in $PATH or $JAVA_HOME)
siamba
hali, yes it's native java segfaults
it is described at metalink
hali
on what distro?
siamba
I do not have metalink access, there was a bugfix
hali, the only problem was on ia64 - itanium, so if it works for you on x86 it doesn't mean it should work in my case too
hali
on x86 it works if you run a supported distro
i would guess the segfault is due to glibc problems
spheniscus
is it possible to save an erd from sql developer and import it into sql data modeler? developer seems to be read only but docs say you can save the design??
siamba
there was java problem
hali
you still haven't told us what distro you are trying to use?
gentoo?
siamba
hali, suse sles
hali
did you install the ora prep rpm?
and i would dobule check the certification matrix if you are running SLES11 (which i would recommend against)
         

siamba
hali, I have it installed, I just want to know the right way(tm)
hali
yes, if you don't do it "the right way" you won't be supported by oracle if you have issues
siamba
10gR2 is certified for sles10, but problem is the same
stede
hi .. i have some problem with this delete query - it deltes rows in table "t" too! but it should not! http://pgsql.privatepaste.com/a8d0b8bf60
and no, there aren't cascade delte constraints
mastroDani
weblogic question: i've a problem with some class in my EAR -- there are 2 jars with the same package.Class declaration, one had to overwrite the other and I need to know how I can control the order they get loaded
hali
hm, not sure but you can change the classloder preference with <prefer-application-packages>
Dormir
morning
mastroDani
hali, googling it
hali, oh.. I see.. but that's not exactly what I need... I have 2 jar both in my application with the class. Unluckily this is the way a third party works with overwriting classes.. it used to work on tomcat but it doesn't on weblogic
hali, they both are in the APP-INF/lib directory of my EAR
infl
hi all,how can I startup oracle in windows without " net start OracleService...."
TheBonsai
there should be a service entry in the service list
zomo
start->run->services.msc
infl
mm, if I try " net start OracleService....-Oracle is open, and what about mount,nomount
hali
infl: from sqlplus?
infl
yes
zomo
you eman the service started already ?
hali
infl: for non-open startup mode, just start it from sqlplus from command line
infl
I cant connect to the oracle with sqlplus TNS:protocol adapter error
hali
infl: oratnslistener started?
infl
hali,yes
zomo
tnsping your instanace infl first
hali is that right ?:P
infl
tnsping is ok
oblu
did you have a problems with connecting remotely via SCAN alias?
Franek_Kimono
how are you gentleman!
mastroDani
hali, the problem wasn't with the 2 jars.. I have issue with redeployment.. it doesn't take all my modification when I update the deploy.... is there something to do to make weblogic take ALL the deployment modification? (the last way I found out is to manually remove all the content in the "stage" directory of each server)
sis
hello, how could I select multiple of two values in different rows (and same columns), those id is the same (my table rows: 1,40; 1,22; 2,30; 2,23; I would like to get 1,880; 2,690)
i get a tip on mysql from snoyes: SELECT id, EXP(SUM(LN(quotes.ask))) AS huf FROM quotes GROUP BY id;
but i get ora-01428
this version works, but i need the whole table, not only a specified id: SELECT id, EXP(SUM(LN(quotes.ask))) AS huf FROM quotes where id=68304 GROUP BY id;
mfilipe
hi! what is the problem with this sql http://pastebin.com/d6a408890 ?
it is a simple update sql with relationship using innerjoin
Xgc
sis: SELECT id, MIN(val) * MAX(val) AS result FROM ... GROUP BY id;
sis
Xgc: thank you, i was helped, i had ln(0) in some rows that was the problem
Xgc
sis: This would work without log functions.
sis
now it is SELECT id, EXP(SUM(LN(quotes.ask))) AS huf FROM quotes where ask>0 GROUP BY id;
Xgc: would it be faster without ln?
Xgc
sis: Most likely.
sis
trying, thank you
currently i am stucked with unix_timestamp on oracle
i have a date column as well, and playing with it for 30mins
Xgc: much more faster, thank you!
bruxno`
how to get the reference info of the Procedures?
Any system tables records the procedure referenced infomation ?
RowCol
Hello
is there TIME type in oracle ?
jwendell
hi,folks. I've got a long sql command taking only 50% of my cpu (dual core). How can I raise it to eat all my CPU?
If i run the same command in other session CPU use raises to 100%, each task has 50%
The user is under the default profile, which has unlimited CPU per session
danie2
hello
i have a dmp file of 450mb but when i do a imp show to a file
the ouput is 888k
so what is the content of the 449mb left?
boingolov
so I guess there is no upgrade patch set to get from 11gr1 -> 11gr2 ?
rizzo
no
boingolov
can't seem to find one on metalink and have seen several posts to forums basically saying no, but just wanted to check if there was some new info, or maybe that I'm looking in the wrong place
rizzo
you have to install 11gR2 into it's own ORACLE_HOME
boingolov
yeah
rizzo
just like going from 10gR2
it's more or less a major upgrade
despite still being 11
boingolov
yeah
well, just making sure
oh well, at least they have released for solaris
chuckh1958
Anyone using 10.2.0.5 OEM?
I upgraded OEM from 10.2.0.1 to 10.2.0.5 and am not getting any email alerts. The administrators were subscribed to the alerts prior to the upgrade and GC is still showing them as subscribed but nobody is getting any emails from OEM. Is this a known bug after an ugprade?
Oracle has been very slow in getting back to me on support.oracle.com. 5 days so far with no updates.
boingolov
chuckh1958, I don't use that feature (or OEM in general) but just curious how it's set to send mails? i.e., does it use a local sendmail, smarthost or does it do its own smtp relaying?
chuckh1958
It uses local sendmail. It probably uses the dbms_smtp package.
boingolov
do you get anything interesting when examining the oracle user's mailbox?
in other words, can you verify if messages are getting queued?
chuckh1958
only if "No mail for oracle" is interesting. :)
The test email button works and the admins receive the test email. But emails generated by critical alerts are not being send.
sent
boingolov
ahh
well, outside of possibilities of maybe something changed in the auto generated email format that is triggering a spam filter that wouldn't have before, but failing that I wouldn't know where else to look but OEM
danie2
i did a imp show=y file=file.dmp full=y and got 880k data ouput of a 450mb file
so what is in the 449mb left?
pobrika
Hello,can anyone help me understand a disk issue I have been tasked with. On solaris 9 I am getting scsi erros [ID 107833 kern.notice] This is on a raw SAN disk. I know the SAN is in 4k blocks but I am a little lost on what to do next. PLS Help
sorry that should read64k blocks
boingolov
pobrika, you'd probably be more likely to get more help if you go to a channel specific to your os
what platform?
pobrika
solaris 9
boingolov
what kind of san just out of curiosity?
but yeah, I'd try #solaris
pobrika
Not sure,but we use a Qlogic QLA2462 hba
Ok I'll try the solaris channel, :)
chuckh1958
danie2: the data. IIRC show=y only shows the DDL.
« prev next »