Ubuntu Show Date next to Time Indicator

Writing by on Monday, 27 of August , 2012 at 4:25 am

You need to use the dConf Editor to set it up

Step 1: sudo apt-get install dconf-tools
or
Step 1: Ubuntu Software Center – Install dConf Editor

Step 2: com.canonical.indicator.datetime

Step 3: Check the show-date option

Leave a comment

Category: Uncategorized

Oracle Errors ORA-01034 and ORA-27101

Writing by on Tuesday, 7 of August , 2012 at 9:37 pm

Sometimes your disk maybe full and your Oracle might not start up or your just having a bad day with Oracle, your IT dept, the build is broken etc. etc.

Well ./lsnrctl start works fine, but Oracle is still coming back with ORA-01034 and ORA-27101 errors. Apparently Oracle was shutdown and never came up.

$ sqlplus
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Now things should be better. You do know that with Oracle/Linux development work happening, chaos etc. , it won’t be long before you hit some more Oracle related issues. But for now, we’re good!

Leave a comment

Category: SQL DB

Oracle Errors TNS-12560: TNS:protocol adapter error TNS-00584: Valid node checking configuration error

Writing by on Friday, 3 of August , 2012 at 5:59 pm

It’s not surprising to me that after the pain of setting up Oracle, I would be running into further errors at random periods.

[oracle@sk-redhat bin]$ ./lsnrctl start

LSNRCTL for Linux: Version 11.2.0.2.0 – Production on 03-AUG-2012 10:44:45

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Starting /home/oracle/OraHome11g/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 11.2.0.2.0 – Production
System parameter file is /home/oracle/OraHome11g/network/admin/listener.ora
Log messages written to /home/oracle/OraHome11g/log/diag/tnslsnr/sk-redhat/listener/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=15.15.15.15)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00584: Valid node checking configuration error

Listener failed to start. See the error message(s) above…

This time the fault was NOT on ORACLE issue, but rather the IT folks that had made some changes to the VMs and IP addresses etc. and my Invited nodes were not being recognized.
Check whether the entries in the following files are correct.

[oracle@sk-redhat bin]$vi /home/oracle/OraHome11g/network/admin/sqlnet.ora
[oracle@sk-redhat bin]$ su root
[root@sk-redhat bin]$ vi /etc/hosts

Ensure that IP Addresses and Hostnames and respective mappings are all accurate and everything is reachable.

Leave a comment

Category: Tips and Tricks

Shivdev Kalambi's Blog

Shivdev Kalambi is a Software Development Manager, previously a Principal Software Engineer at ArcSight/HP. With over 16 years' experience in software development, he's worked on several technologies and played different roles and contributed to all phases of projects. Non-tech activies include Ping-pong, Rock Climbing and Yoga at PG, Golf, Skiing, Swimming & a beer enthusiast.