Re: Create database problem..Please help

In the directory %RDBMS73%\Network\Admin you'll find a file LISTENER.ORA

There are some lines like the following at the end of the file: SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )

Correct them by adding the SID DOG, so it will look like that: SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
    (SID_DESC =
      (SID_NAME = DOG)
    )
  )

After saving the edited file, use the NT service manager to stop and start the service
OracleTNSListener

Now try to connect to your new instance.

If this still fails, edit the file again and delete the last line if it looks like
PASSWORDS_LISTENER = (oracle)
and stop and start the service once again

Bye
Tom

aa wrote:

> I am a newbie to Oracle 7.33 and I need help to create a database.
>
> I am trying to create a database 'DOG' by the following:
> Copy Initorcl.ora to Initdog.ora and changed db_name and
> Control_files
> lines.
> Use NT Instance Manager to create new instance with SID=DOG, enter
> path
> for Parameter
> Initialization file and under Advanced changed database name
> to
> DOG.
>
> New instances are created with no errors.
>
> When I launch Instance Manager and log in (INTERNAL) with service name
> of
> DOG, I got the error
> ORA-12154:TNS: could not resolve service name
> What am I doing wrong? Do I need a more descriptive name then DOG?
>
> Thanks in advance for any help. Please Email me directly as I don't
> have a
> reliable connection to this news group.
>
> Under NT services panel I have the following two services, both
> started:
> OracleStartDOG
> OracleServiceDOG
>
> Under Instance Manager I have the following:
>
> DOGS
> Services Started Automatic
> Instance Started Automatic
>
> ORCL
> Services Started Automatic
> Instance Started Automatic
Received on Wed Feb 18 1998 - 00:00:00 CST