Re: Can't get started with XML and Oracle

From: news <kennedy-family_at_home.com>
Date: Thu, 29 Nov 2001 04:21:41 GMT
Message-ID: <pJiN7.91045$XJ4.49844015_at_news1.sttln1.wa.home.com>

Sounds Like Oracle isn't running.
Go to a command prompt and try the following Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp.

C:\>sqlplus

SQL*Plus: Release 9.0.1.0.1 - Production on Wed Nov 28 20:21:54 2001

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Enter user-name: system/manager

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option
JServer Release 9.0.1.1.1 - Production

SQL> show sga

Total System Global Area 118255568 bytes

Fixed Size                   282576 bytes
Variable Size              83886080 bytes
Database Buffers           33554432 bytes
Redo Buffers                 532480 bytes

SQL> I am running 9i, but you should get similar results with 8i. Jim

"Peter Chatterton" <chatt_at_millcomm.com> wrote in message news:FciN7.13958$3i2.2353798_at_news20.bellglobal.com...
> I'm working thru Muench's book: Building Oracle XML Applications
> but don't know much about xml or oracle (i do know java).
>
> I've got Oracle 8 under win2K and i've started Navigator.
>
> The setup instructions for chapter 3 say run:
> createxmlbook.sql
> -create user xmlbook identified by xmlbook;
> -grant connect, resource, query rewrite to xmlbook;
>
> If i enter: sqlplus SYSTEM in the appropriate folder,
> I get: ORA-12203 TNS:Unable to connect to destination
> with the header: e:\orant\bin\PLUS80.exe
>
> If i enter: sqlplus SYSTEM/MANAGER createxmlbook.sql
> It does nothing i can see.
> (Adding the _at_ before the filename makes a difference,
> but doesn't help)
>
> I tried starting SQL*PLUS from the start button menus,
> but still got 12203 with both IDs.
>
> Thanks for reading this far and hope you can help,
> Peter.
>
>
>
>
Received on Thu Nov 29 2001 - 05:21:41 CET