Another way to connect and to test is to get the Oracle JDBC and a simple jdbc client like xigole jisql (and JAVA). If you tns listener is listening, then you can connect with that. This helps sort out client from server side problems. JDBC is free and compatible for all platforms and RDBMS.
I use the open source JDBC GUI SQuirreL on all RDBMS. It is free, many featured, and most of the skills you build transfer between RDBMS.
Last edited by DGPickett; 02-07-2011 at 02:55 PM..
1> Did you check your alert.log file for oracle .What does it say ?
2> Did you configure the parameters in the system . On Solaris it is as follows
Code:
oracle_START (do not remove)
set noexec_user_stack=1
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=512
set shmsys:shminfo_shmseg=1000
set semsys:seminfo_semmap=5120
set semsys:seminfo_semmni=5118
set semsys:seminfo_semmns=10240
set semsys:seminfo_semmnu=3072
*set semsys:seminfo_semmsl=25
set semsys:seminfo_semmsl=256
*set semsys:seminfo_semopm=10
set semsys:seminfo_semopm=100
set rlim_fd_max=1024
set rlim_fd_cur=512
set semsys:seminfo_semume=128
set semsys:seminfo_semusz=96
set semsys:seminfo_semvmx=32767
set semsys:seminfo_semaem=16384
* oracle_END (do not remove)
You also need to modify PAM (Plugable Authentication Module) configuration files to increase the session limits for the oracle user. Add the following line to /etc/pam.d/login if it does not already exist:
Code:
session required pam_limits.so
and add the following lines to /etc/security/limits.conf:
Code:
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
Finally, I suggest you disable SELINUX until everything else if working
If /etc/security/limits.conf does currently exist on your system, then create this file with the appropriate permissions.
I just started a new semester and I started my UNIX class yesterday. I've already decided to use python along with my learning process but what I really want to use with it is Kali as my UNIX/Linux platform to learn off of since I already wanted to learn Cyber Sec. anyways. I just wanted to know if... (12 Replies)
Hi Friends,
Can someone help me with below issue , thanks.
Subject : Unable to configure "Reliance NetConnect" on RHEL 5
Here some helpful information :
# lsusb
Bus 001 Device 001: ID 0000:0000
Bus 001 Device 002: ID 8087:0020
Bus 001 Device 003: ID 192f:0416
Bus 002 Device... (0 Replies)
Hello everybody, the reason why im posting this thread is because i've installed an oracle test database on RHEL 5, on a localhost (Since it is for test)... the thing is, after i have installed the DB it works just fine, but after i re start it, i get the following errors when i want to go into the... (5 Replies)
ISSUE: The system is unable to register with Redhat network (RHN).
SYSTEM DETAILS: RHEL6 (2.6.32-131.2.1.el6.x86_64). The firewall is turned off. I have network connectivity. There is no GUI. All work is done from the command line.
The following files are installed:... (4 Replies)
Hi,
I use red hat linux ES 5.5 32 bit .
There is x win(startx) installed.
I wan to use XP at another computer and connect the x-win(startx) through IP network .
Which software/freeware I can use ???
Please advice ..
Is it free ??? (0 Replies)
Hi ,
Am trying to install oracle 10g client on Red Hat Linux in an IBM PPC machine.
when i try to install during linking am getting the below error
My software details :
Oracle Version : 10.2.0
Red Hat Version : 5.5
Server Hardware : PPC 64
Error from the logs :
/usr/bin/make -f... (7 Replies)
I use redhat linux enterprise 4 ,
I setup and enable the xdmp already.
I want to use XMing in window XP to connect to x server in this red hat linux and start the x-window .
But I fail as it is no response from red hatl inux and time out ...
Please advice what I need to do in the linux OS ??? (1 Reply)
I just bought a new pc and my unix software is installed on my old computer. I want to take the hard disk outta my old pc and then install it on my new pc so my new pc has 2 hard drives.
now, after my pc new has 2 hard drives, one being unix the other being windows xp, i want to be able to... (7 Replies)
Ok here is my problem i do not know the command to load a driver for my network card in Ted hat linux 6.0 could sombody give me a hand. and if there is anyone that has a list of commands for red hat that would be great also (2 Replies)