Impacts of kernel parameter on oracle server ?
On SGA(Shared Global area) on oracle server
Impacts on the total number of users and files in the database
Impacts the number of users and the ability to use some optional features.
To see all kernel parameters value on your system . execute the following command.
su – root
sysctl -a
Published by Paresh Sarma //
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘D:\\ORACLE\\PRODUCT\\10.2.0\\DB_1\\DATABASE\\INITORCL.ORA’
SQL> create pfile from spfile=’D:\\oracle\\product\\10.2.0\\db_1\\dbs\\SPFILEORCL.ora’
;
File created.
SQL> startup
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250452 bytes
Variable Size 197135212 bytes
Database Buffers 411041792 bytes
Redo Buffers 2940928 bytes
Database mounted.
Database opened.
SQL>
Published by Paresh Sarma //
Today while I am going to startup my database , I found the following error
SQL> startup
ORA-12638: Credential retrieval failed
I have edited the sqlnet.ora file and modified the same as follows
Before – SQLNET.AUTHENTICATION_SERVICES= (NTS)
After – SQLNET.AUTHENTICATION_SERVICES= (NONE)
After modification , I perform the following operation to bring the database open
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut [...]
Published by Paresh Sarma //
Oracle database backup is an important role for oracle DBA.
Physical Backups
Oracle database physical backup includes of backing up the physical files as
Datafiles
Archived redo logs
Control files
Network files (tnsnames.ora,listener.ora,sqlnet.ora)
Parameter file
Physical backups are made on the disk or on the tape devices.
Logical Backups
Oracle database logical backup made using export utility (using exp or expdb command ).
Logical backup contain [...]
Published by Paresh Sarma //
To monitor background jobs on UNIX, you can use the following commands :
jobs
ps
jobs command
jobs command will list all the jobs running in the background as follows:
[1] – 12427 Running test.pl
[2] + 12540 Stopped myprog.pl
The value within “[]” is the job number. By this number you can control our jobs, like you can kill [...]
Published by Paresh Sarma //
UNIX job monitoring and control facilities allows you to monitor the jobs executed on background and bring the jobs on foreground . Here I like to described different command used to control your jobs on background as well as foreground.
Commands to control your jobs on UNIX systems
jobs - This command check the status of the [...]
Published by Paresh Sarma //
Is your background jobs on Unix impact on System Performance?
Yes, but it depends upon the priority of the job and how much RAM they require to run. Large jobs like you are downloading a huge file from the web, can consume immense amount of RAM which can be very painful for your system performance . [...]
Published by Paresh Sarma //
Database cloning is a procedure to create an exact copy of a database.
As an oracle DBA,you have to update test or development environments from production database using database cloning procedure.
Following is the steps to clone oracle database.
1. Take a copy of the production database’s initialization file .
2. Take a backup of the production database’s control [...]
Published by Paresh Sarma //
In some scenarios, if a user accidentally deleted rows of a table and as a DBA you have to recover the table to point in time . How you can recover the rows without using more time -consuming tablespace point-in-time recovery operation? Flashback Table allows us to recover one or more tables to specific point [...]
Published by Paresh Sarma //
In some scenarios , my database may be hung and as a DBA ,I have terminate all Oracle processes associated with my hung database.
Steps to kill oracle process and release memory associated by oracle server
1. Kill all Oracle processes associated with the ORACLE_SID
Executing following command we can check all oracle process associated with the database.
# [...]
Published by Paresh Sarma //
