OraFAQ Forum: Server Administration » beginner can't deal with ORA-25160

Home » RDBMS Server » Server Administration » beginner can't deal with ORA-25160

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

beginner can't deal with ORA-25160 [message #482791]

Mon, 15 November 2010 18:59

ssh2010
Messages: 2
Registered: November 2010

Junior Member

Hey, I'm new to this & I tried to solve the error by reading tonnes of forums but I couldn't solve the issue.
So each time I try to mount the database and login as an administrator to open SQLPLUS I get the following error:

C:\>sqlplus
SQL*PLUS release date.... Oracle. ALL rights reserved.
Enter username: system@oracle10 as sysdba
password:.....
ERROR:
ORA-12560: TNS: protocol adapter error

I did as some forums said: oracle_sid=oracle10 &
looked in the listener that the SID is written
I made sure that the oracle.exe is running from services
but still i continue to have this error.

So what can I do else? Thx

Report message to a moderator

Re: beginner can't deal with ORA-25160 [message #482792 is a reply to message #482791]

Mon, 15 November 2010 19:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

1) if you are logged onto the DB Server system, then SQL*net is NOT needed.
2) I surmise that DB Server is running some sort of Windows OS.

There are two OS services, one for database & one for listener, and BOTH need to be running.
open Command window
COPY lines below

SET
listener status
listener service

COPY lines above then PASTE into Command Window
COPY commands & results then PASTE all back here

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: beginner can't deal with ORA-25160 [message #482876 is a reply to message #482792]

Tue, 16 November 2010 09:58

ssh2010
Messages: 2
Registered: November 2010

Junior Member

Hey, thx for the reply. So the results from the commands are:

1)typing "lsnrctl services" or "lsnrctl status" in cmd gives same code"

LSNRCTL for 32-bit Windows : Version 10.2.0.1.0-Production....
Copyright...All rights reserved
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541:TNS: no listener
TNS 12560: TNS PROTOCOL ADAPTER ERROR
TNS 00511: NO LISTENER
32 BIT WINDOWS ERROR:2: NO SUCH FILE OR DIRECTORY
CONNECTING TO (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.30.32.82)(PORT=1521)))
TNS 12560: TNS PROTOCOL ADAPTER ERROR
TNS-00538 MESSAGE 538 NOT FOUND, PRODUCT=NETWORK, FACILITY=TNS
32 BIT WINDOWS ERROR: 65: UNKNOWN ERROR

So am using oracle 10.2 & am working from a VM

Report message to a moderator

Re: beginner can't deal with ORA-25160 [message #482877 is a reply to message #482876]

Tue, 16 November 2010 10:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>So am using oracle 10.2 & am working from a VM
VM complicates proper configuration & installation.

when all else fails, Read The Fine manual

http://download.oracle.com/docs/cd/B19306_01/install.102/b14316/toc.htm

commands run as wrong OS user or OS user environment is not correctly configured

Report message to a moderator

Previous Topic:	user tracing
Next Topic:	Error...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:53:40 CST 2024