Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2002
    Posts
    26

    Exclamation Unanswered: How to set a oracle instance manually in linux?

    well, all the problem with 9i on my sistem is that oracle instance never was created... now i need to know how to do it manually, or a tool for that or something... god, this stuff is killing me and sendme in never-sleep travel!!!!


  2. #2
    Join Date
    May 2002
    Location
    Sydney
    Posts
    45
    try

    %> dbca&


    Jimskit

  3. #3
    Join Date
    Mar 2002
    Posts
    26

    Unhappy NOPES

    INST WORK...

  4. #4
    Join Date
    May 2002
    Location
    Sydney
    Posts
    45
    Right,

    Does that mean dbca does not work, or you dont have it?
    What does INST WORK mean. You are going to have to be more lucid if you want meaningful replies Padwell.


    J

  5. #5
    Join Date
    Apr 2002
    Location
    beijing,china
    Posts
    20
    logn in with a x-win as oracle user
    and run dbca, and choose "new database"
    db2oracle

  6. #6
    Join Date
    Mar 2002
    Posts
    26

    right, sorry

    well, i put so little data for the post, sorry for that...
    now this is the problem

    1.- The DB is created
    2.- All the system is functional (sqlplus, dgmgrl, x-based interfaces, etc.)
    3.- The component that isn't working is the listener. (say "no listener")

    the host is ngcch.cl
    the dbname is NGC

    this error comes before fixed some error whit the NLS. I recreated the db (deleted and created again) with dbca, but this wont fix the problem....

  7. #7
    Join Date
    May 2002
    Location
    Sydney
    Posts
    45
    Okay, so I understand from the last mail that your listeners dont seem to be working.

    I presume you cannot connect to the instance via sqlplus. If you can then the listeners are working.

    Try using
    %>tnsping ngc

    if the listensers are working you should see the following.

    Used parameter files:
    D:\oracle\ora90\network\admin\sqlnet.ora
    D:\oracle\ora90\network\admin\tnsnames.ora

    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ngcch.cl )(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ngc))
    OK (70 msec)
    >

    If this tnsping fails, then the listeners could be at fault.
    Look in the tnsnames.ora , and the listener.ora file and ensure you have the correct listing for your instance.

    then using the command
    %> lsnrctl

    stop and start the listeners and try again.
    %> stop
    %> start

    if the tnsping fails copy the results here Paddawell.

    good luck

    J

Posting Permissions

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