How to create custom DB?

[Rodolfo Luthe]

I'm interested in creating a DB which is 64k block vs the typical 2K.

I did a software only install, but when I tried to create the DB
Oracle's support told me to run dbassist (which doen't exist for
Netware).
Then they told me to use note 33177.1 Creating multiple instances on
NetWare
I had multiple problems:
on step 9 - Set and start de instance the IPC alias already existed
when trying to set the instance on svrmgr31 >set instance server-ipc I
got a:
ORA-12541: TNS: no listener
The listener.log showed
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(NET=00000000)(NODE=000000000000)(SOCKET=000

0)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=spx)(NET=0e9ae92d)(NODE=000000000001)(SOCKET=401

3)))
Attempted to listen on:
(ADDRESS=(PROTOCOL=TCP)(HOST=SERVIMERCERIA)(PORT=1521))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
NetWare Error: 11: Too many open files
No longer listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(NET=00000000)(NODE=000000000000)(SOCKET=000

0)))
No longer listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=spx)(NET=0e9ae92d)(NODE=000000000001)(SOCKET=401

3)))

SO the Oracle support guy said it was a OS related problem: NetWare
Error: 11: Too many open files
That I should increase the use of open files...
I did a typical Oracle install and it worked... no problems

Can somebody tell me how to create a database so I can create it with
the 64k block?

TIA,

Rodolfo Luthe

[m...@canada.com]

1. 16K is the largest block size supported on NetWare and 32K is the
largest block size that is stable on some other platforms. Most are not
stable beyond 16K anyway.

2. Creating an Oracle database several steps.

a. Create the listener.ora and tnsnames.ora entries for the new instance
on the NetWare server.

With later versions of Oracle for NetWare there is an EASYCFG.NCF script
which essentially provides the functionality of SQL*Net Assistant on other
platforms. Try to use that tool to setup the database entry in the
listener and the SQL*Net alias entry in the server's local tnsnames.ora
file.

b. Test the SQL*Net connection to the new instance.
c. Run scripts to create the physical database.

Oracle Support does have an in house Java based tool for creating
databases on NetWare, but it does not setup the SQL*Net side of things for
you like DBAssist will on other platforms and requires NetWare 5.X with a
JVM version of 1.1.7B at least and your server monitor must be capable of
800x600 resolution for best results. The installation of that tool does
require that you be familiar with how the NetWare JVM is setup on your
server.

The SQL*Net stuff must be manually setup or setup via EASYCFG.NCF. The
tool does not give all the options that DBAssist gives, but it may be
worth your while to ask for it if you have an Oracle Support contract.
However, as it is not official packaged software for external use it is
use at your own risk and provided as is.

If you log a TAR to get this software ask that the analyst who gets your
TAR contact the administrator of suppnw1.ca.oracle.com to get the Java
software.

> begin:vcard
> n:Luthe;Rodolfo
> tel;fax:+52 (33) 3121-7318
> tel;work:+52 (33) 3122-5691 ext 11
> x-mozilla-html:TRUE
> url:www.grupoluthe.com
> org:Grupo LUTHE
> version:2.1
> email;internet:lu...@infosel.net.mx
> title:General Manager
> adr;quoted-printable:;;San Heriberto 2850=0D=0AJard. Plaza del
Sol;Guadalajara;Jal;44510;MEXICO
> x-mozilla-cpt:;-400
> fn:Rodolfo Luthe
> end:vcard
>