aspose file tools*
The moose likes Oracle/OAS and the fly likes Problem to run Oracle9i after installed in Windows2000 professional? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Problem to run Oracle9i after installed in Windows2000 professional?" Watch "Problem to run Oracle9i after installed in Windows2000 professional?" New topic
Author

Problem to run Oracle9i after installed in Windows2000 professional?

Thakur Rai
Greenhorn

Joined: Dec 03, 2002
Posts: 3
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
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17259
    
    6

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


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Thakur Rai
Greenhorn

Joined: Dec 03, 2002
Posts: 3
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
Ranch Hand

Joined: Dec 13, 2002
Posts: 69
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
Ranch Hand

Joined: Mar 04, 2001
Posts: 99
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,


Girish
saran ram
Ranch Hand

Joined: Dec 13, 2002
Posts: 69
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
Ranch Hand

Joined: Oct 12, 2001
Posts: 1179

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


Regards, Rene Larsen
Dropbox Invite
girish rateshwar
Ranch Hand

Joined: Mar 04, 2001
Posts: 99
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
Ranch Hand

Joined: Dec 13, 2002
Posts: 69
hai friends,
Thank you very much for your replys and guidance.
I got it right now.
Thank you once again.
Saran Ram
 
jQuery in Action, 2nd edition
 
subject: Problem to run Oracle9i after installed in Windows2000 professional?