Administration

How to Move Oracle Database

Posted on
Actually, this topic “How to Move Oracle Database” follows my previous post: How to Move ORACLE HOME. But I think it can be used in any moving operations. Generally speaking, this post will include the following subtle topics: How to move spfile How to move control files How to move database files How to move […]
Data Dictionary View

How to Find Biggest Segments in Oracle

Posted on
Find Biggest Segments A segment in Oracle database is a set of extents that contains all the data for a specific logical storage structure within a tablespace. Which means segments contain not only metadata but real data. Normally, segments include tables, indexes and large objects, etc. Let’s see what biggest segments are in our database. […]
Data Dictionary View

Oracle Show Tables in a List

Posted on
Scope of Views on DBA_TABLES, ALL_TABLES and USER_TABLES
In this post, we will talk about three different views that can make Oracle show tables within defined scope, they are: Oracle Show Tables that You Own in a List Oracle Show Tables that You Can Use in a List Oracle Show Tables for Whole Database in a List Later on, we will talk about […]
Shell Script

How to Auto Start Oracle Database on Linux

Posted on
For Solaris OS, you should check this post: How to Auto Start Oracle Database on Solaris. By default, Oracle software installation does not deploy automatic startup and shutdown init scripts on the platform, you have to create them by yourself. Here I introduce my scripts for you to use or modify with. oratab in Linux […]
Startup and Shutdown

How to Resolve ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener

Posted on
ORACLE_HOME_LISTNER is not SET Got this error when I used dbstart to startup all required instances: ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener. This is because dbstart takes the first argument of this command as the database home path for listener to startup. Which means, this command will start both database and […]
Scheduler

How to Resolve ORA-27492: unable to run job: scheduler unavailable

Posted on
Error ORA-27492 Found error ORA-27492 when executed a tuning job. BEGIN   SYS.DBMS_SCHEDULER.RUN_JOB     (job_name             => ‘SYS.SQLTUNE_JOB_61535_2043’     ,use_current_session  => FALSE); END; Error at line 2 ORA-27492: unable to run job “SYS”.”SQLTUNE_JOB_61535_2043″: scheduler unavailable ORA-06512: in “SYS.DBMS_ISCHED”, line 209 ORA-06512: in “SYS.DBMS_SCHEDULER”, line 594 ORA-06512: in line 2 […]