http://weirdoootamee.yolasite.com/resources/oracle%20sql%20expert.pdf
Hope this will helps you to find Oracle Database dumps.
14 Wednesday Oct 2015
http://weirdoootamee.yolasite.com/resources/oracle%20sql%20expert.pdf
Hope this will helps you to find Oracle Database dumps.
26 Sunday Apr 2015
Posted Oracle Database
inORA-00020 comes under “Oracle Database Server Messages”. These messages are generated by the Oracle database server when running any Oracle program.
Reference: Oracle Documentation
How to increase PROCESSES initialization parameter:
1. Login as sysdba
sqlplus / as sysdba
2. Check Current Setting of Parameters
sql> show parameter sessions
sql> show parameter processes
sql> show parameter transactions
3. If you are planning to increase “PROCESSES” parameter you should also plan to increase “sessions and “transactions” parameters
A basic formula for determining these parameter values is as follows:
processes=x
sessions=x*1.1+5
transactions=sessions*1.1
4. These paramters can’t be modified in memory. You have to modify the spfile only (scope=spfile) and bounce the instance.
sql> alter system set processes=500 scope=spfile;
sql> alter system set sessions=555 scope=spfile;
sql> alter system set transactions=610 scope=spfile;
sql> shutdown abort
sql> startup
31 Sunday Aug 2014
1. Switch to root user (If not in already):
$ su –
Enter password
2. Type the below command as root user:
# export DISPLAY=machine:0.0;
3. Check it is set or not by entering the below command:
#echo $DISPLAY
4. Disable the hostname access
# xhost + (or) # xhost + hostname
5. Check GUI is working or not by entering the below command:
# xclock
6. Switch to normal user :
# su – username
Enter password
7. Type below commands to access the GUI:
$ xhost +
8. Type xclock command in the command prompt
Note: If we need the same GUI in windows machine, need to install X client or windows related display tools.
10 Saturday May 2014
Posted Oracle Database
inInstance Name:
Select instance_name from v$instance;
Database Version:
Select version from v$database;