IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial

Tag Archives: undo_tablespace

Oracle Database 12c Parameter Files ( Spfile & Pfile )

Mehmet Salih Deveci March 19, 2019 Oracle 13

Hi, In this article, I will explain the parameter files that are very important for Oracle database. This parameter is created when opening the Oracle instance and then we can …

PRVF-0002 : could not retrieve local node name

Mehmet Salih Deveci March 1, 2019 ORA-ERRORS 3

Hi, You can take PRVF-0002 : could not retrieve local node name error when you install Oracle database 12c R2.

ora-01555: snapshot too old: rollback segment number

Mehmet Salih Deveci March 1, 2019 ORA-ERRORS 0

Hi, If you get ORA-01555: snapshot too old error when you execute any query, then you have a problem with undo management or undo tablespaces.