Wanted to work on an Oracle-backed project from home last weekend; e.g.,
Warning (2): ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME and LD_LIBRARY_PATH are set and point to the right directories [CORE/cake/libs/model/datasources/dbo/dbo_oracle.php, line 171] ORACLE_HOME and LD_LIBRARY_PATH are environment variables I’d defined in my ~/.bashrc; e.g.,
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh And phpinfo() seems to suggest that it’s OK:
OCI8 Support enabled Version 1.4.1 Revision $Revision: 293235 $ Active Persistent Connections 0 Active Connections 0 Compile-time ORACLE_HOME /usr/lib/oracle/xe/app/oracle/product/10.
Encountered this issue todya/
The verbiage indicates that Oracle is starting up (or down), but waiting doesn’t work.
sqlplus sys/xxxxxxx as sysdba Replace the ‘xxxxxxx’ part with your actual password. If sqlplus command is not found, it’s probably a problem with your environment variables, but that’s another can of worms altogether. Let’s see whether the db can be mounted:
SQL> alter database mount; ERROR at line 1: ORA-01100: database already mounted OK, so the database needs to be opened too, whatever that means:
I installed RHEL today, but to get updates (via yum), a subscription is required. Not CentOS however.
Some Google-ing uncovered this article, which pretty much works, except I had to make a few edits here and there.
# Remove cached packages yum clean all # Create /root/centos/ mkdir ~/centos && cd ~/centos # Import CentOS's GPG key wget http://mirror.centos.org/centos/5.4/os/i386/RPM-GPG-KEY-CentOS-5 rpm --import RPM-GPG-KEY-CentOS-5 # Download packages wget http://mirror.centos.org/centos/5.4/os/i386/CentOS/centos-release-5-4.el5.centos.1.i386.rpm wget http://mirror.centos.org/centos/5.4/os/i386/CentOS/centos-release-notes-5.4-4.i386.rpm wget http://mirror.
The thing I like about Eclipse is its “Open Resource” shortcut. As an IDE, it’s always felt… heavy. I can’t seem to get Mint/Eclipse/PHP Developer Tools to play nice, so I’m trying out this new IDE, Komodo Edit. This doesn’t work so well with CakePHP, but at least there is code completion.
Now, on to the good stuff. You can duplicate “Open Resource” by creating a project and defining a shortcut: