SSH Encrypted TOAD

Thanks to a post over at OraFAQ, I was able to encrypt a TOAD connection using SecureCRT.

Lest I forget:

Options >> Session Options

Port Forwarding >> Add

Name: something

Port: 1521

Port: 1521

Open up toad.  Use localhost for hostname.   

Fun with clntsh

Installing iAS 10.1.2.2 onto an Oracle oms grid control box.

Got the following error during linking, looks to be a Solaris 10 + 10R2 issue.

ld: fatal: file /u01/app/oracle/product/oms10g//lib32//libclntsh.so: unknown file type
ld: fatal: File processing errors. No output written to webcached
*** Error code 1
make: Fatal error: Command failed for target `webcached'

Here's the fix:

Edit $ORACLE_HOME/genclntsh
Change LD="ld -m -i -G -z text -L${ORACLE_HOME}/${LIB}"
to LD="ld -m -i -G -z text -L${ORACLE_HOME}/${LIB} -Bsymbolic"

Then run $ORACLE_HOME/bin/genclntsh

Then retry the linking phase.

What the heck is ocssd.bin?

On a 10.1.0.5 db system we were patching, we saw a process we didn't expect to be running.

[oracle@omsdb:/u01/app/oracle/stage/patch/cpu2007apr/5901877]# ps -ef | grep ora
  oracle   486     1  0   Mar 21 ?        0:03 /u01/app/oracle/product/10.1.0/bin/ocssd.bin
 jmorast 12755 12753  0 10:41:35 ?        0:00 /usr/local/sbin/sshd -R

A slight bit of research reveals the following from Frank Naude.

It appears this process is part of Oracle Cluster Synch Service Daemon, even though RAC and ASM aren't in use.

Solve the immediate issue by running this command from root:

/etc/init.d/init.cssd stop

A permanent fix is to comment out the following line in /etc/inittab and reboot the
server:

h1:35:respawn:/etc/init.d/init.cssd run >/dev/null 2>&1