logs archiveIRC Archive / Freenode / #oracle / 2010 / March / 30 / 1
spcshpopr8r
I'm running rootpre.sh prior to an 11g installation on an AIX box that has databases running in a couple of 10g homes (two enterprise eds at different patchset levels and a standard ed), while the databases are running I get output like this http://pastie.org/private/bka0v7umj1fp80nafp9fa but when the databases are down the script runs successfully. Is there something I can do to get that script to run successfully while the databases
are running?
glaksmono
anyone here?
what's wrong with this query? SELECT r.restaurant.location FROM restaurants2 r WHERE SDO_NN(r.restaurant.location, SDO_POINT_TYPE(174,195,0), 'sdo_num_res=2') = 'TRUE'
anyone here?
:(
Junior
yello ;)
KeiKurono
morning
balek
hi i have a problem i use oracle xe and i have this error : ORA-12952: The request exceeds the maximum allowed database size of 4 GB is it normal can i modify the size please
DiscordianUK
There limitations on Oracle XE and one of those is that the maximum database size is 4Gb
So in short no
balek
there are not possible to modify this or other to solve this problem :( ?
DiscordianUK
Pay Oracle to upgrade?
balek
DiscordianUK : i have already pay oracle for oracle database but i have a small software i don't want to pay a licence for this software
         

DiscordianUK
The 4gb limit is part of the reason that Oracle lets you have Oracle XE for free
balek
DiscordianUK : ok it's small size :( thanks for your help
usn_work
good mornoon
RJarett
howdy
balek
hi i have a question please i install rac oracle i try now to create vip network oracle by vipca tool but when i try i have this error :CRS-1006: No more members to consider CRS-0215: Could not start resource i don't know why it can't create the vip thanks for your help
[ default][2540]proa_init: Could not get user id, slos 1234
[ OCRUTL][2540]u_set_ocr_error: Parameter was NULL
thanks for your help
usn_work
balek, please provide the link to the paper you followed
balek
usn_work : i use this documentation http://www.oracle-base.com/articles/10g/OracleDB10gR2RACInstallationOnWindows2003UsingVMware.php on the step run the VIPCA manually thanks for your help
usn_work : but my problem is vipca not work correctly with errors error :CRS-1006: No more members to consider CRS-0215: Could not ...
usn_work
mh, 10g RAC
does ssh passwordless auth work between your cluster nodes?
and can you login from node1 to node1 without a ssh password?
and can you login from node2 to node2 without a ssh password?
and without a key acceptance challenge?
balek
usn_work: i can login from node1 to node2 and node2 to node1 with no problem
usn_work
Why don't you answer my questions? :)
they are meant literally
balek
usn_work : i use windows not linux i can't use ssh :)
usn_work
ah, ok :)
RJarett
why would you rac on windows?
usn_work
sorry, never used RAC on Windoze, and also have no test system
balek
usn_work : it's not my decision i must create a rac on windows :)
usn_work
RJarett, why using windows at all except on the DAU desktop?
balek
usn_work : but my problem is the oracle configuration not a windows or linux
usn_work
RAC is heavily connected to the OS config
especially installer trouble is OS dependent
balek
usn_work : yes but if you have idea why vipca can't work and if i can check config oracle where it have problem
usn_work
I told you my first guess
anything else should come from the vipca logfile
it tells you its location, or look in oracle home/configtoollogs or something similar
         

balek
i see that now
usn_work : i search on the file vipca on the directory configtoollogs but i have not error message i search where i can found the error message thansk for your help
usn_work
please pastebin the vipca log
balek
usn_work : you can see on http://pastebin.com/kVhrgcgH thanks
usn_work
does the clusterware run now?
please paste crs_stat -t -v
balek
usn_work : you can see on http://pastebin.com/cJU1fvSP
usn_work
I can't see the cause of the malfunctioning vipca, but at this stage you can delete/add VIPs by yourself as well
But, a quick idea
did you maybe retry creating the cluster?
want to say, it could be a cleanup issue
balek
usn_work : i not retry creating cluster
but you think the best solution is to delete vipca configuration and recreate this ?
usn_work
I never did it on windows, I don't even know how VIPs are created there. But crs_* tools should be available there as well
but now I'm out, Windows is a bad choice for RAC, and I really don't know much about it.
balek
but can i delete and create the vipca with oracle tools because (there are the same tools on the windows and linux oracle i think) .
usn_work
crs_*
balek
ok i see how with crs_* tools i can do that thanks for your help
usn_work
np
balek
usn_work : i delete the vipca with srvctl configuration and i recreate but i have the same problem perhaps it's a hostname problem
usn_work: now it work very very thanks
usn_work
no problem, you're welcome
sinesio
hi guys, I want to install Oracle standalone server but with ASM
what do I need to do to have ASM diskgroups
do I need to install grid infrastructure?
RJarett
why do you want asm?
avaia
yes, just like I told you last time
RJarett
you dont need grid or anything for asm
sinesio
because i'm running a RAC on the other side of dataguard
RJarett
ahh you are that guy
avaia
11gr2, right?
sinesio
thsi standalone server is the standby DB
yes
look I don't want to install RAC just because.....
I need to install RAC because the company want to
RJarett
then tell them to hire someone to do it
sinesio
I know how you feel about RAC
and belive me I don't like it either
ohh come on
RAC is installed... the problem is now I have to prepare my standalone server with ASM
can someone at least tell me what do I need?
RJarett
dude, theres a whole wizard thatll help you
all you need to do is have individual scsi luns you can use as raw
sinesio
and what would that wizard be?? The Oracle DB installation wizard?
don't need anything else to create the ASM disk groups?
RJarett
depends on the os
sometimes littlehelper drivers and apps need to be installed
sinesio
Solaris 10
RJarett
which is clearly marked out on the install guide
sinesio
yes... but I found several installation guides and none for the scenario I want. Probably because 11gR2 is new
RJarett
you really shouldnt be using it if you cant infer the differences
or you cant find oracle 11gR2 docs
sinesio
if I search for installing a standalone server using ASM I always end up in the Grid infrastructure guides
avaia
...
sinesio
the other day someone here told me that we all start with knowledge 0
RJarett
But some people learn to read.
sinesio
ok...very nice
thanks a lot for your help
avaia
seriously, the install guide will tell you to install grid infrastructure
sinesio
<RJarett> you dont need grid or anything for asm
avaia
not in earlier versions, no
in 11.2 you do
sinesio
but for 11gR2 I do need it, right?
ok... so aparentelly I can read
thats not all my fault
avaia: can you point me to that installation guide please
is it this one : http://www.oracle.com/technology/obe/11gr2_db_prod/install/gridinstss/gridinstss.htm
krz
hi
hi anything wrong with this design: http://imagebin.org/90883 basically tbl_ad is 1:1 with tbl_housing, tbl_housing_amenity is an M:M table
wapp
hi, do you know some query to count de connection/desconection of a user to a database?
TheBonsai
setup a logon/logoff triggrt and fill a table
wapp
can you tell me how to do it or where can i get this trigger please?
is anybody here?
cmug
test
http://infolab.stanford.edu/~ullman/fcdb/oracle/or-triggers.html#basic%20trigger%20syntax
« prev next »