Got this error while trying to install Jira 4.2 and connect it to Oracle 11g database.
OS : Redhat Linux 5.5
Jira : Jira Version 4.2 Enterprise Standalone
Database : Oracle 11G R2
Java : JDK 6u37
Attempting to connect to the Oracle database server...
Could not connect to the DB: The Network Adapter could not establish the connection.
The driver oracle-jdbc-5.jar is also available.
I have oracle and Jira in the same system only. But i cant connect it. Please tell me how to solve this.
Its quite clear now that the when you are running the program or script, linux is not able find it under /usr/local/bin then /bin, /usr/bin and finally in /home/myname/bin.
To add these to your PATH variable , edit the .profile file add the values and at the end, after running the $echo PATH command , the o/p should look something like -
You need to check whether your environment variables are set properlyy-
$echo ORACLE_HOME (Path to oracle home)
$echo PATH (See that '$ORACLE_HOME/bin' is in $PATH variable)
If you can't see the oracle home directories on running above commands, then you haven't set the environment variables.\
Set the environment variable -
And now you can run the command 'lsnrctl start' or 'lsnrctl status' command.
Please refer this guide -
Hope it works finely.
I edited ./profile in /etc and when i gave echo $PATH,i got the following output.
After this i tried giving ls -l
It is working now...Thank you very much..:):)
But still i cannot give lsnrctl command...'Command not found' error is thrown..
Please help me how to connect to oracle database...
I tried starting the listener. But got this error
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora11g.home.com)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 99: Cannot assign requested address
How should i solve this...
Thanks in advance...
Try pinging the above host name 'ora11g.home.com' by this command - ping ora11g.home.com. If its giving error like "Check the name..." then try pinging with the underlying IP address. If you are able to ping with the IP address then change the listener.ora by replacing the host name with the underlying IP adress
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG