OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Create Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create Database [message #56571]

Wed, 09 April 2003 03:46

Tushar Shah
Messages: 3
Registered: April 2003

Junior Member

Hi
I am new to oracle RDBMS

I created instance using oradim utility. Now i want to create database.

When i am connecting to SQLPLUS as below

c:sqlplus /nolog

it gives me prompt as SQL>

Now here when i says startup nomount it gives me error as Protocol Adaptor Error

Please help me and let me know whats wrong

Regards
Tushar Shah

Report message to a moderator

Re: Create Database [message #56572 is a reply to message #56571]

Wed, 09 April 2003 04:01

seng
Messages: 191
Registered: February 2002

Senior Member

Check your ORACLE_SID setting.

Report message to a moderator

Re: Create Database [message #56576 is a reply to message #56571]

Wed, 09 April 2003 07:27

Tushar Shah
Messages: 3
Registered: April 2003

Junior Member

Where it is..?

Report message to a moderator

Re: Create Database [message #56579 is a reply to message #56571]

Wed, 09 April 2003 11:33

Peter Diaz R.
Messages: 3
Registered: April 2003

Junior Member

Verify that your services is started
OracleService<SID>

Report message to a moderator

Re: Create Database [message #56612 is a reply to message #56571]

Fri, 11 April 2003 11:25

Trifon Anguelov
Messages: 514
Registered: June 2002

Senior Member

You have to setup ORACLE_SID on the command line first. Eg

c:> set oracle_sid=YOUR_SID_HERE
c:> sqlplus /nolog
....

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

The latest Oracle DBA forums

Report message to a moderator

Previous Topic:	Deleting archivedlogs
Next Topic:	Patch Set version 9.2.0.3.0 for win2000

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:42:46 CDT 2024