remove or trip trailing spaces and new lines from excel

1. Got fronting or trailing lines in spaces in the cell
- user TRIM function in a new column. For example, To trip trailing spaces from column A, use the following command in new column
=TRIM(A1)


2. Remove new line / carriage return from cell contents?

- Use Ctrl+h  (brings up search & replace)
- In the search field, use ctrl+j (opos up return character)
- IN replace field, type the character that you want to replace new line with.
   If you don't want to replace with anything, and just remove the new lines, simply leave it blank
   (don't put spaces, just leave it blank.)

OHS Version httpd: error while loading shared libraries cannot open shared object file: No such file or directory

/httpd: error while loading shared libraries: libexpat.so.0: cannot open shared object file: No such file or directory
Getting errors like below when trying to invoke httpd commands on OHS?

Follow the below steps to get the version without issues



1.
export ORACLE_HOME=xxxxxx
e.g.
export ORACLE_HOME=/u01/app/oracle/product/fmw/Oracle_WT1


2.
export LD_LIBRARY_PATH=$ORACLE_HOME/ohs/lib:$ORACLE_HOME/opmn/lib:$ORACLE_HOME/lib:$LD_LIBRARY_PATH

3.
$ORACLE_HOME/ohs/bin/httpd -version

Change webcache port

I keep forgetting where to change listen ports for webcahce


$ vi $ORACLE_HOME/config/WebCache/webcache1/webcache.xml


Update the relevant port using vi search and replace command:
e.g.
:1,$ s/7789/7799/g

iptables quick recokner

iptables -L -n -v  ## List current rules

iptables -A INPUT -s 107.196.150.48 -j DROP ## Drop all packets from Source IP

iptables -A INPUT -s 107.196.150.48 -j ACCEPT ## Accept all packets from Source IP

iptables -F # Flush IP Tables

Find JVM start arguments of java process on Windows server

Commands to find JVM arguments for java processes running on Windows server.

Many of us work on unix based servers on daily basis and don't even have to think about figuring out so many detail during any investigation or analyses process. But occasionally, we  have to investigate stuff (yeah... technical word that means anything or everything) on Windows server, and we struggle to discover even basic things.

Most common way to figure out JVM related info in on unix:

$ ps -ef | grep java   ## voila.... we get all the info

Will it work on windows..nope. But the below will:

cmd> tasklist  #### this command is equivalent of "ps" on unix based systems, and also return PID of processes.

Once you know the PID, use the below command to get JVm arguments of the java process.

cmd> c:\<path to your java dir>\jcmd <PID> VM.command_line
cmd> c:\<path to your java dir>\jcmd <PID> VM.flags

BEA-001112 java.sql.SQLRecoverableException: IO Error: Connection reset in weblogic

Error:


<Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "VPDDataSource" failed with exception: "java.sql.SQLRecoverableException: IO Error: Connection reset".>


Cause:

There are two scenarios that can result in this error:

1. If it is single instance database:
The DB instance that the jdbc datasource is configured for, was unavailable either due to shutdown or some other issues.

2. If it is RAC databsae:
Both A & B below should be true to receive this error in weblogic.
A. One of the database instance of your cluster/RAC database, that your jdbc session was hooked on to, either died or it was shutdown, and 

B. The JDBC pool is configured as generic datasource, and not as gridlink datasource, 

 

Resolution:

Use RAC databsae to make database highly available, and at also ensure that JDBC datasource is configuerd as gridlink , and not as generic.

BEA-150000 Error when starting Admin Server

Are you writing scripts to start & stop the admin server?


Are you getting below error when trying to start the Admin Server using scripts?

 <Error> <Configuration Management> <xxxxx.na.lzb.hq> <AdminServer> <[STANDBY] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1541099907869> <BEA-150000> <An error occurred while establishing a connection back to the Adminstration Server t3://10.1.2.79:7001 during startup. Since bootstrap succeeded, check that t3://1xx.yy.zz.rr:7001 uniquely identifies the Administration Server.

Here the catch:

If you have set this variable any where in your scripts or property file, you are bound to get the error.

ADMIN_URL=<HOST>:<PORT>

Resolution: ==> Do not set the variable ADMIN_URL anywhere in you startup script or property file.

Repeat the above statement 4 more times again.