Home » RDBMS Server » Server Administration » Oracle Database Creation
Oracle Database Creation [message #61603] Sun, 09 May 2004 23:26 Go to next message
Eric Langager
Messages: 38
Registered: April 2004
Location: Beijing, China
Member
Greetings,

When trying to connect sys/password as sysdba for the purpose of doing a manual database creation, I am continually getting the TNS-12560 TNS:protocol adapter error.  Does this indicate a problem with the service?  There is no listener service, because I have a software only installation, but there shouldn't need to be.  Curious

Report message to a moderator

Re: Oracle Database Creation [message #61608 is a reply to message #61603] Mon, 10 May 2004 12:33 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

You need to create a database service before you can
create a database on Windows platforms. This is done
with the ORADIM utility. Here's an example:

set ORACLE_SID=orcl 
oradim -new -sid %ORACLE_SID% -pfile c:pathtoinitorcl.ora


For more info, look at the Oracle/Windows FAQ @
http://www.orafaq.com/faqwinnt.htm

Best regards.

Frank

Report message to a moderator

Previous Topic: Operating system date deference with Network file system date
Next Topic: What is Oracle Profile?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:29:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.