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

How to Move ORACLE HOME

Posted on
Allow me to ask you a question before going further: why would you like to move ORACLE HOME to another place? You may leave your comment below this post, I am curious about it. As for me, it’s because my client like old-fashioned file structure and don’t like Optimal Flexible Architecture (OFA) to be used, […]
Data Dictionary View

How to Find Largest Segments in Oracle

Posted on
Find Largest 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 largest segments are in our database. […]
Data Dictionary View

How to List All Tables in Oracle

Posted on
USER_TABLES vs ALL_TABLES vs DBA_TABLES
List All Tables You Own To list all tables that belong to you, you can query USER_TABLES which is an Oracle data dictionary view used to look up table information of yours. SQL> conn hr/hr; Connected. SQL> select table_name from user_tables; TABLE_NAME —————————— LOCATIONS COUNTRIES JOB_HISTORY EMPLOYEES JOBS DEPARTMENTS REGIONS 7 rows selected. The listed […]
Shell Script

How to Auto Start Oracle Database on Solaris

Posted on
By default, Oracle software installation does not deploy 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. Turn on startup option in oratab Please change the startup option to “Y” at the last character of the line. […]
Shell Script

How to Auto Start Oracle Database on Linux

Posted on
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. Turning on startup option in oratab Please change the startup option to “Y” at the last character of the […]
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 […]
Job

How to Resolve ORA-23421: job number is not a job in the job queue

Posted on
ORA-23421+ORA-06512
ORA-23421 When I tried to remove a given job from the queue, the statement failed with ORA-23421. C:\Documents and Settings\Administrator>sqlplus / as sysdba … SQL> exec dbms_job.remove(83); BEGIN dbms_job.remove(83); END; *  ERROR at line 1: ORA-23421: job number 83 is not a job in the job queue ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86 ORA-06512: at “SYS.DBMS_IJOB”, […]