ORA-1555: SNAPSHOT TOO OLD DUE TO CORRUPTED LOBS
QUESTIONS During schema(s) export or querying a table containing a clob column I recieve the following error ORA-01555: snapshot too old: rollback segment number with name “” too small SOLUTION Usually the ORA-01555 error is related either to the undo retention and the…
INSTALLING ORACLE PREREQUISITE PACKAGES FOR ORACLE DATABASE (Linux)
REQUEST I want to ensure that the Oracle database prerequisites packages are installed. SOLUTION For Oracle Enterprise Linux (OEL) there are default packages that simplify an Oracle database installation, eg oracle-rdbms-server-12cR1-preinstall or oracle-rdbms-server-11gR2-preinstall. They are used to install all prerequisite packages and to…
GENERATING AN ENVIROMENT FILE FROM PL/SQL
REQUEST I want to generate the current Oracle database environment file by querying a database. RELATED GETTING THE VALUE OF AN ENVIRONMENT VARIABLE THROGHT PL/SQL BLOCK SOLUTION ——————————————————- — Victor Khalturin — $Header 14:22 30.01.2018 — — Script generates the current environment…
HOW TO CHECK NLS SETTINGS ON DATABASE, INSTANCE AND SESSION LEVEL
REQUEST I want to find all NLS settings on the database, the instance and the current session level. QUERY SET PAGES 999 SET LINES 300 COL PARAMETER FOR A30 COL DATABASE FOR A30 COL INSTANCE FOR A30 COL SESSION FOR A30 SELECT DB.PARAMETER,…
NETWORKER CLIENT DOES NOT START ON A CLONED VM
PROBLEM Networker does not start after VM cloning if a cloned host with a different hostname. SYMPTOMPS Networker works fine on original VM and does not start on cloned one. Original : original.net Cloned : cloned.net root@original.net: service networker start root@original.net: ps -fe…
GETTING ALL CHILD OBJECTS WITHIN AN OBJECT
QUESTIONS How to fix “PL/SQL: ORA-00942: table or view does not exist” during compilation? How to find out all objects within another object? How to find out all table references in a specific function or procedure? How to find out in what database object…
FINDING OUT WHAT AN ORACLE PROCESS IS DOING
QUESTIONS How to match OS processes to Oracle processes? What a particular OS Oracle process (PID) is doing in an Oracle database? What is an easy way to match the OS PID to the Oracle session? How to find out SQL being executed by…
QUERYING A SERVER’S IP ADDRESS
REQUEST I want to gather a hostname and/or IP address of the current host or a remote one. SOLUTION A hostname and IP address can be retrieved through UTL_INADDR package LOCAL HOST oracle@dbpilot.net: nslookup dbpilot.net Server: 10.1.1.50 Address: 10.1.1.50#53 Name: dbpilot.net Address:…
QUERYING THE ORACLE_HOME PATH FROM A DATABASE
REQUEST I want to get the ORACLE_HOME path by querying the database. RELATED GETTING THE VALUE OF AN ENVIRONMENT VARIABLE THROGHT PL/SQL BLOCK SOLUTION DBMS_SYSTEM COL ORACLE_HOME FOR A30 VARIABLE ORACLE_HOME VARCHAR2(100); EXEC DBMS_SYSTEM.GET_ENV(‘ORACLE_HOME’,:ORACLE_HOME); PRINT ORACLE_HOME ORACLE_HOME —————————— /oracle/product/12.2.0.1 DBA_LIBRARIES…
GETTING THE VALUE OF AN ENVIRONMENT VARIABLE THROGHT PL/SQL BLOCK
REQUEST I want to get a value of the specific environment variable by querying a database. SOLUTION First, define a variable oracle@dbpilot.net: export MYVAR=”My Variable” oracle@dbpilot.net: echo $MYVAR My Variable A value of any variable can be retrieved through DBMS_SYSTEM.GET_ENV procedure COL OS_VAR…
Search
Categories
- Linux (7)
- Networker (1)
- Oracle (44)
- Account (2)
- AWR (1)
- Database Errors (3)
- Datapump (1)
- Enterprise Manager (13)
- Environments (4)
- Interview (1)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- PL/SQL (4)
- UTL_FILE (4)
- Prerequisites (1)
- Redologs (1)
- Segment Shrink (1)
- Session (3)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Statistics (2)