Hi everyone,   This article will describe how to rename and/or move Tablespaces Datafiles.   Put desired Tablespaces offline SQL> alter tablespace tb1 offline normal; SQL> alter tablespace tb2 offline normal; SQL> alter tablespace tb3 offline normal;   OS side, move and rename Datafiles # mv /previous_path/tb1.dbf /new_path/tb1_newname.dbf # mv /previous_path/tb2.dbf /new_path/tb2_newname.dbf # mv /previous_path/tb3.dbf […]

Hello, SQLPlus as SYSDBA remotely can throw the following error due to security reason : >sqlplus sys/syspass@servername/instance as sysdba SQL*Plus: Release Production on Mer. Ao¹t 30 14:25:48 2017 Copyright (c) 1982, 2011, Oracle. All rights reserved. ERROR: ORA-01031: insufficient privileges   To allow to connection, connect locally using SQLPlus and make sure the parameter […]

Today, I was facing an issue where my Veeam Backup job failed on one Oracle Server hosting many Instances. Only one of them was failing and Veeam reported the following error : Processing SERVER_NAME Error: Unfreeze error: [Backup job failed. Cannot create a shadow copy of the volumes containing writer’s data. A VSS critical writer […]

Hello everyone, Today, I had to clone an Oracle server several times. I will not explain the steps but just let you know what I had to do to get Oracle working after this change. The Listener service won’t start. I had to edit its configuration to match to new Server name. Open the Listener […]