How to find whether parameter is static or dynamic?

ISSYS_MODIFIABLE column display value FALSE its mean that db bounce is require.if it
is IMMEDIATE then database bounce not require.


IMMEDIATE: database bounce not require.
FALSE:  database bounce require.
SQL> select ISSYS_MODIFIABLE from v$parameter where name like '%control_files%';

ISSYS_MOD
---------
FALSE

SQL> select ISSYS_MODIFIABLE from v$parameter where name like '%open_cursors%';

ISSYS_MOD
---------
IMMEDIATE

SQL> select ISSYS_MODIFIABLE from v$parameter where name like '%undo_tablespace%';

ISSYS_MOD
---------
IMMEDIATE

SQL> select ISSYS_MODIFIABLE from v$parameter where name like '%log_archive_dest%';

ISSYS_MOD
---------
IMMEDIATE

terminating instance due to error 474/ORA-00474

Cause:


When  user killed smon process using kill -9 <pid> you will get this error in the alert log file.

Errors in file /u01/home/oracle/product/10.2.0/db_1/admin/PROD/bdump/prod_pmon_26800.trc:
ORA-00474: SMON process terminated with error
Mon Feb 25 15:51:26 2013
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 26800

terminating instance due to error 472/ORA-00472

Cause:
When  user killed pmon process using kill -9 <pid> you will get this error in the alert log file.

MMAN: terminating instance due to error 472
ORA-00472: PMON process terminated with error
Instance terminated by MMAN, pid = 26700.


Thanks for visiting my blog.

ORA-01081: cannot start already-running ORACLE - shut it down first

On one server/Linux machine you have many instance's/database up and running and in such cases you have to export the ORACLE_SID
and connect to sql prompt.

[oracle@devuser dbs]$ export ORACLE_SID=ebsofdp
[oracle@devuser dbs]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Feb 23 14:08:45 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: /as sysdba
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 188743680 bytes
Fixed Size 1218412 bytes
Variable Size 67111060 bytes
Database Buffers 113246208 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.
SQL> select name,created from v$database;

NAME CREATED
--------- ---------
EBSOFDP 22-FEB-13

SQL>


Thank you for visiting my blog.

ORA-01555: snapshot too old

you will get the above error if a long running query unable to get read consistent image.
To resolve issue add space in the undo tablespace.

ORA-01078: failure in processing system parameters

What happens when you don't have parameter file?

SQL> startup

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/u01/oracle/11.1.0/dbs/initebsofdp.ora'

SQL

When you give startup command it will search for spfile<sid>.ora file from $ORACLE_HOME/dbs location .If it is not found then it will search for spfile.ora file.if not found then it will search for init<sid>.ora file and then init.ora .if it is not found you will get below error .

if you have backup parameter file just copy to $ORACLE_HOME/dbs location and give startup .

it will start your database.

ORA-00205: error in identifying control file, check alert log for more info

if you have backup of controlfile just restore it or copy it.let me create a scenario and move the controlfile
so that what error i will get and how can we restore it .



[oracle@ebsofdp ebsofdp]$ mv control01.ctl control01.ctl_12jan2013
[oracle@ebsofdp ebsofdp]$ ls -tlrh
total 1.6G
-rw-r----- 1 oracle dba  29M Jan 10 17:25 temp01.dbf
-rw-r----- 1 oracle dba  51M Jan 12 17:20 redo02.log
-rw-r----- 1 oracle dba  51M Jan 12 17:20 redo01.log
-rw-r----- 1 oracle dba 5.1M Jan 12 17:21 users01.dbf
-rw-r----- 1 oracle dba  76M Jan 12 17:21 undotbs01.dbf
-rw-r----- 1 oracle dba  11M Jan 12 17:21 tz01.dbf
-rw-r----- 1 oracle dba 701M Jan 12 17:21 system01.dbf
-rw-r----- 1 oracle dba 601M Jan 12 17:21 sysaux01.dbf
-rw-r----- 1 oracle dba  51M Jan 12 17:21 redo03.log
-rw-r----- 1 oracle dba 9.3M Jan 12 17:21 control03.ctl
-rw-r----- 1 oracle dba 9.3M Jan 12 17:21 control02.ctl
-rw-r----- 1 oracle dba 9.3M Jan 12 17:21 control01.ctl_12jan2013
[oracle@ebsofdp ebsofdp]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Sat Jan 12 17:23:56 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  839282688 bytes
Fixed Size                  2149040 bytes
Variable Size             440403280 bytes
Database Buffers          390070272 bytes
Redo Buffers                6660096 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL>

The more information can also be get from v$controlfile and alert_<sid>.log file.

Go to cd $ORACLE_HOME/dbs locatioion  and open pfile 

and put the entry control01.ctl_12jan2013 instead of control01.ctl OR if you have multiple controlfile copy it other locaton and now startup your database.Make sure there is no spfile in dbs location.

SQL> startup

ORACLE instance started.

Total System Global Area  839282688 bytes

Fixed Size                  2149040 bytes

Variable Size             440403280 bytes

Database Buffers          390070272 bytes

Redo Buffers                6660096 bytes

Database mounted.

Database opened.

SQL> 

Valid for Sun solaris

Issue:

oradism creation failed for unknown reasons 0 8 63931
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
  Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 63931
WARNING: -------------------------------

Database Crash With ora-4030 Using ORADISM and With 'oradism creation failed' message. [ID 1323264.1]

Oracle Metalink Note ID: 1011995.6

Cause:permision got changed for oradism.

Action:

This is the real cause of those warnings.

As per metalink note 374367.1:

1- cd $ORACLE_HOME/bin

2- chmod 4550 oradism

3- chmod g+s oradism

4- chown root:dba oradism 

5- Bounce the database

For further information refer the Oracle Metalink Note ID: 1011995.6 Subject: COMMON ORACLE PERMISSION PROBLEMS ON UNIX.

Error: ORA-01658

Issue: ORA-01658: Unable to create INITIAL extent for segment in tablespace

Metalink ID: ORA 1658 "unable to create INITIAL extent for segment in tablespace %s" [ID 33290.1]

Action:  Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

Error : ORA-01536

Issue: ORA-01536: Space quota exceeded for tablespace 'USERS'

Metalink ID:General SQL Error. ORA-01536: Space Quota Exceeded For Tablespace 'XXXXX_XXXX' [ID 892973.1]

Action:  ALTER USER scott QUOTA UNLIMITED ON USERS;

Cause:quota exceeded

After allocating space please run below query.

select username, tablespace_name, max_bytes from dba_ts_quotas where username='SCOTT';

It should return a value of -1 for MAX_BYTES which indicates unlimited tablespace

Error: ORA-1691

Issue: unable to extend lobsegment SABRIX.SYS_LOB0001174451C00011$$ by 311072 in tablespace    SABRIX_DATA

MetaLink ID:When Booking Order Get ORA-1691: Unable To Extend Lobsegment Aso.Sys_lob00000XXXX$$ [ID 397470.1]

Action:

Please verify if tablespace is full.

If it is,ask your DBA to resize the tablespace by adding additional 2 Gigs of space.

Error: ORA-01654

Issue's:
ORA-1654: unable to extend index APPLSYS.FND_LOGINS_U1 by 16 in tablespace APPS_TS_ARCHIVE
ORA-1654:unable to extend index GEPSFND.GEPS_FND_ERR_TBL_N2 by 128 in tablespace GEPSFNDX

Metalink id: ORA 1654 unable to extend index <name.name> by <num> for tablespace <nam [ID 19049.1]


Cause:  Failed to allocate an extent of the required number of blocks for an index segment in the tablespace indicated.
Action:  Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

Hi Welcome to my Oracle World

Tomorrow will never come 

If you don't spend today well, too