Hi Tom

plans here are to change the windows domain of my oracle server. The parameter service_name looks like it has the SID concatenated to the DB_DOMAIN parameter which is set in my PFile/SPFile. If i change the DB_DOMAIN value in the file will the service_name get updated to the sid and new domain or do i have to manually change the service_name parameter ?

Thanks
Jim

Thanks Tom

as I understand, you can have multiple instance with same SID registered to one listener. So, one SID can be one to many databases/instances. Looks like, the issue is explained in CVE-2012-1675.
Is this correct?

http://seclists.org/fulldisclosure/2012/Apr/204

It is hard to believe how much confusion on this topic. I hope my comments help.

SID is a unique identifier of the instance. In a cluster/RAC configuration you can't have two intances of the same database with the same name. This makes it impossible for the cluster to provide load balancing and connection failover as each instanced has a unique id. This information is provided in the "instance_name" parameter. Thus SERVICE_NAME. In cluster/RAC configuration both instances can have the same service name. This makes it possible to provide transparent application fail-over as well as load balancing across instances. One additional benefit is that when the instance starts, it may register itself the the listener, provided the listener info is in the local_listener/remote_listener db parameter.

I am facing this problemand cant find solution to this. It would be dreat if you can help with this error.

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 10 00:05:50 2018

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

Enter user-name: rew
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name: ewr
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name: ds
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\Users\dcv>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 10 00:06:06 2018

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

Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name: ds
C:\Users\dcv>
C:\Users\dcv>down vote
'down' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\dcv>Open command prompt and execute the below commands:
'Open' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\dcv>
C:\Users\dcv>set oracle_sid=DATABASE NAME

C:\Users\dcv>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 10 00:21:49 2018

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

SQL> conn sys/sys as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error


SQL> shutdown abort
ORA-12560: TNS:protocol adapter error
SQL> startup
ORA-12560: TNS:protocol adapter error
SQL>
C:\Users\dcv>set oracle_sid=orcl

C:\Users\dcv>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 10 00:27:20 2018

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

SQL> conn
Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0


SQL> select * from dual
2 ;
SP2-0640: Not connected
SQL> select * from dual;
SP2-0640: Not connected
SQL>