Drop and recreate db console
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Drop and recreate db console

Hybrid View

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    Drop and recreate db console

    DBAs,

    I was trying to configure database console on one 10g db on Linux box.

    When I configured the dbconsole, the db port is 1521 and the hostname used the real machine name. I was trying to change the port to 1545 and using the VIP name (easy to remember).

    It seems kinda messed up. I want to drop it and then recreate it.

    When I use

    emca -deconfig dbcontrol db -repos drop

    and

    emca -config dbcontrol db -repos recreate

    always failed.

    Is there any other better way to do this?


    Thanks,

    Lily

  2. #2
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    The error from the log file when I tried to drop:

    Getting temporary tablespace from database...
    [16-08-2007 11:14:19] Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sactd.ges.XXXX.com)(PORT=1545)))(CONNECT_DAT A=(SERVICE_NAME=SACTD))):

    ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)


    The listener for SACTD is running like this.

    SACTD =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sactd.ges.XXXX.com)(PORT = 1545))
    )
    )
    )
    ~

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    the database isnt registered with the listener, or you are trying to connect to something that doesnt exist

  4. #4
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Thanks.

    When I started the dbconsole, the homepage shows, but when I try to login in as sys. Got error:

    Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sactd.ges.XXXX.com)(PORT=1545)))(CONNECT_DAT A=(SERVICE_NAME=SACTD)))


    [orasactd tus1sacdbsdex01] /home/orasactd$ lsnrctl service SACTD

    LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 16-AUG-2007 14:57:28

    Copyright (c) 1991, 2006, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sactd.ges.XXXX.com)(PORT=1545)))
    Services Summary...
    Service "SACTD.ges.XXXX.com" has 1 instance(s).
    Instance "SACTD", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:110 refused:0
    LOCAL SERVER
    The command completed successfully


    NOTE, In error message. the service_name IS SACTD,

    In the lsnrctl service , it shows the service_name is SACTD.ges.XXXX.com.

    Does this matter?

    If it does, how can I change the client’s service_name to match the listener ‘s ?

    Thanks

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    yes it matters because they are different - easier to change the listener / database

  6. #6
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Thanks. It works now.

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