Writing by shivdev 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
Category: Uncategorized
Writing by shivdev 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!
Category: SQL DB
Writing by shivdev 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.
Category: Tips and Tricks