Sponsored Content
Operating Systems Solaris How to access Oracle DB on Linux from Solaris? Post 302901891 by newborndba on Friday 16th of May 2014 08:52:42 AM
Old 05-16-2014
I ended up downloading Oracle client 11.2.0 and installed it on Solaris where application is installed. Please bare with me since I am fairly new to oracle and don't know even 2 % about it. Questions that I have in mind.

1) Which account I have to create (since you mentioned to create an account)?
2) How do I even connect from Solaris machine and access Oracle DB on linux?(steps)
3) I also don't have instance running on solaris and I can't do sqlplus as sysdba because it just hangs.
4) Do I have to update tnsnames.ora file in Solaris with linux system's information (Oracle sid, hostname port number etc)?
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Need help to access/mount so to access folder/files on a Remote System using Linux OS

Hi I need to access files from a specific folder of a Linux system from an another Linux System Remotely. I know how to, Export a folder on One SCO System & can access the same by using Import via., NFS in the Sco Unix SVR4 System using the scoadmin utility. Also, I know to use mount -t ... (2 Replies)
Discussion started by: S.Vishwanath
2 Replies

2. UNIX for Dummies Questions & Answers

oracle database on solaris and linux

what is the difference in running oracle database on solaris and linux operating system (3 Replies)
Discussion started by: ganga
3 Replies

3. Shell Programming and Scripting

Script to drop oracle DB users on HP, LINUX, SOLARIS

Hi everybody, i need help from all of you. I have many users who are no more work in our Company. Some who get objects are Locked. There Many users and many Database Servers. And it'll take long for me to finished this job. That's why i need your help to provide me anyone Scripts... (2 Replies)
Discussion started by: Sonson
2 Replies

4. UNIX for Advanced & Expert Users

Access to particular IP's from the solaris/LINUX server

Hi All, I have a scenario here where in I need to allow a user from the server(Solaris or LINUX) to be able to ssh to a particular set of IP's. Eg:user1 should be able to access IP's 10.26.32.2,10.26.32.7,10.26.32.9 user2 should be able to access IP's 10.1.1.2,10.1.1.4(just an example) ... (2 Replies)
Discussion started by: pk123
2 Replies

5. Solaris

Can't access NFS Share on Solaris Server from a Linux Client

Hi, I am trying to access a NFS shared directory on Solaris 10 Server from a client which is RHEL 4 Server. On the NFS Server, in /etc/dfs/, I added following line to dfstab file. & then ran the following On the client machine, while running the mount command, I am... (0 Replies)
Discussion started by: SunilB2011
0 Replies

6. Red Hat

Unable to access NFS share on Solaris Server from Linux client

Hi, I am trying to access a NFS shared directory on Solaris 10 Server from a client which is RHEL 4 Server. On the NFS Server, in /etc/dfs/, I added following line to dfstab file. share -F nfs -o rw /var/share & then ran the following svcadm -v enable -r... (3 Replies)
Discussion started by: SunilB2011
3 Replies

7. Shell Programming and Scripting

Migrating Oracle on Solaris Sparc to Linux RHEL 7 VM

Hi Gurus, We are migrating Oracle from Solaris to RHEL 7 and looking for Solaris equivalent commands for Linux. we are using lot of korn shell scripts built on Solaris so, i am looking for equivalent commands which are using in Solaris.. Could you please help me here by proving any info... (1 Reply)
Discussion started by: mssprince
1 Replies

8. Red Hat

Migrating Oracle on Solaris Sparc to Linux RHEL 7 VM

Hi Gurus, We are migrating Oracle from Solaris to RHEL 7 and looking for Solaris equivalent commands for Linux. we are using lot of korn shell scripts built on Solaris so, i am looking for equivalent commands which are using in Solaris.. Could you please help me here by proving any info ... (4 Replies)
Discussion started by: mssprince
4 Replies
OCF_HEARTBEAT_ORALSN(7) 					OCF resource agents					   OCF_HEARTBEAT_ORALSN(7)

NAME
ocf_heartbeat_oralsnr - Manages an Oracle TNS listener SYNOPSIS
oralsnr [start | stop | status | monitor | validate-all | meta-data | methods] DESCRIPTION
Resource script for Oracle Listener. It manages an Oracle Listener instance as an HA resource. SUPPORTED PARAMETERS
sid The Oracle SID (aka ORACLE_SID). Necessary for the monitor op, i.e. to do tnsping SID. (required, string, no default) home The Oracle home directory (aka ORACLE_HOME). If not specified, then the SID should be listed in /etc/oratab. (optional, string, no default) user Run the listener as this user. (optional, string, no default) listener Listener instance to be started (as defined in listener.ora). Defaults to LISTENER. (optional, string, no default) SUPPORTED ACTIONS
This resource agent supports the following actions (operations): start Starts the resource. Suggested minimum timeout: 120. stop Stops the resource. Suggested minimum timeout: 120. status Performs a status check. Suggested minimum timeout: 60. monitor Performs a detailed status check. Suggested minimum timeout: 30. Suggested interval: 10. validate-all Performs a validation of the resource configuration. Suggested minimum timeout: 5. meta-data Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5. methods Suggested minimum timeout: 5. EXAMPLE
The following is an example configuration for a oralsnr resource using the crm(8) shell: primitive example_oralsnr ocf:heartbeat:oralsnr params sid=string op monitor depth="0" timeout="30" interval="10" SEE ALSO
http://www.linux-ha.org/wiki/oralsnr_(resource_agent) AUTHOR
Linux-HA contributors (see the resource agent source for information about individual authors) resource-agents 1.0.3 07/05/2010 OCF_HEARTBEAT_ORALSN(7)
All times are GMT -4. The time now is 11:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy