Oracle 10g database creation problem [message #557183] |
Sun, 10 June 2012 09:04 |
ncmm
Messages: 11 Registered: May 2012 Location: UAE
|
Junior Member |
|
|
Hi Leaders,
For the last few days, I am totally stuck with oracle database creation. I have Windows 2008 (64 bit) domain server. I tried to install oracle 10g (10.2.4) on this and everything works fine, but throws error while creating database using database configuration assistant. ORA-12560 TNS:PROTOCOL adapter error. I tried several ways but no use. I have been using another PC installed Windows 2008 server 64 bit which is running Oracle 10g(the same version) without any problem. Only the difference is that it is configured as a work group. I need to change that machine since it is a normal PC and reinstall everything to a higher capacity server machine.
How to solve this issue. Please help me experts.
Thank you,
Abdul
|
|
|
|
|
Re: Oracle 10g database creation problem [message #557188 is a reply to message #557183] |
Sun, 10 June 2012 12:51 |
John Watson
Messages: 8960 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I have had many problems of this kind, caused by Windows security. Domains and workgroups are different. Are you sure your user ID is allowed to open TCP ports? You can test by starting a database listener, from the command line, like this:c:\users\john\home>
c:\users\john\home>where lsnrctl.exe
c:\app\john\product\11.2.0\dbhome_1\BIN\LSNRCTL.EXE
c:\users\john\home>lsnrctl start listener
LSNRCTL for 32-bit Windows: Version 11.2.0.3.0 - Production on 10-JUN-2012 18:50:10
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 11.2.0.3.0 - Production
System parameter file is C:\app\john\product\11.2.0\dbhome_1\network\admin\listener.ora
Log messages written to C:\app\john\diag\tnslsnr\jwdell\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jwdell.bplc.co.za)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias listener
Version TNSLSNR for 32-bit Windows: Version 11.2.0.3.0 - Production
Start Date 10-JUN-2012 18:50:14
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\john\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File C:\app\john\diag\tnslsnr\jwdell\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jwdell.bplc.co.za)(PORT=1521)))
The listener supports no services
The command completed successfully
c:\users\john\home>
|
|
|
Re: Oracle 10g database creation problem [message #557223 is a reply to message #557186] |
Mon, 11 June 2012 02:46 |
ncmm
Messages: 11 Registered: May 2012 Location: UAE
|
Junior Member |
|
|
Thank you Michel,
I tried database creation manually. Disabled windows firewall. Tried setting oracle_sid to host name at environment variable.(got from google where somebody recommended this way). nothing is working. I know this is something with windows security issue since the same version is working with windows 2008 server as work group. I can ping tnsnames. no problem. I can ping the host machine itself. no problem. But while creating database, when it is finished 2% error throws. ORA-12560 TNS: protocol adapter error.
Any suggestion ? Please let me know.
Thanks,
Abdul
|
|
|
|
Re: Oracle 10g database creation problem [message #557225 is a reply to message #557188] |
Mon, 11 June 2012 02:52 |
ncmm
Messages: 11 Registered: May 2012 Location: UAE
|
Junior Member |
|
|
Thank you John,
I think my userid is allowed to open TCP port. I can create tnsnames. I can ping with that tns name. My host machine is pinging .Listener already started on services. Any more suggestion ?
Thanks,
Abdul
|
|
|
|
|