Connection Error ORA 12154 - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: Connection Error ORA 12154

  1. #11
    Join Date
    May 2007
    Posts
    13
    Ok i do understand that now. So how do I make my Listener register to my database?

    Would one solution be to make my default listener which registered as DYNAMIC to be STATIC. So would i have to edit my listener.ora file ?

  2. #12
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    The database registers to the listener not the listener to the database
    If the listener operates on the default port (1521) the db registers authomatically when the db starts up, no need to do anything
    When it is down however, it is of cource not registered

  3. #13
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Dear,

    Stop your listener service using:

    >lsnrctl stop
    ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
    Use this for your tnsnames.ora

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
    )
    )
    +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

    Use this for your listener.ora

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (SID_NAME = ORCL)
    (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    )

    +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

    Start the listener using:
    >lsnrctl start

    Let us know if you face the same problem.

  4. #14
    Join Date
    May 2007
    Posts
    13
    Paresh you are a star! I did exactly what u said and with further issues I am now able to connect. Every thing seems fine now. Thanks very much.
    One more query - my sample schemas are locked, so for unlocking the HR account, i typed ALTER user HR account unlock; got reply user altered. But when i enter username as HR and pass: as hr, i get an error saying invalid username and password. What am i doing wrong?

  5. #15
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Quote Originally Posted by nitesh79
    Paresh you are a star! I did exactly what u said and with further issues I am now able to connect. Every thing seems fine now. Thanks very much.
    One more query - my sample schemas are locked, so for unlocking the HR account, i typed ALTER user HR account unlock; got reply user altered. But when i enter username as HR and pass: as hr, i get an error saying invalid username and password. What am i doing wrong?
    Dear Nitesh,

    Am not a star, am a humble DBA. good to know things are working fine. WHat i did was just manual registration of your DB with the listener.

    For your second problem:

    Login from sys as sysdba:

    SQL> alter user HR identified by HR;

    SQL> conn hr/hr@ORCL

    Let me know.

  6. #16
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57
    did u ever logged into ur isqlplus after installing the database.

    check this :
    sql>isqlplusctl status/start/stop

    start it if it is stopped ....see if above works...

    http://localhost:5560/isqlplus.

    i hope ur looking for a way to work with isqlplus:
    People with goals know where they are going

  7. #17
    Join Date
    May 2007
    Posts
    13
    Paresh, yes u are right, may be i didnt register the password hr for this account. it works now. problem solved. U r a very modest person and this site has some very dedicated people. I would recommend it to all.

    By the way im from Mumbai too, down in UK for a better job, hopefully get certified very soon once my training is complete. Hey uve been very helpful, would u mind if could get ure email id, as im able to communicate with u well and hope u cld mentor me during my training and exams. Sorry if im asking for alot of favors. Not to worry, if not.

    Thanks to Zakriyamhd too, im now able to conn to isqlplus too, for now atleast

    By the way one more query for you all: ive noticed that an even called 'emdctl.exe' is running on computer and its using a lot of my precious memory.
    Im guessing this running application indicates to me that it cannot communicate with some service. Dont get any pop ups but i think it relates to Oracle performance monitoring related tools. How can i get rid of this?
    Last edited by nitesh79; 05-18-2007 at 08:10 AM.

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