Re: ORA-12560: TNS:protocol adapter error while creating a database manually

"Desmond" <ld_at_ldd1234.com> wrote in message news:c45tcl$qje$1_at_reader01.singnet.com.sg...
> Hi all,
>
> I want to create a database manually in 9i. I am running the Oracle 9i
> server on a Windows XP system.
> This is the step I take initially before I enter the startup nomount
> pfile=U:\Oracle\admin\cars\pfileinitCARS.ora. I have set the enviornment
> variables already.
>
> D:\sqlplus /nolog
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Sun Mar 28 15:22:45 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> SQL> connect SYS as sysdba
> Enter password:
> ERROR:
> ORA-12560: TNS:protocol adapter error
>
> Can anyone advise what is wrong here? I cannot enter the "startup nomount
> pfile=U:\Oracle\admin\cars\pfileinitCARS.ora".
> without connecting in the SQLPLUS console.
>
>
> I have read the Oracle 9i course material but it is too vague when comes
to
> creating the database manually. I have also searched some Oracle website
but
> they
> either contains bugs in the procedure or is not accurate.
>
> I know I can use dbca to create the database but I want to go a little
lower
> level as I am a Oracle newbie
>
> MIllions of thanks
>
> ld
>
>

Hi,

You need to issue the oradim command first as shown below: c:\>oradim -new -sid CARS -syspwd new_password

Then do your procedure as above. Windows requires that a service be created first before you use SQL*Plus to create the database. If you look inside the Services panel of Administrative tools, you will find a new service called OracleServiceCARS has been created for.

You may want to review "Creating a Database Manually" on p.1-15 of "Oracle9 i Database Administrator's Guide" for more details.

Douglas Hawthorne Received on Sun Mar 28 2004 - 02:48:53 CST