Can't connect to DB

[DaPi]

Originally posted by pascal01
I'm getting an ORA-12560 TNS PROTOCOL ADAPTER ERROR.

That's the one you get if the service ain't running.

I'm getting tired (well past going home time): forget connecting as sys, use internal or just / I skrewed up there.

[marist89]

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.

I'm guessing something is not setup correctly.

Since this is Windoz, you might try rebooting a dozen times or so

gee, I love unix....

[stecal]

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.

[DaPi]

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")

[marist89]

Try

rm -rf /home/users/DaPi > /dev/null 2>&1 &

[pascal01]

Hi. I have a service called "OracleSericeAODB5" and my ORACLE_SID=AODB5. Keep getting this ORA-12560 error. Is it a registry problem maybe?

[stecal]

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.

[DaPi]

Originally posted by marist89
rm -rf /home/users/DaPi > /dev/null 2>&1 &

Since we are discussing an NT prob, Jeff should have explained this - I will do my best (my comments are in parentheses):

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

[hrishy]

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

[abhaysk]

Originally posted by pascal01
Is it a registry problem maybe?

Should u have a doubt u shud try it...

try setting the value for ORACLE_SID in the reg path

HKEY_LOCAL_MACHINE\SOFTWARE\%ORACLE_BASE%\%Oracle_HOME%....


Abhay.