Home » Infrastructure » Windows » Oracle 10g database creation problem (Oracle 10g on Windows 2008 server)
Oracle 10g database creation problem [message #557183] Sun, 10 June 2012 09:04 Go to next message
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 #557186 is a reply to message #557183] Sun, 10 June 2012 09:42 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I tried several ways but no use.


Which of no use for us to know what you did and the errors you got.

regards
Michel
Re: Oracle 10g database creation problem [message #557187 is a reply to message #557183] Sun, 10 June 2012 09:45 Go to previous messageGo to next message
BlackSwan
Messages: 22786
Registered: January 2009
Senior Member
ORA-12560 is some what of a catchall error which can results from any number of different root causes.
Something is wrong at the OS level & it could be error of omission or error of commission.
simply put, if you actually follow step by step instruction from Installation Guide the DB gets created; otherwise not.
Re: Oracle 10g database creation problem [message #557188 is a reply to message #557183] Sun, 10 June 2012 12:51 Go to previous messageGo to next message
John Watson
Messages: 4557
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 Go to previous messageGo to next message
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 #557224 is a reply to message #557187] Mon, 11 June 2012 02:48 Go to previous messageGo to next message
ncmm
Messages: 11
Registered: May 2012
Location: UAE
Junior Member
Thank you Swan,

Could you please send me the link to download the installation manual for oracle 10g on windows server 2008.

Regards,

Abdul
Re: Oracle 10g database creation problem [message #557225 is a reply to message #557188] Mon, 11 June 2012 02:52 Go to previous messageGo to next message
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
Re: Oracle 10g database creation problem [message #557226 is a reply to message #557225] Mon, 11 June 2012 02:55 Go to previous messageGo to next message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
I suggest that you tell the truth!
Quote:
I tried database creation manually.
No, you did not. This message
Quote:
when it is finished 2%
is displayed by the DBCA tool.

All te docs are on http://tahiti.oracle.com
Re: Oracle 10g database creation problem [message #557272 is a reply to message #557226] Mon, 11 June 2012 08:00 Go to previous message
ncmm
Messages: 11
Registered: May 2012
Location: UAE
Junior Member
Sorry John. I meant that I tried to create again through DBCA tool after software installation. I know it was confusing. Sorry for that.

Thank you very much for your link


Regards,

Abdul
Previous Topic: Compatible version with Windows 7
Next Topic: Oracle connection problem
Goto Forum:
  


Current Time: Wed Sep 17 19:20:30 CDT 2014

Total time taken to generate the page: 0.12212 seconds