Printable View
Hi. I changed the IP address and name of my server. I changed the listener.ora and tnsnames.ora file and changed the host name. I keep getting the following errors. ORA-01034: ORACLE not available and
ORA-27101: shared memory realm does not exist.
The TNSPING command works. Please help. Thank you.
This smells like NT - if so, is the OracleServiceSID service running?
Yes its on NT and the service is up.
Forget my last post.
I get this on a client machine when the db hasn't been started.
Don't be coy! Where are you trying to connect from? If not the server, can you do any thing directly on the server? etc etcQuote:
Originally posted by pascal01
Yes its on NT and the service is up.
Hi, I get the same error when trying to connect on a client and server. However I am working on the server. I checked the ORACLE_HOME and ORACLE_SID variables and they seem OK. I tried restarting the listener and db service... keep getting the same error.
I get this error if the db is not started (is yours autostart?) and I try to connect with svrmgrl or sqlplus on the server with a user id with "insufficient" priviledges. Using sys or internal works.
(I have no idea what "insufficient" is in this context).
check your system regeditQuote:
Originally posted by pascal01
Hi, I get the same error when trying to connect on a client and server. However I am working on the server. I checked the ORACLE_HOME and ORACLE_SID variables and they seem OK. I tried restarting the listener and db service... keep getting the same error.
ORACLE
ORA_WINORA_AUTOSTART IS TRUE ?
if it is false change to true ,restarting db service ~~~
I'd recommend sorting this prob before starting to hack the registry . . . . let's have the probs one at a time :)
If you don't like autostart (I don't) then connect with sys or internal and "startup pfile= . . . . . . "
Hi. I can't use svrmgrl anymore. I'm getting an ORA-12560 TNS PROTOCOL ADAPTER ERROR. The ORACLE_HOME, ORACLE_SID, ORACLE_PATH are all set correctly. The listener and service is started. Looks like something screwy is going on. Please help thanks.
That's the one you get if the service ain't running.Quote:
Originally posted by pascal01
I'm getting an ORA-12560 TNS PROTOCOL ADAPTER ERROR.
I'm getting tired (well past going home time): forget connecting as sys, use internal or just / I skrewed up there.
I'm guessing something is not setup correctly.Quote:
Originally posted by pascal01
Hi. I can't use svrmgrl anymore. I'm getting an ORA-12560 TNS PROTOCOL ADAPTER ERROR. The ORACLE_HOME, ORACLE_SID, ORACLE_PATH are all set correctly. The listener and service is started. Looks like something screwy is going on. Please help thanks.
Since this is Windoz, you might try rebooting a dozen times or so ;)
gee, I love unix....
Windows? Did someone say Windows? Try rebooting.
Company policy doesn't allow me to stay on the phone while your system is rebooting, so please call back when your PC has finished rebooting.
In the command prompt/MS-DOS window, what does echo %ORACLE_SID% return? If not the database you want to connect to, try (well, not "try" - there is only "do" or "do not") setting ORACLE_SID, then fire up svrmgrl.
TNS-12560 very, very common when less-than-manly-almost-woman-or-elf-like users haven't set the environment variable correctly the way he-man-studly UNIX users do and can.
Oh shut up you two! You're jealous that UNIX doesn't have one solution that fits all problems.
Pascal, Steven does have a point:
if you set ORACLE_SID=FRED then OracleServiceFRED must be running . . . otherwise the ORA-12560 when you try to run svrmgrl. Typing errors in ORACLE_SID are probably a major cause of this.
(UNIX people don't have trouble with typos - all possible 2-4 char combinations are valid commands - the question is what do they do? - if I remember correctly rm="restore and mount database")
Try
Code:rm -rf /home/users/DaPi > /dev/null 2>&1 &
Hi. I have a service called "OracleSericeAODB5" and my ORACLE_SID=AODB5. Keep getting this ORA-12560 error. Is it a registry problem maybe?
In an MS-DOS window, set ORACLE_SID to the name of the service/database you want to connect to. You can set an environment variable via My Computer>right click>Properties>Environment with Variable = ORACLE_SID and Value = AODB5. If you do that, then whenever you invoke an MS-DOS window, ORACLE_SID will be set to AODB5. Otherwise, do a set ORACLE_SID=dbname at the command prompt.
Since we are discussing an NT prob, Jeff should have explained this - I will do my best (my comments are in parentheses):Quote:
Originally posted by marist89
rm -rf /home/users/DaPi > /dev/null 2>&1 &
rm = restore and mount database (self-evident)
-rf = do not recover and perform full backup (UNIX commands are so powerful you must specify what they should NOT do, options to be excluded are prefixed with a minus sign)
/home/users/DaPi = location of database (this is an extreme example, UNIX people usually can not type such long character strings)
> = is better than (thes are called "pipe" symbols, this refers to the smoking habits of the early UNIX gurus while debating the relative merits of the methods that these symbols are applied to - other examples: << = much worse than, | = pretty much the same as)
/dev/null = extremely stupid developer (search for "Mr.Hanky" on this site for further details on dealing with this)
2>&1 = two is better than and-one (this notation is taken from that of musical rythmn and is used to synchronise processes running concurrently - this example gives two possibilites and indicates a preference for jazz)
& = and . . . (a real UNIX speciality! this open-ended parameter allows the operating system to use spare machine cycles for other purposes, details depends on OS parameters defined during kernel compilation - garbage collection and ordering pizza are typical)
HTH
Hi Dapi
I have a interview comming up..so now i know how to backup thatnks for the explanation of rm -rf ...i will use this as an answer for backup and recovery.
regards
Hrishy
Should u have a doubt u shud try it...Quote:
Originally posted by pascal01
Is it a registry problem maybe?
try setting the value for ORACLE_SID in the reg path
HKEY_LOCAL_MACHINE\SOFTWARE\%ORACLE_BASE%\%Oracle_HOME%....
Abhay.
Hi, I took the easy way out and deleted and recreated the service using the ORADIM80 - DELETE -SID <> command. Everything is OK now.
Thanks for all your help. Cheers.