Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2002
    Location
    Azerbaijan
    Posts
    2

    Unanswered: Manual DB creation and specifics errors!!!

    Dear All.

    I installed Oracle 9i Enterprise Edition on Win2000 Professional Service Pack 4.0. (Only software)

    I cannot create database using DBCA and receive errors "TNS packet writer failure" or "end of file communication channel".

    I decided to create manually.

    I generated script using DBCA. Everything OK until logging to sqlplus as sys/password as sysdba. I receive error like "end of file communication channel". But I repeat this 10-15 time and stop/start LISTENER, it was successful and appeared "Connected idle instance". But when I want to startup nomount pfile=FilePath I receive error "service handle not initalized" and "host defs doesnt exist" and "end of file communication channel". Now I cannot shutdown service, says instance already started, so I issued this command startup force pfile=FilePath, the same errors.

    So, again repeat steps, I formatted my system disk even, and installed WIN2000 again and Installed Oracle again but the result is the same.

    Can anybody help me?

    I dont think that this bug, because Oracle is really very seriously coded DB Software as Borland Delphi.

    Thanks in advance...

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    OK,
    you recieve the error saying that "service handle not initalized". this error says that the service for the instance you are trying to connect to is not created. When you set the window environment variable ORACLE_SID=<your Instance name>. then you must have service created for this instacne othervise when you trying to start the sqlplus, it gives you the above error. The service name format is OracleServiceORCL where Your instacne name is ORCL.

    So You have to first create the (1) password file using the orapwd utility and (2) create the service using oradim utility.

    Please Read the Oracle Documentation for this
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Hi,
    U can use Oradim utility to create the instance as follows;
    oradim -new -sid <instance_name> -intpwd <passwd> (password for sys if 9i or internal if it be 8i) -pfile (with the path) -startmode auto/manual

    After that u will get OracleServiceORCL(if sid given as ORCL) where ORCL is ur instance name.
    Use Orapwd utility to create password file which is like PWD<SID>.ora
    but ofcourse after deleting any existing one.
    orapwd file=C:\pwdORCL.ora password=change_on_install entries=5 (say).

    After this come to the cmd prompt.
    Set ORACLE_SID=ORCL (say)
    and log into sqlplus as internal or sys and issue the startup command.
    Hope that solves ur problem.
    Kaushik

  4. #4
    Join Date
    Aug 2002
    Location
    Azerbaijan
    Posts
    2
    Thank you Hings and kausik_m123.

    See below for which steps I followed.

    mkdir E:\oracle\admin\DB1\bdump
    mkdir E:\oracle\admin\DB1\cdump
    mkdir E:\oracle\admin\DB1\create
    mkdir E:\oracle\admin\DB1\pfile
    mkdir E:\oracle\admin\DB1\udump
    mkdir E:\oracle\ora92\database
    mkdir E:\oracle\oradata\DB1

    set ORACLE_SID=DB1

    E:\oracle\ora92\bin\oradim.exe -new -sid DB1 -startmode m
    E:\oracle\ora92\bin\oradim.exe -edit -sid DB1 -startmode a

    E:\oracle\ora92\bin\orapwd.exe file=E:\oracle\ora92\database\PWDDB1.ora password=change_on_install
    E:\oracle\ora92\bin\sqlplus /nolog @E:\oracle\admin\DB1\scripts\CreateDB.sql

    This is description of CreateDB.sql file:

    connect SYS/change_on_install as SYSDBA /* Error here */
    set echo on
    spool E:\oracle\admin\TestDB\create\CreateDB.log
    startup nomount pfile="E:\oracle\admin\DB1\scripts\init.ora";
    CREATE DATABASE DB1
    MAXINSTANCES 1
    MAXLOGHISTORY 1
    MAXLOGFILES 5
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    DATAFILE 'E:\oracle\oradata\DB1\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL
    DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'E:\oracle\oradata\DB1\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
    UNDO TABLESPACE "UNDOTBS1" DATAFILE 'E:\oracle\oradata\DB1\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    CHARACTER SET WE8MSWIN1252
    NATIONAL CHARACTER SET AL16UTF16
    LOGFILE GROUP 1 ('E:\oracle\oradata\DB1\redo01.log') SIZE 102400K,
    GROUP 2 ('E:\oracle\oradata\DB1\redo02.log') SIZE 102400K,
    GROUP 3 ('E:\oracle\oradata\DB1\redo03.log') SIZE 102400K;
    spool off
    exit;

    Thanks in advance.

    Originally posted by Hings
    OK,
    you recieve the error saying that "service handle not initalized". this error says that the service for the instance you are trying to connect to is not created. When you set the window environment variable ORACLE_SID=<your Instance name>. then you must have service created for this instacne othervise when you trying to start the sqlplus, it gives you the above error. The service name format is OracleServiceORCL where Your instacne name is ORCL.

    So You have to first create the (1) password file using the orapwd utility and (2) create the service using oradim utility.

    Please Read the Oracle Documentation for this
    Last edited by mistersql; 02-19-04 at 01:31.

  5. #5
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Ok,

    First of all delete the Oracel Service and password file you created and
    follow the steps below.

    (1) Create requered Directories (which you have successfully created)

    mkdir E:\oracle\admin\DB1\bdump
    mkdir E:\oracle\admin\DB1\cdump
    mkdir E:\oracle\admin\DB1\create
    mkdir E:\oracle\admin\DB1\pfile
    mkdir E:\oracle\admin\DB1\udump
    mkdir E:\oracle\oradata\DB1

    (2) make an init.ora file into the E:\oracle\ora92\database\initDB1.ora.

    (3) Create a password file for this database.

    orapwd file=E:\oracle\ora92\database\pwdDB1.ora users=5 password=abcxyz

    (4) run an oradim Utility.

    oradim -NEW -SID db1 -INTPWD abcxyz -SRVC OracleServiceDB1 -STARTMODE auto -PFILE E:\oracle\ora92\database\initDB1.ora -MAXUSERS 5

    (5) set ORACLE_SID=DB1
    (6) Run sqlplus
    (7) ENTER
    / AS SYSDBA as a username (IF ASK FOR A PASSWORD THEN ENTER abcxyz same when you have given while running oradim)

    (8) SQL>CREATE SPFILE FROM PFILE;

    (9) SQL>show sga (To make sure that Instance is Up or Not because you have set SRVC to AUTO in oradim)

    (9) SQL>STARTUP NOMOUNT (if instance is not up)

    (10) NOW You can run your CREATE DATABASE command.

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  6. #6
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Only a slight modification
    Create spfile from pfile statement is not mandatory.
    Actually Spfile has precedence over pfile ( init<sid>.ora.)
    But a proper Init<sid>.ora file is also capable enough to provide all the parameters required by your instance.
    create spfile from pfile statement can be issued anytime after DB creation.

    All the best
    Kaushik

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •