Ask the Expert

Resolving ORA-12560 error

I've just installed Oracle 8.1.7. onto Solaris 8. The installation itself was uneventful, but I cannot use it: issuing the command svrmgrl causes the error message "ORA-12560: TNS:procol adqpter error" whilst trying to start the listener and causes the following garbage on the screen:
$ lsnrctl start
lsnrctl: ^?ELF^B^B^A^B+^A^A237: not found
lsnrctl: ^A=^A: cannot open
lsnrctl: ^Aa^Ab^Ac^Ad^Ag^Ah^Ai^Aj^Ak^Al^Am^An^Ap^Aq^Ar^As^Av^Ax^A{^A}
^A~^A200^A201^A203^A204^A206^A207^A210^A211^A212^A214^A216^A220^A222^
A224^A225^A226^A232^A234^A235^A237^A?^A^A?^A?^A?^A?^A?^A?^A?^A?^A?^
A?^A?^A?^A?^A?^A?^A?^A?A?ASA?A?A?A?A?A?A?A?A?A?A?A?
A?A???????????^A?^A?^A?^A?^A?^A?^A?^A?^A?^B^B^
A^B^C^B^D^B^E^B^F^B^G^B^H^B: not found
Your help will be greatly appreciated.

    Requires Free Membership to View

Do you have your ORACLE_SID, ORACLE_HOME and other environment variables set correctly? Do you have a listener.ora file and if so, is it accessible by the current path?

It sounds to me something like that is going on. It can't find something or perhaps you're not logged in as the "oracle" user and the user you're logged in as doesn't have the proper permissions to execute the lsnrctl.

For More Information


This was first published in May 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: