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 […]

Hi, I faced an issue where one of my HP-UX server’s partition became full and won’t let it fully boot. I’ll describe the steps I did the resolve the issue. Reboot the server and cancel the HP-UX boot when you get the 10 seconds cool down by pressing any key. On Itanium server, you’ll face […]

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 […]