Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Posts
    4

    Unanswered: installing Oracle9i

    This is first time i tried to create database manually. I am trying to install Oracle9ion Windows XP. the software got installed normally. I setup a listener called "LISTENER"

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Hamza)(PORT = 1521))
    )
    )
    )

    when i check status, it shows status UNKNOWN

    LSNRCTL> status
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Hamza)(P ORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
    tion
    Start Date 21-AUG-2003 08:48:29
    Uptime 0 days 0 hr. 19 min. 23 sec
    Trace Level err
    Security OFF
    SNMP OFF
    Listener Parameter File E:\oracle\OraceDB\network\admin\listener.ora
    Listener Log File E:\oracle\OraceDB\network\log\listener.log
    Listener Trace File E:\oracle\OraceDB\network\trace\listener.trc
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Hamza.ka sb.net)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\EXTPROC5ipc)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    i get ORA-12560: TNSrotocol adapter error when i try to connect as
    sys/change_on_install as sysdba
    or
    sys / as sysdba

    so i am unable to create database ... needs to know when am i doing wrong or missing ?

    Thanks.

  2. #2
    Join Date
    Aug 2003
    Posts
    14
    You create TNSNAMES.ORA file.Then try to connect

  3. #3
    Join Date
    Aug 2003
    Posts
    4
    needs to give SID in TNSNAMES.ORA ... installation didn't asked me to entry SID ... how can i set ORACLE_SID ?

  4. #4
    Join Date
    Aug 2003
    Posts
    4
    where to set this ..
    environment variable ?
    i did that but didn't worked out
    i also added ORACLE_SID and LOCAL in registry and that also doesn't seem to work ...

    i set ORACLE_SID = ORACL
    and LOCAL = ORACL.KASB.NET
    in registry

    add entry to tnsnames.ora
    OASIS.KASB.NET =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = HAMZA)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ORACL)
    )
    )


    and i get this when i try to connect

    SQL> conn sys/change_on_install@oasis.kasb.net as sysdba
    ERROR:
    ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
    descriptor

  5. #5
    Join Date
    Aug 2003
    Posts
    4
    OK . let me rephare my question ..
    i want to create a database manualy, so i selected 'Install Software only' option from Oracle 9i installer. can any one list down steps required to create database.

    Thanks.

Posting Permissions

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