URGENT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: URGENT

  1. #1
    Join Date
    Feb 2001
    Posts
    24

    Exclamation

    hello,

    thanks for ur replies,
    just now i installed oracle enterprise edition with default database and the original database is not yet installed. and when i have to configure the listeners now i have to configure or after creating the database. still i have not created any user also, created only one user name oracle under dba group.

    my envoronment is

    oracle 8.1.6 on HP_UX version 11 and HP9000 server

    and what are the post installation steps i want to know in detail.

    if i have to configure now pls let me know in detail how to configure that (I am working in production environment).

    thank you very much in advance

    regards
    kishore
    ram kishore

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You better check with installation guide for setting up installation procedures. If your installation is perfect and it went well and your default database works fine. Everything is ready to go:

    1.Prepare init.ora parms file
    2.design physical layout/Follow OFA
    SETUP environment ORACLE_HOME and ORACLE_SID
    3.create database, create rollback tablespace and rollback segments, TEMP, USERS and TOOLS tablespace
    4.run catalog.sql and catproc.sql
    5.run other options scripts as needed like replication option, dbms utility scripts etc.
    6.Create data and index tablespaces for Original database.
    7. oratab eith the new instance created
    8. update listener.ora,tnsnames.ora,sqlnet.ora
    9.alter database backup controlfile to trace.
    ...
    ..
    .

    thats it pretty much
    Reddy,Sam

  3. #3
    Join Date
    Mar 2001
    Posts
    18
    The most important thing is that your client should be able to connect to the database, new sid is automatically registered in tnsnames.ora,listener.ora,sqlnet.ora if not you can always use Net8 Config.

    I would not recommend you to manually edit tnsnames.ora and listener.ora.

    Thanks.
    CHEERS

Posting Permissions

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



Click Here to Expand Forum to Full Width