Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Unanswered: New installed Oracle 10g doesnt start up...

    Hello,

    I've installed a brandnew Oracle 10g Database (called akte10) on my linux box but the database won't start with following error:

    SQL*Plus: Release 10.1.0.2.0 - Production on Di Feb 10 18:18:41 2004

    Copyright (c) 1982, 2004, Oracle. All rights reserved.

    SQL> ERROR:
    ORA-12154: TNS:could not resolve the connect identifier specified


    SQL> ORA-12154: TNS:could not resolve the connect identifier specified
    SQL>
    Database "akte10" warm started.


    I have checked the scripts for db start and found that it calls
    sqlplus and connect as internal.
    I tried this too and got the same errors. There is no way to connect to
    the new db. I've checked the entries in the listener.ora and tnsnames.ora
    and they seem to be ok.


    TNSNAMES.ORA

    AKTE10 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = akte10)
    )
    )

    LISTENER.ORA

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /oracle10g)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = akte10)
    (ORACLE_HOME = /oracle10g)
    (SID_NAME = akte10)
    )
    )

    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )


    Has anybody experiences with 10g? Or the same problems?

    Thank you for help.

    Andreas

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    unset TWO_TASK

    SQL*Net is NOT required to start any Oracle DB

  3. #3
    Join Date
    Sep 2003
    Location
    Columbia, MD USA
    Posts
    95
    connect internal???

    should be connecting sys as sysdba I would think...

    didn't Oracle get rid of internal in 9i? maybe they didn't update the scripts?

    kind of makes me wish I had the time to d/l and try it out
    drew
    ------------------
    http://wjtechnologies.com

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    forget dbstart, that script sucks because Oracle never updates the frickin thing with their new releases.

    log into the host server as the oracle user.

    type:

    sqlplus /nolog
    connect /as sysdba
    startup


    if that does not work then report back exactly what the host server stated as you typed those commands
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Feb 2004
    Posts
    3
    Thanks anacedent,
    and thanks to the other posters too.

    I forgot that my machine was a oracle client some times ago.
    The two_task variable was set. i have unset this variable and my
    db works fine.

    Thank you again.

    Andreas

Posting Permissions

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