Re: Failed to create a type on Oracle 8?

Did you add the new instance to your listener.ora file?

gbe wrote:

> Sorry I can't answer your question – I'm struggling with Oracle8 on NT and
> it sounds like you got further than me - can you help?
>
> I can't create an instance (other than the default one) and see it.
>
> I've just installed Oracle 8.0.3.0.0 on a clean NT (sp3) machine and the
> default
> instance works fine (including ODBC over TCP/IP).
>
> I use Oracle Database Assistant, choose "Custom Database", "Small" and
> choose all the defaults - I create database files from scratch ie I don't
> use the "copy from CD option" .
>
> Using Instance Manager (oradim80) I can see the new Services "Started" and
> Instance
> "Started".
>
> When using Net8 Easy Config to create a Service Name to the new SID it
> says...
>
> ORA-12505: TNS listener could not resolve name etc.
>
> I can create a service name (using Net8 easy config) linked to SID=ORCL but
> not my new Instance.
>
> hope_smith_at_hotmail.com wrote in article
> <6qpr2c$h1s$1_at_nnrp1.dejanews.com>...
> > Login as scott/tiger,
> >
> > Tried to create a VARRY type, but oracle seems do not the end of
> creation.
> > Connected to:
> > Personal Oracle8 Release 8.0.3.0.0 - Production
> > With the Partitioning option
> > PL/SQL Release 8.0.3.0.0 - Production
> >
> > SQL> create type prices as varray(10) of number(12,2);
> > 2
> > 2 ;
> > 3 ;
> > 4 ;
> > 5
> >
> > Asking for help.
> >
> > Thanks.
> >
> > Hope
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
> >
Received on Fri Aug 14 1998 - 15:06:21 CDT