Technical Notes

We're all on the same page!

Friday, 10 October 2014

How to define a new Linux user?

›
# useradd -d /home/alper -g gpalper -s /bin/csh -m alper -u 1008 # passwd alper To check it: $ egrep -i "^alper" /etc/passwd ...

How to see that a package and a program exists in SUSE Linux ?

›
for package; $ rpm –ql test_package   or  $  rpm –qa test_package for program; $ whereis test_program

How to resolve "Enterprise Manager Agent status is Unavailable" issue in Linux?

›
Please run below commands as oracle system user. emctl clearstate agent   emctl upload agent

[SOLUTION] ORA-28003 problem

›
Please execute the command as " sys "; SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION NULL;

How to see related user process in Linux?

›
In command window; $ ps –u alper (“alper”, linux system user)

[SOLUTION] ORA-00845 problem

›
By default /dev/shm is created to use half size of your server physical memory If you see that MEMORY_TARGET not supported on this syst...

How to change oracle max connection limits for "maximum connection exceed problem"?

›
$ sqlplus Enter user-name: sys as sysdba @sys to see parameter process for altering system sessions (processes (integer) = sessions) SQ...

How to drop a user from database in Oracle?

›
Please login to database server with ssh as oracle user and run that commands. sqlplus / as sysdba SQL > DROP USER testuser CASCADE...

How to see the size of users on specific tablespace in Oracle?

›
Please execute following command as " sys "; SELECT tablespace_name, owner, segment_type "Object Type",        COUN...

How to login sqlplus on linux command window in Linux?

›
$ sqlplus scott/tiger @orcl @orc1 ->  tnsnames.ora – connection node name scott -> db username tiger -> db username password  ...

How to see tablespace usage for Oracle Database?

›
Please execute following commands as " sys "; select b.tablespace_name, tbs_size SizeMb, a.free_space FreeMb  from  (select t...

How to add a alias for using by all users in Linux?

›
Please edit /etc/bash.bashrc , for example; alias c='cd'   alias a='dir' alias l='ls -l' alias p='cd -...

How to trace Linux CPU usage on system?

›
mpstat -P ALL 20  Shows that CPU usage information related to each core and all cpu in every 20 seconds. sar 10  Shows that CPU usage...

Linux - command line keyboard shortcuts

›
Here are some basic shortcuts while you are in command window; CTRL + a -> go to begin of the line CTRL + e -> go to end of the li...

How to kill a session with custom procedure?

›
-If you are authorized to sys user. Firstly run this procedure to compile and save. --- CREATE OR REPLACE PROCEDURE P_KILL_SESSION(DA...

How to overcome special character problem in Windows?

›
You can type special character with using ASCII Table. eg. If you want to type backslash (\), press ALT + 92 You can reach all ASCII tab...

[SOLUTION] ORA-06550 and PLS-009005 problems

›
Please login to database server with ssh as oracle user and run that commands. sqlplus / as sysdba SQL> grant execute on DBMS_JOB to ...

How to define distribution list in Microsoft Office Outlook?

›
To do that please follows the instructions; Contacts -> New -> Distribution List -> Enter the name of the list and Select Me...

How to revert all sql lines into one line in Ultra Edit and Notepad++ ?

›
For example, you have a long SQL file and you must run it in command line or in such tool or program. For this, you can use Ultra Edit or N...
Thursday, 9 October 2014

How to define network path for Windows Operating System?

›
To do that please follows the instructions; Open My Computer -> Right mouse click -> Select “ Add a new network location ” -> ...
‹
›
Home
View web version
Powered by Blogger.