1 2 Previous Next 18 Replies Latest reply: Jul 19, 2006 1:22 PM by 522411 Go to original post RSS
      • 15. Re: How do I rename an XE database on a Windows 2003 Server?
        522411
        No, I haven't. What exactly are the commands I should use to re-create the service? I know I need to use the "oradim" utility, but -- in looking through online documentation -- it's very unclear about how exactly it should be done.

        - Gary
        • 16. Re: How do I rename an XE database on a Windows 2003 Server?
          470066
          Since the Oracle Database release 8.0, there is a new, official and recommanded syntax for an Oracle Net alias.

          Before 8.0 :
          CTXMGMT =
             (DESCRIPTION =
                (ADDRESS_LIST =
                   (ADDRESS = (PROTOCOL = TCP)(Host = rodin)(Port = 1521))
                )
                (CONNECT_DATA = (SID = CTXMGMT))
             )
          Since 8.0 :
          CTXMGMT =
             (DESCRIPTION =
                (ADDRESS_LIST =
                   (ADDRESS = (PROTOCOL = TCP)(Host = rodin)(Port = 1521))
                )
                (SERVICE_NAME = CTXMGMT)
             )
          If you want a new "SERVICE NAME" for the XE Instance/Database then you can try this with SQL :
          Alter SYSTEM Set SERVICE_NAMES=XE,CTXMGMT Scope=BOTH;

          Then you can add a new Oracle Net alias in your TNSNAMES.ORA like that :
          CTXMGMT =
             (DESCRIPTION =
                (ADDRESS_LIST =
                   (ADDRESS = (PROTOCOL = TCP)(Host = rodin)(Port = 1521))
                )
                (SERVICE_NAME = CTXMGMT)
             )
          And of course, connect with "SYSTEM/PASSWORD@CTXMGMT"

          Hope this help

          Henri
          • 17. Re: How do I rename an XE database on a Windows 2003 Server?
            470066
            Sorry, the correct Oracle Net Alias "new" syntax is :
            CTXMGMT =
              (DESCRIPTION =
                  (ADDRESS_LIST =
                     (ADDRESS = (PROTOCOL = TCP)(Host = rodin)(Port = 1521))
                  )
                  (CONNECT_DATA = (SERVICE_NAME = CTXMGMT))
              )
            • 18. Re: How do I rename an XE database on a Windows 2003 Server?
              522411
              Thanks for all the info. Also, to be thorough -- just in case anyone looks at this post and needs a definitive step-by-step guide -- the command I exectued to succesfully change the "instance_name" was:

              oradim -edit -sid XE -newsid CTXMGMT

              Which, is only applicable if the database is in a Windows environment.

              - Gary
              1 2 Previous Next