1 2 Previous Next 15 Replies Latest reply: Apr 12, 2010 10:46 AM by sb92075 RSS

    GLOBAL DBNAME change

    Ramesh_R
      Hi,
      I have a DB with SID = 'XYZ' service name = 'XYZ'.
      select global_name from global_name; give´s 'XYZ'
      I have a requirement to have the service name as 'XYZ.WORLD'
      to connect from a java application

      I have changed it in the listener.ora with the SID_DESC with the GLOBAL_DBNAME = 'XYZ.WORLD'.
      Even now
      select global_name from global_name; gives 'XYZ'

      After doing so i have the following error.
      java.sql.SQLException: ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux Error: 2: No such file or directory

      What would be the possible cause.
        • 1. Re: GLOBAL DBNAME change
          575433
          Hi, can you try to change global name by using the following

          ALTER DATABASE RENAME GLOBAL_NAME TO ...;
          • 2. Re: GLOBAL DBNAME change
            Ramesh_R
            Even after altering getting the same error :-(
            • 3. Re: GLOBAL DBNAME change
              635694
              On the client machine, in the %ORACLE_HOME%\network\admin\sqlnet.ora file, you should remove "names.default_domain" value.
              • 4. Re: GLOBAL DBNAME change
                ASM2
                Verify that the ORACLE_SID environment variable is set and points to a valid database that is up and running.

                echo $ORACLE_SID
                orcl
                • 5. Re: GLOBAL DBNAME change
                  Ramesh_R
                  I am trying to call the service from a Java code so it seems that the problem is not due to the same
                  • 6. Re: GLOBAL DBNAME change
                    sb92075
                    from DB server issue following command & post results back here

                    lsnrctl service
                    • 7. Re: GLOBAL DBNAME change
                      Ramesh_R
                      Yes i could able to connect to the database using the servicename as 'XYZ' not by using the service name 'XYZ.WORLD'
                      • 8. Re: GLOBAL DBNAME change
                        Ramesh_R
                        Hi,
                        Thanks for your reply. Please have the output
                        lsnrctl service
                        LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 12-APR-2010 16:56:51
                        Copyright (c) 1991, 2007, Oracle. All rights reserved.
                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP_ADRESS)(PORT=1521)))
                        Services Summary...
                        Service "XYZ" has 1 instance(s).
                        Instance "XYZ", status READY, has 1 handler(s) for this service...
                        Handler(s):
                        "DEDICATED" established:10 refused:0 state:ready
                        LOCAL SERVER
                        Service "XYZXDB" has 1 instance(s).
                        Instance "XYZ", status READY, has 1 handler(s) for this service...
                        Handler(s):
                        "D000" established:0 refused:0 current:0 max:1022 state:ready
                        DISPATCHER <machine: local_system_host, pid: 25068>
                        (ADDRESS=(PROTOCOL=tcp)(HOST=local_system_host)(PORT=48574))
                        Service "XYZ_XPT" has 1 instance(s).
                        Instance "XYZ", status READY, has 1 handler(s) for this service...
                        Handler(s):
                        "DEDICATED" established:10 refused:0 state:ready
                        LOCAL SERVER
                        Service "PLSExtProc" has 1 instance(s).
                        Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                        Handler(s):
                        "DEDICATED" established:0 refused:0
                        LOCAL SERVER
                        Service "XYZ.world" has 1 instance(s).
                        Instance "XYZ", status UNKNOWN, has 1 handler(s) for this service...
                        Handler(s):
                        "DEDICATED" established:16 refused:0
                        LOCAL SERVER
                        The command completed successfully
                        • 9. Re: GLOBAL DBNAME change
                          sb92075
                          Service "XYZ" has 1 instance(s).
                          Service "XYZXDB" has 1 instance(s).
                          Service "XYZ_XPT" has 1 instance(s).
                          Service "PLSExtProc" has 1 instance(s).
                          Service "XYZ.world" has 1 instance(s).
                          Please NOTE Case of "world" in line above; "WOLRD" not equal "world"
                          • 10. Re: GLOBAL DBNAME change
                            Ramesh_R
                            Is the service name case sensitive. ?
                            Even after having the proper case from the java code i had the same error
                            • 11. Re: GLOBAL DBNAME change
                              sb92075
                              Even after having the proper case from the java code i had the same error
                              It is difficult to debug code that can not be seen.
                              :-(
                              • 12. Re: GLOBAL DBNAME change
                                Ramesh_R
                                If you need the java client code i am ready to provide.
                                But the problem is could able to connect to the same DB instance using the 'XYZ' as service name but unfortunately not by using XYZ.world as service name
                                The problem is not with the client code. The problem is with the Db which could not able to provide a connection
                                • 13. Re: GLOBAL DBNAME change
                                  sb92075
                                  Post Operating System (OS) name & version for DB server system.
                                  Post results of
                                  SELECT * from v$version
                                  • 14. Re: GLOBAL DBNAME change
                                    Ramesh_R
                                    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
                                    PL/SQL Release 10.2.0.4.0 - Production
                                    "CORE     10.2.0.4.0     Production"
                                    TNS for Linux: Version 10.2.0.4.0 - Production
                                    NLSRTL Version 10.2.0.4.0 - Production
                                    1 2 Previous Next