Re: Oracle 9i on Windows Server 2003 64 bit

aaa_at_bbb.com wrote:

> Hi,
>
> I have Oracle 9i (9.2.0.2.0) 64 bit installed on an Itanium server
> running Windows Enterprise Server 2003 64 bit, and I am having trouble
> creating the tables, views etc for a database.
>
> The 64 bit version of Oracle does *not* include the Enterprise Server
> Manager. The documentation that comes with Oracle says that you need
> to use the 32 bit version from a different machine, remotely. I do not
> have another machine set up with Oracle 32 bit. (BTW, it also does not
> include the security manager)

For some regulars here, this will be me merely banging the same old drum, but it's times like these you really might want to investigate Vmware. It would allow you to create a complete virtual PC within the physical confines of your Itanium box... and you could stick any old operating system in there, and run boring old 32-bit Oracle on it to boot.

But that aside...

>
> The only means I have to create a database is by using the Database
> Configuration Assistant.

Whaddya mean "only means"?? Whatever happened to good old SQL Plus? ;-)

>This has an option to run scripts as part of
> the creation process, so I added several "*.sql" files that contain
> create table statements, but whilst these were in fact run, everything
> within them failed. So the end result is a database containing only
> the Oracle system tables, with no application tables.
>
> The sql files have been run successfully on a Solaris server, so the
> syntax is correct.

Strangely enough, things that worked perfectly in the past don't just give up the ghost unless their syntax is *not* correct. Something is wrong, and without seeing even a snippet of the scripts you're talking about, it's difficult to know for sure. But I'd start by looking at whether the scripts specify a particular tablespace in which to create the tables, and then check whether you actually have tablespaces of those names in your new database. The DBCA creates lots of extra tablespaces as part of its procedures... creating a database manually results in you only having SYSTEM. And possibly TEMP and UNDO. All other tablespaces will have to be created manually before you run your scripts, if they mention them.

>
> I have found documenation on the web that says to create a table, just
> open a Windows command window and run "svrmgr filename.sql" (as well
> as a few other steps), but the 64 bit version of Oracle does not
> include this program. I have searched my whole hard disk for
> "svrmgr*.*" with no result.

Oh dear. You might want to get a bit more up to speed with Oracle before you plunge much deeper into the mire. Svrmgrl ("server manager") was the tool provided in Oracle 7, 8 and 8i to perform privileged actions (which are, create database, backup, recover, startup instance and shutdown instance). It happened also to allow you to issue SQL statements, of which 'create table' is just one.

When Version 8 was announced (and that would be nearly 5 years ago now), Oracle made it clear that in some future release the privileged actions function of Server Manager would be merged into boring old SQL Plus, which had hitherto been great for issuing SQL Statements, but couldn't cope with the privileged action syntax. In Version 8i, that promise became a reality: SQL Plus became able to do normal SQL statements AND privileged action statements. First implementation of this 'merged' utility was a bit flakey, however, so Server Manager was retained in 8i to ensure full functionality... and to give DBAs yet more time to wake up and smell the way the wind was blowing.

In 9i, Oracle made the decision to go the whole hog: Server Manager is dead and gone, is not shipped, is not supported, has no further development future... you get the idea. SQL Plus is the tool to use now, for everything both routine and privileged. And that's why you can't find the old utility on your CDs or system any more.

Don't grieve: SQL Plus does everything Server Manager used to do.

>
> If anyone can suggest a method that I can use to create the tables,
> views etc., I would be very appreciative.

Well, creating tables and views etc is not the hardest thing a DBA ever has to come to grips with. It's just a question of using the right tool for the job (SQL Plus) and knowing the syntax... which you can probably get from those old scripts of yours if they used to work elsewhere. You also have to know a modicum about what is going on under the hood so that the scripts can be *understood* and not just repeated by rote. Then you'll understand why they failed before, and then you can correct the error so that they'll work in the future.

Regards
HJR
>
> Thanks,
> Dave
Received on Thu Sep 11 2003 - 03:16:30 CDT