Resuming Screen

I usually using screen command for my work on machine. It works when I lost my connection to my machine, my job could be continued. But some case, my screen not detached. This is my solution when the screen still attached. Fist of all, check your screen status with command "screen -ls"

1. Use screen -D. Just type "sceen -d (ppt/tty number)"
2. If number 1 failed. So you need to kill the process. What process number? 

"ps -ef | grep screen"
noted the number where the pty/tty is " screen -r 123.tty.DEVMRCAP"
"ps -ef  | grep (process number)
noted the process number
"kill -9 (process number)

Believe me, it works :D

Troubleshoot : Can't Access DB From Some Node/TOAD

Symptom :

Yesterday I had case, my developer can't access db with TOAD but he can access it on machine.

Solutin :

Check : $TNS_ADMIN/sqlnet.ora

There are lines :

tcp.validate_checking = yes

tcp.invited_nodes = ....

First line is sett db should check node who can access db. yes means db machine would check who access the db.

Second line is define nodes who accepted to access db.

Both of lines is addition, after install db, the lines is not exist, we should add those lines for security issue.

How To Change Sysadmin Password

Sometime we lost sysadmin password. So this article i will define steps of “how we can change sysadmin user password” .For to can change sysadmin user password, we have 2 options:

1. We can use E-Business suite screens (if we know old password)

2. We can use FNDPASS utulity(whether we have old password or not)


Please follow below steps for can change sysadmin user password:

1. If we want to change sysadmin user password with E-Business suite

Login to EBS  than:

System Administrator -> User -> Query the desired USERNAME and in password tab enter the new password.

To test,relogin into the applications as the SYSADMIN user and thenew password. 
Verify that a concurrent program such as Active Users runs.

2. If we want to change sysadmin user password with FNDPASS utulity

Keep all services running.
Login  OS level by way of the applmgr user and source(run)n your environment scripts
cd $APPL_TOP
run APPSORA.env

cd $FND_TOP/bin
Run FNDCPASS to change the SYSADMIN password

FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN <New Password>

Example:

FNDCPASS apps/apps 0 Y system/manager USER sysadmin/sysadmin123

Restart the Apache, Forms, Reports, 8.0.6 listener and concurrent manager services. << This step not mandotary,but recommended
To test, login to EBS as the SYSADMIN user with new password. 
Verify that a concurrent program such as Active Users runs.

Reference:

How To Change The Password For The SYSADMIN User [ID 423274.1]

How to Change Applications R12 Passwords using Applications Schema Password Change Utility (FNDCPASS)? [ID 437260.1]