• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • paul wheaton
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Tim Holloway
  • Carey Brown
  • salvin francis

Problem to run Oracle9i after installed in Windows2000 professional?

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:
 
ranger
Posts: 17344
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 1179
Mac OS X Eclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hai friends,
Thank you very much for your replys and guidance.
I got it right now.
Thank you once again.
Saran Ram
 
Time is the best teacher, but unfortunately, it kills all of its students - Robin Williams. tiny ad:
professionally read, modify and write PDF files from Java
https://products.aspose.com/pdf/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!