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

How To Find Database Name In Unix

Contents

Please visit this page to clear all LQ-related cookies. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Search Forums Show Threads Show Posts Tag Search Advanced Search Unanswered Threads Find All Thanked Posts Go to Page... unix and linux operating commands Cannot open [No such file logout, then login, then issue $sqlplus /nolog. this contact form

asked 4 years ago viewed 7664 times active 2 years ago Upcoming Events 2016 Community Moderator Election ends Nov 22 Get the weekly newsletter! Step 06: Check resolv.conf $ cat /etc/resolv.confnameserver 4.2.2.2 rohit Says: September 24th, 2009 at 10:03 am i tried all steps mentioned by u bt it did not work i was found Submitted by admin on Sat, 2004-08-07 08:18 Body:"oratab" is a file created by Oracle in the /etc or /var/opt/oracle directory when installing database software. For more information about "Instances.pm" see the Fossies "Dox" file reference documentation. 1 ################################################################################ 2 # Oracle::Instances - Common stuff to get Oracle instances and versions 3 # 4 # Author: Homepage

How To Find Database Name In Unix

one of my oracle form is not running. should i go for rman or datapump. Too Many Requests.Too many requests from this IP (37.230.135.44).Please email [email protected] if you believe this is an error. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone.

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 It displays the message below: ORA-00600: internal error code, arguments: [ keltnfy-ldmInit],[46],[1],[],[],[],[],[] please how do I recover my database Kamran Agayev A. There are other possibilities; missing path specifications, permission mismatches, some others but more detail would help... Unix Command To Find Database Version MESLI Abdelhadi Says: July 13th, 2012 at 1:03 pm Hi Mr Kamran, I posted yesterday two messages about automating startup of database and I see now that are deleted!!

burleson Jun 28 2007, 02:46 PM Hi,Are you on Solaris? Unix Database Commands I tried the above steps for Automatic StartUp and Shutdown an Oracle Database in my Linux OS and my database has refused to start since then. These two oracle_sid are on the network, but not on the same server.Because of this, I added one line in script as export ORACLE_SID=database_sid which is what I want to see. How to gain confidence with new "big" bike?

Then logged out and logged in. Cat /etc/oratab No Such File Or Directory is it possible i take backup as asm and while importing i can covert into filesystem. Besides acting as a registry for what databases and software versions are installed on the server, ORATAB is also used for the following purposes: Oracle's "dbstart" and "dbshut" scripts use this Forum Operations by The UNIX and Linux Forums Help - Search - Members - Calendar Full Version: Setting up non oracle accounts to run Oracle utilities Oracle DBA Forums > Oracle

Unix Database Commands

It should be in /var/opt/oracle, not /etc. 0 LVL 23 Overall: Level 23 Oracle Database 22 Linux 4 Operating Systems 1 Message Active 1 day ago Accepted Solution by:David2014-02-26 David Connect with top rated Experts 20 Experts available now in Live! How To Find Database Name In Unix It needs to have read and write level access.You can run chmod 755 /etc/oratabThen it should work.> If I don't use the script, just set up envirnment variables on .profile for How To Check If Oracle Database Is Up And Running In Linux more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

Visit the following links: Site Howto | Site FAQ | Sitemap | Register Now If you have any problems with the registration process or your account login, please contact us. Kamran Agayev A. Please include your IP address in your email. Step 05: Check nsswitch.conf $ cat /etc/nsswitch.confhosts: files dns Make sure host lookup is also done through the /etc/hosts file and not just dns. List All Databases In Oracle

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

It has two solutions: 1. How To Check If Oracle Database Is Up And Running In Unix Oracle Database Advertise Here 778 members asked questions and received personalized solutions in the past 7 days. The code is correct tanveer Says: June 16th, 2011 at 5:02 pm where sould I place commas ?

Or you can edit dbstart and dbshut scripts, find the variable ORATAB, and you'll find that it's addressing to  /var/opt/oracle/oratab file.

Thanks. That's all. But in Linux, it's different. How To Check Oracle Version In Unix Command Your script and your service is ready for use.

Says: September 28th, 2009 at 8:35 am Hi Rohit The best solution is not to "Copy/paste" the script because there may be problem with commas and so on. Note that I have a file showing users logging into a menu and what they do in the menu, I first pull just the help desk guys from it (tmp.1), then Any way to color lines in a Line command? my first concern is to install 11g in new oracle home.

Dcrusoe View Public Profile View LQ Blog View Review Entries View HCL Entries Find More Posts by Dcrusoe 07-22-2009, 04:30 PM #7 Dcrusoe Member Registered: Oct 2004 Location: San yes! In my /etc/oratab I have "database_sid:oracle_home_dir:n". Find out where the file's actually being stored.

Note also the headers that I show going to the file do go to the file when run in cron. echo " TODAY'S HELPDESK USER LOG" > $HDRPT echo "\r\n"$date"\r\n" >> $HDRPT echo " DATE TIME REQUESTED OPTION ACCESS KB LOGICAL EMP ID EMPLOYEE NAME" >> $HDRPT echo " ------- ----- When I logged in, system showed: cat: cannot open /etc/oratab, Then, ORACLE_SID = [database_sid.domain.com] ? Victor Says: May 7th, 2011 at 12:31 am Dear Kamran: I want to use the auto startup/shutdown process for my 11gR2 install on OEL.

Linux_interest Linux - Newbie 4 08-28-2004 10:22 AM Monthly Archiving Script... I have set up some envirnment variables for oradba user. Please wait a few minutes and refresh this page. edit by vi.

If the size is not so big and you can stop the database for a while, stop it, open in readonly mode, export all data, import to the new database and If NULL dont overwrite 27 35 3d Refreshing your outdated PC with a Custom OS Article by: Steven Just about everyone has an old PC laying around. 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.

I followed your guide to put coding into .profile at Myuser home directory. Step 02: Check the contents of /etc/hosts Open the contents of /etc/hosts and check the contents inside it. $ less /etc/hosts Note that the contents of this files follow following format. If you'd like to contribute content, let us know.