logs archiveIRC Archive / Freenode / #oracle / 2009 / November / 24 / 1
gloin
Hi all, am trying to duplicate a DB per doc here, question in next line: http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmdupdb.htm
problem is a paradox: If I start up the aux db nomount (as must happen with no controlfile), then the listener is BLOCKED
but I can't connet to a blocked listener through rman
I've tried connecting from the host with the aux instance on it and using "CONNECT AUXILIARY /" but then I get RMAN 06217
Dormir
you can use duplicate without a catalog
Rudemeister:
gloin: should work
gloin
gah, found a typo
in the SID_LIST_SIDNAME entry
listener was barfing on no such file
nevermind :)
luisgrin
hi, i need to install php connection i have xampp wnodows xp, some advice?
_tulio_123
please someone help with the oracle data modeler tool
i am trying to create sequences in it but I cant find any option for that
have anyone here used the oracle data modeler?
where can i find a tutorial about how to install oracle designer 10r2?
is anyone alive in here?
Junior
yello ;)
TheBonsai
m00
sis
if mycol is null then 2nd query does not give that row, so i need to use 1st query, but why? 1) select .... where mycol !=1 or mycol is null 2) select .... where mycol !=1
nvm i get the answer on sql channel
wsy
which room does people talking about Oracle internals?
         

TheBonsai
internals as in OERI?
:)
Pikshik
ick ick
phimic
hi all
hi hali
i try to install Oracle-RAC on ESX and have a problem with runcluvfy.sh http://pastebin.com/d3d9b6314
before i install clusterware i have to set ORACLE_HOME=/opt/oracle/10.2/crs
and when i install the database i set the ORACLE_HOME=/opt/oracle/10.2/dbhome
is this correct?
Farzy
hi
phimic
i have a problem installing crs
at the end of the installation process i get the error
unning vipca(silent) for configuring nodeapps
/opt/oracle/product/10.2/crs/jdk/jre//bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
OS is SLES-10-SP3 and Oracle -RAC 10.2.0.1
Farzy
I have a question on installing Oracle 10g data on NFS: all data diks will be on a fast local NetApp NFS server, but is it feasible, and reasonnable, to put the "fast recovery area", including Archive Logs and RMAN backups on a "slow", distant NFS server?
phimic
i can remember it has something to do with the LD_ASSUME_KERNEL env variable
hali
anyone looked in to oracle numa mode on rhel5?
not sure if it is a bug but oracle doesn't seem to find libnuma unless i symlink it
aae
hali: i am trying to install Oracle in ubuntu but in the installation he told me there are some package are missing; i install some of them but still displaying thus packages.
what should i do ??
Franek_Kimono
hello
how can i restore database dump? i tried to use `imp` tool, seemed to be fine, but i cannot see restored data anywhere :/
mfilipe
Hi! I'm with a problem. See this http://pastebin.com/d7d6c5e20 . What is the problem? I don't know Oracle, but I have experience with MySQL and PostgreeSQL
qnix
mfilipe: a insert with a where ?
should be ok
maybe where (numoriginal='326012146');
TheBonsai
update....?
qnix
that's what I thought.. but it seems that form is ok too... never use it personnally
mfilipe
yeah... I only received this in my e-mail to solve... I never see this too.
qnix
*shrug*
TheBonsai
qnix: and what would be the meaning of it, if it was okay? i mean an insert with a hwere
qnix
I've absolutely no idea and I do not plan to use it a day.
TheBonsai
heh :)
mfilipe
thanks :)
         

phimic
i got a big problem, i installed clusterware 10.2.0.1 succesfully and would like to install the database now
after the installer begins the installation my 1st node reboots
i can find this in /var/log/messages:
sd reservation conflict, I/O error dev sdc sector 49, Oracle CSSD failure, Rebooting for cluster integrity
/dev/sdc is my voting disk :(
mator
phimic, /dev/sdc is available on both nodes ?
phimic
mator: yes available on both nodes
mator: perm for all /dev/raw/raw* are crw-rw------- oracle:dba
puuck
how is sdc being presented to both servers?
mator
phimic, i think that after the first node is installed (and locked its reservation disks - set reservation on /dev/sdc), all other installed nodes should be added to cluster as addition nodes, not as primary first one... if you understand me :)
phimic
mator: not really :)
anz4rt
hello
mator
phimic, how do you added (started installation) on the second node of clusterware ?
using oracle universal installed, after the "Product-Specific Prerequisite Checks" stage, you should choose "Add a new node to the existing cluster" dialog window
phimic, http://download.oracle.com/docs/cd/B28359_01/rac.111/b28252/install_rac.htm
phimic
mator: clusterware installation was on both nodes
mator
if your first node is running in cluster mode, as i said, all other nodes should be added to cluster, not installed separately
if your first node taken reservation on voting disk, after installation of second node (by not adding to existing node1 RAC configuration) it will try to lock reservation region on the voting disks, and it succeed, then the first node could discover reservation conflict and reboot
sorry for my bad english
phimic
mator: i did not install clusterware separately, i started the installer on the 1st node an it installed clusterware on both nodes
mator: me also :)
mator
phimic, is there was a window like http://download.oracle.com/docs/cd/B28359_01/rac.111/b28252/img/install003.gif when you installed second (node2) node?
phimic
crsctl check crs returns on both nodes
CSS appears healthy, CRS appears healthy, EVM appears healthy
puuck
what about cluvfy?
phimic
puuck: result has no errors i check runcluvfy.sh comp nodecon -n node01,node02 -verbose
puuck
is sdc a physical disk?
and how about cluvfy comp ssa -n node01,node02 -verbose?
phimic
puuck: sdc is a shared raw device
puuck: output of cluvfy http://pastebin.com/d15826084
puuck
is it a VM?
phimic
puuck: yes VMware ESX 3.5U4
puuck
check out this thread...http://communities.vmware.com/thread/164967
phimic
puuck: thank you for the link, what does it mean "moved vdisks from VMFS to RDM" ?
puuck
RDMs are basically presenting a LUN directly to the VM instead of having the raw disk be a VMFS file
phimic
puuck: ok i got it raw device mapping, is not possible for me because we have no more free luns :(
ok this is not possible in our setup because we have no more free luns
mator
phimic, why you can't just set configuration to rdm disks, i don't get it ?
phimic
mator: all space are allocated to luns on our storage, no more space left to create new luns
mator
phimic, can't you simply change "disk configuration option" in vmware ?
from vmfs to rdm? or you need to destroy old lun allocation of vmfs type and create new with rdm type?
phimic
mator: cannot destroy an lun because we are out of space, it is not possible to do a storage vmotion
mator
i can't help, since i don't have vmware, but only interesting in the solution
:-/
unlucky
puuck
i don't have an ESX server to play around on...if you look at the config file for the two servers do they have "disk.locking="false" ?
phimic
puuck: i will check
puuck: this option was missing i will try now with disk.locking=false
puuck
cool, let me know how it goes
phimic
puuck: not sure if it works crs come not up on firs node now
all raw partitions are ok and avail
crsctl check crs returns, Failure 1 contacting CSS daemon, Cannot communicate with CRS, Cannot communicate with EVM
on second node all is ok
seems not to work 2nd did a reset again
puuck
is this for a production cluster?
phimic
puuck: no it is a test-cluster to simulate a rolling upgrade from 10.2.0.3 to 10.2.0.4
puuck
you could try using OCFS instead of raw
phimic
yes thats right but if i upgrade from 10.2.0.3 -> 10.2.0.4 on our productive cluster ASM will be upgraded as well?
puuck
i don't think patchsets are rolling, though, since they touch the data dictionary
phimic
puuck: so it is not possible to upgrade a rac without downtime?
puuck
you can upgrade CRS, and some patches are just for binaries so those can be rolling
but patchsets usually include dictionary updates as well
phimic
puuck: ok good to know
Dormir
you could clone your home on each node, update it to 10.2.0.4, then your down time would be for only the upgrade script
phimic
Dormir: thanks for the info
puuck: thanks for your help, i will try to fix my problem tomorrow, it is time go now :)
puuck
np
phimic
see you later, bye
snipe_
hey
Rudemeister
Dormir: true, an option would be to mount instance local and duplicate it there through sql*net
azi_
i would like to download and install oracle XE: http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html
the problem is that the browser runs a popup asking me for my password
the same popup appairs if i click on "create new account" asking me for a password I obviously don't have yet
any clue what should I do in order to get a oracle DB installeD?
interesting.. the problem only happens in opera
Egyptian[laptop]
evening all
l3thal
Egyptian[Home]: not all :P
Egyptian[laptop]
i m trying to install oracle rag 10g 10.2.0.1 on centos 5.4 and i always fail at vipca with Error 0(Native: listNetInterfaces:[3])
..
help
64bit
TheBonsai
use a current 10.2
10.2.0.4, latest patchset (#4 iirc)
Egyptian[laptop]
TheBonsai: the oracle download page only has 10.2.0.1
TheBonsai: 10.2.0.4 isnt that windows?
puuck
the base installer for linux is 10.2.0.1, and then you apply patches up to 10.2.0.4
TheBonsai
isn't there a 10.2.0.3 install set?
Egyptian[laptop]
so vipca is doing what?
puuck
egyptian: are you still in the installation phase?
Egyptian[laptop]
yes .. i have gotten very good at erasing oracle rac installs :(
and yes the oui is still open
successfully completed on node1 but not on node2 ..whcih is what i read on the net
puuck
what does "oifcfg getif" say
Egyptian[laptop]
on both nodes.. nothing
[root@node01 bin]# ./oifcfg iflist
eth0 192.168.122.0
eth1 10.10.10.0
puuck
what about "ocrcheck"
Egyptian[laptop]
Cluster registry integrity check succeeded
puuck
it is odd that the installer would run vipca without public/private interfaces set
Egyptian[laptop]
(Action) shrugs
puuck
did you get other errors earlier in the install?
Egyptian[laptop]
none that i saw
puuck: i also used oifcfg to set public and private nets on node2 but if i do that vipca fails with a message about main
puuck
do you have a metalink account?
Egyptian[laptop]
nyet
i m not a dba -- they keep the metalink accounts to themselves at my place of work ;)
puuck
google for "414163.1"
Egyptian[laptop]
puuck: done that..the solution dint work
vipca failure in main is my result
woops ..gotten mixed up .. Error 0(Native: listNetInterfaces:[3]) is AFTER unsetting LD_ASSUME_KERNEL ... failure in main is if i try to set public and interconnect interfaces
puuck
it just says "failure in main"?
Egyptian[laptop]
almost .. i can recreate the error if you need to get the exact message
puuck
sure
Egyptian[laptop]
sigh .. hokay :(
Exception in thread "main"
puuck:
puuck
that isn't terribly descriptive, is it
that is when you try to run oifcfg setif ?
Egyptian[laptop]
duh!
lend me a hammer willya?
sigh .. i went from my pc to node01 to root@node02
which is a no no for Xwindows forwarding in ssh
i found the answer in vipca.log from
puuck: thanks for your patience with me
puuck
sure...glad you got it figured out :)
Egyptian[laptop]
i cant believe it .. after 6 days ..clusterware is isntalled!!!!
l3thal
lol
puuck
now patch it and install a db
Egyptian[laptop]
:(
cluvfy for the db failed on vip .. even tho its THERE!!!!!
and i dont have the patches
will let the dba's worry about that after i have my poc rac up and running
ftp://updates.oracle.com/ .. is down btw
« prev next »