Home > How To > How To Find Database Name In Unix

How To Find Database Name In Unix


Suggested Solutions Title # Comments Views Activity Take an image of a laptop and deploy to others using PXE 17 74 7d T-SQL Convert to PL/SQL 23 44 4d vi editor Says: July 20th, 2012 at 12:05 pm They were waiting to be approved MESLI Abdelhadi Says: July 22nd, 2012 at 2:42 am Thank you Mr kamran for reply, Yes in my I have a script that work from the command line, but error on a cat of a tmp file when run from cron. Are there continuous functions for which the epsilon-delta property doesn't hold? this contact form

I have the same before because i created that log in windows, after doing that it works, i have no idea :-) sabercats View Public Profile Find all posts by sabercats yes! You can either copy the original oratab file to this directory : cp /etc/oratab /var/opt/oracle/ 2. A better tool to use is nslookup, dnsquery, or dig. $nslookup http://www.google.com The forward and reverse lookup should succeed. http://stackoverflow.com/questions/10294688/is-there-any-way-to-find-the-list-of-oracle-dbs-installed-on-a-unix-server

How To Find Database Name In Unix

Is there any way to get those DB names? Then you need to add the appropriate symbolic links to cause the script to be executed when the system goes down, or comes up. Are you new to LinuxQuestions.org? All rights reserved.

If you'd like to contribute content, let us know. Join & Ask a Question Need Help in Real-Time? ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [] If you try to create your database manually then also the command startup nomount fails with above error Unix Command To Find Database Version Live Traffic Stats « Automatically display SID and connected User in Sql*Plus Install VMware – Step by step » Automatically StartUp and Shutdown an Oracle Database in Linux OS Posted by

Step 04: Diagnosis DNS problem if you have DNS setup If you have DNS setup, ping is not a tool to diagnose DNS problem. Oratab file is used by Oracle utilities. create user Myuser and assigned it to dba group.$ id -a Myuser, I gotuid = 105(Myuser) gid=100(dba) groups=100(dba)2. http://dbaforums.org/oracle/lofiversion/index.php?t7280.html From outdated Desktops to cheap "throwaway" laptops, they are all around and not as hard to "fix up" as you m… Operating Systems UNDO AND REDO IN ORACLE Article by: Anjugarg66

thank you vijay Says: October 18th, 2011 at 12:14 pm hi kamran , can you please mention the content & path of the listener.ora and tnsname.ora file thanks in advance vijay Cat /etc/oratab No Such File Or Directory If you want this file to be added as a service which starts when your OS boots, you should put it in /etc/init.d/ directory. LinuxQuestions.org > Forums > Non-*NIX Forums > Programming script using "/usr/bin/cat error" produces "cannot open" in cron User Name Remember Me? Thanks for your help.

Unix Database Commands

Alternatively you can here view or download the uninterpreted source code file. http://www.linuxquestions.org/questions/programming-9/script-using-usr-bin-cat-error-produces-cannot-open-in-cron-742011/ And you need to modify /etc/hosts files. How To Find Database Name In Unix Having a problem logging in? How To Check If Oracle Database Is Up And Running In Linux Says: February 12th, 2012 at 4:20 pm Make sure you've set ORACLE_SID environment variable correctly and then start the listener and EM gagan Says: March 20th, 2012 at 2:55 pm hi

Introduction to Linux - A Hands on Guide This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started But not working on other 4 servers. burleson Jun 27 2007, 04:01 PM Hi,>> I got the message as: ksh: sqlplus: not found.That's a PATH issue. Click Here to receive this Complete Guide absolutely free. List All Databases In Oracle

Latest LQ Deal: Linux Power User Bundle Blogs Recent Entries Best Entries Best Blogs Blog List Search Blogs Home Forums HCL Reviews Tutorials Articles Register Search Search Forums Advanced Search Search How safe is 48V DC? If so, what changes did you have to make to the environment variables for this non oracle user to get it to work? Contact Us - Advertising Info - Rules - LQ Merchandise - Donations - Contributing Member - LQ Sitemap - Main Menu Linux Forum Android Forum Chrome OS Forum Search LQ

Anyway, your article is very helpful. How To Check If Oracle Database Is Up And Running In Unix IP Address fully qualified hostname simple or short hostname Alias A simple example, $ cat /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail. If your machine name is "database" you can give /etc/hosts entry as, database localhost.localdomain localhost And then ping database again.

Says: June 16th, 2011 at 3:01 pm Dear Tanveer You shouldn't download any rpm to automate the startup and shutdown of the Oracle database.

If not, then try to delete and create the EM repository again Victor Says: May 8th, 2011 at 4:31 am Was only able to run EM upon initial startup of newly Then, we will analyze the reaso… Oracle Database How Joins Work Video by: Steve Using examples as well as descriptions, step through each of the common simple join types, explaining differences It would be easier than doing all these steps. How To Check Oracle Version In Unix Command You need to set your .profile variables:Many folks do not like to use the "oraenv" script to change Oracle environments, and some Oracle professionals write a Linux login script to perform

Hide this message.429. Dcrusoe View Public Profile View LQ Blog View Review Entries View HCL Entries Find More Posts by Dcrusoe Thread Tools Show Printable Version Email this Page Search this Thread Advanced Note also the headers that I show going to the file do go to the file when run in cron. Do you have an option for the downtime?

Leave a Reply Name (required) Mail (will not be published) (required) Website XHTML: You can use these tags:

This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. You can leave a response, or trackback from your own site. 40 Responses to "Automatically StartUp and Shutdown an Oracle Database in Linux OS" AJA Says: April 28th, 2009 at 6:54 I have found it most simple and reliable. I need to change it to "database_sid:oracle_home_dir:y".

Connect with top rated Experts 20 Experts available now in Live! Says: July 21st, 2009 at 6:04 pm Hi David Please for your Urgent questions, open an SR in metalink (contact Oracle Support) Or you can post a question in Oracle Forums Thanks a lot. Join them; it only takes a minute: Sign up Is there any way to find the list of Oracle DBs installed on a UNIX server? [closed] up vote 1 down vote

But I don't want to mess up the envirnment variable of oracle user. traveller Jun 28 2007, 10:39 AM Burleson:Thanks for your code and advices. How can I change it to "database_sid:oracle_home_dir:y"? » Log in to post comments .:: Blogger Home :: Wiki Home :: Forum Home :: Privacy :: Contact ::.