Connected to an idle instance.
ORACLE instance shut down.
Connected to an idle instance.
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod01)(PORT=1523)))'
CREATE CONTROLFILE REUSE SET DATABASE "PREPRO01"
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


alter database open resetlogs
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


alter tablespace TEMP1 add tempfile '/u01/oracle/PREPROD/db/data/temp01.dbf' REUSE
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


alter tablespace TEMP2 add tempfile '/u01/oracle/PREPROD/db/data/temp02.dbf' REUSE
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


alter tablespace TEMP1 add tempfile '/u01/oracle/PREPROD/db/data/temp0001.dbf' REUSE
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


ALTER DATABASE RENAME GLOBAL_NAME TO "PREPRO01.sunresort.local"
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Connected to an idle instance.
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod01)(PORT=1523)))'
BEGIN dbms_backup_restore.zeroDbid(0); END;

*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


ORACLE instance shut down.
Connected to an idle instance.
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod01)(PORT=1523)))'
CREATE CONTROLFILE REUSE SET DATABASE "PREPRO01"
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


alter database open resetlogs
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


alter tablespace TEMP1 add tempfile '/u01/oracle/PREPROD/db/data/temp01.dbf' REUSE
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


alter tablespace TEMP2 add tempfile '/u01/oracle/PREPROD/db/data/temp02.dbf' REUSE
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


alter tablespace TEMP1 add tempfile '/u01/oracle/PREPROD/db/data/temp0001.dbf' REUSE
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


ALTER DATABASE RENAME GLOBAL_NAME TO "PREPRO01.sunresort.local"
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


