Diferencias

Muestra las diferencias entre dos versiones de la página.

--- aprendiendo_sap:start [2018/05/30 19:48] – [Modificaciones] cayu
+++ aprendiendo_sap:start [2018/05/30 20:16] – [Modificaciones] cayu
@@ Línea 793: / Línea 793: @@
 Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
-Connected to database CCP (DBID=497546318)
+Connected to database <OLDDBID> (DBID=497546318)
 Connected to server version 12.1.0
 Control Files in database:
-    /oracle/<OLBDBID>/origlogA/cntrl/cntrl<OLBDBID>.dbf
+    /oracle/<OLDDBID>/origlogA/cntrl/cntrl<OLDDBID>.dbf
-    /oracle/<OLBDBID>/origlogB/cntrl/cntrl<OLBDBID>.dbf
+    /oracle/<OLDDBID>/origlogB/cntrl/cntrl<OLDDBID>.dbf
-    /oracle/<OLBDBID>/sapdata1/cntrl/cntrl<OLBDBID>.dbf
+    /oracle/<OLDDBID>/sapdata1/cntrl/cntrl<OLDDBID>.dbf
 Change database name of database <OLBDBID> to <NEWDBID>? (Y/[N]) => Y
 Proceeding with operation
-Changing database name from <OLBDBID> to <NEWDBID>
+Changing database name from <OLDDBID> to <NEWDBID>
+    Control File /oracle/<OLDDBID>/origlogA/cntrl/cntrl<OLDDBID>.dbf - modified
+    Control File /oracle/<OLDDBID>/origlogB/cntrl/cntrl<OLDDBID>.dbf - modified
+    Control File /oracle/<OLDDBID>/sapdata1/cntrl/cntrl<OLDDBID>.dbf - modified
+    Datafile /oracle/<OLDDBID>/sapdata1/system_1/system.data - wrote new name
+    Datafile /oracle/<OLDDBID>/sapdata7/undo_1/undo.data - wrote new name
+    Datafile /oracle/<OLDDBID>/sapdata1/sysaux_1/sysaux.data - wrote new name
+...
 </code>
+<code>
+# orapwd file=$ORACLE_HOME/dbs/orapw<SID> password=<PASSWORD>
+</code>
+<code>
+SQL> STARTUP NOMOUNT
+SQL> CREATE SPFILE='/oracle/<NEWSID>/12102/dbs/spfile<NEWSID>.ora' FROM 	PFILE='/oracle/<NEWSID>/12102/dbs/init<NEWSID>.ora';
+File created.
+SQL> ALTER SYSTEM SET DB_NAME=<NEWSID> SCOPE=spfile;
+System altered.
+SQL> startup open
+SQL> alter database rename global_name to <NEWSID>.WORLD;
+SQL> update global_name set global_name = '<NEWSID>';
+SQL> commit ;
+SQL> STARTUP NOMOUNT
+SQL> ALTER SYSTEM SET DB_NAME=<NEWSID> SCOPE=spfile;
+System altered.
+SQL> alter system set instance_name=<NEWSID> scope=spfile;
+</code>
 === Conectividad interna ===
 Deberemos modificar el nombre del host de nuestro servidor, para que se adapte al **SID** que necesitamos y también deberemos ajustar su resolución local en el archivo ///etc/hosts//.