up vote -1 down vote favorite
share [g+] share [fb]

When I run rman target / @mydb nocatalog cmdfile=%commands% msglog=%logfile%, I see connected to target database: OTHERDB (DBID=3786352837, not open).

link|improve this question
50% accept rate
What does your tnsnames file contain? – justarobert Apr 22 '11 at 18:44
It contains details about 3 databases on the machine, including "mydb." – publicRavi Apr 22 '11 at 19:16
Oracle's vendor system including program licensing and certification process is not conducive to its constituents participating in cooperative communities like this one. (I am Oracle certified but chose to walk away from that world.) Could you please expound your question with some more details and let us know if that edit indicates that you solved the problem or is just relevant data? – Caleb Apr 23 '11 at 8:46
@caleb Info in my edit seemed to do the trick. I did not find it in the Interwebs, rather a DBA friend helped me. – publicRavi Apr 23 '11 at 19:16
Someone chose to down-vote the question without explaining why. Weak. IMHO, the question does not need elaboration. Pretty cut & dry. – publicRavi Apr 23 '11 at 19:18
feedback

1 Answer

up vote 0 down vote

Setting environment variable ORACLE_DB to the target database helps the cause.

   Set ORACLE_SID=mydb

StackOverflow and ServerFault seem to suffer from lack of Oracle expertise. Weak.

link|improve this answer
1  
You should probably change "helps the cause" to "fixes the problem" to be clear. The first really doesn't indicate that this is the right solution. Also if you think SO/SF are weak in this area how about sticking around and answering some people's questions! – Caleb Apr 23 '11 at 19:24
@caleb Please. My statement was a sincere observation after posting about 4 Oracle related questions, without getting relevant hints/answers. Again, I am no Oracle expert to help others. – publicRavi Apr 23 '11 at 19:55
as far as I can tell, unfortunately Oracle DBA's and developers all seem to have their own cliques and communites that they hang out in, and it's difficult to leverage them out of there. It's certainly somewhere that we could try to target for new users though. – Mark Henderson♦ Apr 23 '11 at 21:07
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.