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