Problem to run Oracle9i after installed in Windows2000 professional?

[Thakur Rai]

Hi fellows,
I have problem to run Oracle9i after installed in Windows2000 professional?
when login as
user: scott
pass: tiger
then, it gives me error message.
" ORA-12560: TNS: Protocol adapter error "
I could not figure out what does that means?
Do I need to configure something else after installation?
Thanks
:roll: :roll:

[Mark Spritzler]

Not much here but quoted from Oracle

Oracle Product Document Library (C) Oracle Corporation
Manual: Database Error Reference: A90202-02

ORA-12560 TNS rotocol adapter error
Cause: A generic protocol adapter error occurred.
Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors.For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete.

Have you started the Listener? check in the services to make sure you have your listener running and your instance is also running.
And finally that your tnsnames.ora file is properly filled out.
Good Luck
Mark

[Thakur Rai]

Hi all,
My problem was Hard dirve space, RAM and Virtual memory size.
I guess, you must have at least 20GB harddrive, 128MB RAM or Above.
Virtual memory will do read/write process.
If you using Win2000, to change Virtual memory.....
(1) Right click on "My computer"
(2) Click on "System properties"
(3) Click on "Advanced" folder
(4) click on Performance option
(5) go to Frame "virtual memory"
(6) Click on "Change"
(7) Select "Drive"
(8) Set "Maximum size"
(9) Click on "Set"
Good luck

[saran ram]

hai,
i too getting the same short of error after installing Oracle8i in windows2000 server.
ERROR:
ORA-12560: TNS rotocol adapter error
ORA-12514: TNS:listener could not resolve SERVICE_NAME
I have seen the reply for the error as follows:
"Have you started the Listener? check in the services to make sure you have your listener running and your instance is also running.
And finally that your tnsnames.ora file is properly filled out."
As i'm not much familiar with this,
will u please guide me how to do all these things?
thanks in advance,
saran ram.

[girish rateshwar]

Hi saran,
Hope this helps:
.....
To start with the listener.
*Go to the control panel-->>Select the services.
*You will find a listener with the SID.
Now for the tnsnames.ora.
Go to the ORACLE_HOME ,look for <dir>net80--->><sub dir>ADMIN
OR
ORACLE_HOME\ora92\network\admin\tnsnames.ora

and chec if the names server is configured properly.

Regards,

[saran ram]

hai girish,
Thank you for your kind reply.
As you told I gone through the following.
But still I don't know how to sort out the problem.
I have given the files of my Oracle8i.
please go through it and tell me where lies the problem.
To start with the listener.
*Go to the control panel-->>Administrative services-->>Select the services.
*You will find a listener with the SID. "
I found 3 Oracle related services:
OracleOraHome81ClientCache
OracleOraHome81TNSListener
OracleLWebAssistant0
I think the OracleOraHome81TNSListener is the listener.
I have given the tnsnames.ora file in
ORACLE_HOME\ora92\network\admin\tnsnames.ora below:
TNSNAMES.ORA
=============
# C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:C:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant
BUDDHAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = localhost))
)
(CONNECT_DATA =
(SERVICE_NAME = LISTENER)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = localhost))
)
(CONNECT_DATA =
(SERVICE_NAME = LISTENER.ORA)
)
)

My Listener.ora file in the same directory looks as follows:
LISTENER.ORA
============
# C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:C:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle Net8 Assistant
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = saran)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = saran)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle\Ora81)
(PROGRAM = extproc)
)
)

"and chec if the names server is configured properly. "
Help me in checking this too.
And What name I have to type in the Host String when logging in?
regards,
saran ram.

[Rene Larsen]

You don't have any database on your system...
You need to make one, by using the 'Start Menu->Programs->Oracle - OraHome81->Database Administration->Database Configuration Assistant'
Rene

[girish rateshwar]

hi,
BUDDHAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = localhost))
)
(CONNECT_DATA =
(SERVICE_NAME = LISTENER)
)
)
well once u configure the database using the database configuration assistant. u can manually add the entry to tnsnames.ora
DB Name =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = localhost))
)
(CONNECT_DATA =
(SERVICE_NAME = LISTENER)
)
)
well DB Name can be replaced by the SID.
Note****** By default the listener name is 'LISTENER'------>>Go with it!
Hope it helps.

[saran ram]

hai friends,
Thank you very much for your replys and guidance.
I got it right now.
Thank you once again.
Saran Ram