Have you resolved this? Can you login to sqlplus as sysdba?
Since it's only the network connected servers, it may be that a GPO was applied which changed what the oracle dba group administrators have been granted.
I would suggest the following:
automate the list that you gave of normal routine, email yourself the results (if you don't do that already.)
if your company doesn't have a 'play machine', insist on one, and start practicing - standby databases, scenarios for failures, rman, etc.
join OTN...
Typically (even when spelled correctly) you don't include the bin in the home...
ORALCE_HOME=/appl/oracle/10.1.0/bin; export ORACLE_HOME
should be
ORACLE_HOME=/appl/oracle/10.1.0; export ORACLE_HOME
Of course I'm familiar with Tom's montra. He also offers great advice on many things, including bulk collect:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3561337894959 (sorry, don't have access to tiny url from work.)
It wasn't 'my' proscribed solution, as it was a...
You haven't been paying attention in class, have you?
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch3.htm#sthref712
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements008.htm#sthref722
http://ORA-00955.ora-code.com/
Crystal ball says you need to...
Since I've got Santa rolling on the floor laughing, here's a couple more:
Parasiting
I'm in a position I said I could do
But haven't experience to back what I knew
So I post in the forum - my defacto mentor
Brain dump your knowledge to this genus stentor
I need it right now, it's an URGENT...
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen003.htm#BRADV224
I've never tried it. Let us know how you make out, and what the steps were that you did. Thanks.
Good luck.
Newbies
I'm Under the gun to get things done
so let me just ask a guru.
They've worked more years than I've been alive,
no need for me... to even give it a try.
I'll just post my assignment, kick back and wait,
for them to reply, with an answer that's great.
I'll take the credit as...
Here is info on import (impdb - can't be used when exp created the dump file.)
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2292
http://download.oracle.com/docs/cd/B19306_01/win.102/b14304/create.htm#sthref188
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.