OraFAQ Forum: General » How to check oracle installation. ?

Home » Other » General » How to check oracle installation. ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to check oracle installation. ? [message #213720]

Fri, 12 January 2007 01:04

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hi ,

My Senior dba installed oracle 10g in suse linx 9.3, how to

check oracle available or not in suse linz 9.3 ?

Which command we use in suse linux 9.3 ?

Babu

[Updated on: Fri, 12 January 2007 01:07]

Report message to a moderator

Re: How to check oracle installation. ? [message #213721 is a reply to message #213720]

Fri, 12 January 2007 01:08

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You might try to connect to SQL*Plus (command is the same as anywhere else: SQLPLUS username/password@database_alias); I also believe there *must* be something like "Administrative Tools - Services" on MS Windows which would show whether Oracle service is up or not.

Report message to a moderator

Re: How to check oracle installation. ? [message #213726 is a reply to message #213721]

Fri, 12 January 2007 01:12

Frank
Messages: 7901
Registered: March 2000

Senior Member

to see if the database is running do a ps -ef|grep pmon

Report message to a moderator

Re: How to check oracle installation. ? [message #213734 is a reply to message #213726]

Fri, 12 January 2007 02:05

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Yes it's working.

Thankyou

Report message to a moderator

Re: How to check oracle installation. ? [message #213739 is a reply to message #213726]

Fri, 12 January 2007 02:21

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hi Frank,

Implemented nightly backup routines which include database exports, disk backup and copying database files to the development server for precautionary measures.

The above one is, one of the reponsibilty, i don't know why taking disk backup's this is necessary ?

Babu B

[Updated on: Fri, 12 January 2007 02:32]

Report message to a moderator

Re: How to check oracle installation. ? [message #213742 is a reply to message #213739]

Fri, 12 January 2007 02:47

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Disk backup saves all your operating system files - forms, reports, SQLs, text documents, spreadsheets, pictures, movies, ..., including Oracle files (database + control + redo log + executables + ...).

Is it necessary? Well, would you like to lose your application which has several hundreds of forms and reports? I wouldn't.

Report message to a moderator

Re: How to check oracle installation. ? [message #213755 is a reply to message #213742]

Fri, 12 January 2007 03:48

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Double Posting......Already answered

http://www.orafaq.com/forum/t/75204/91729/

[Updated on: Fri, 12 January 2007 03:50]

Report message to a moderator

Re: How to check oracle installation. ? [message #213772 is a reply to message #213742]

Fri, 12 January 2007 04:31

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Ok.

One more thing ? 40 GB database size, How long take backup time ?

we are use win 2003 Server OS, XEON machine, 4 GB Ram, 3 Ghz ..

Babu

Report message to a moderator

Re: How to check oracle installation. ? [message #213795 is a reply to message #213772]

Fri, 12 January 2007 05:54

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I've seen your question already; there's no need to send private messages.

I don't know how long it takes. What is your backup media? A tape? If so, read this device's specification. Also, if you do the backup to another disk, it should be faster if compared to a tape. You mentioned a "development server" - are you going to copy image of your production server to another one? Or, will you copy the backup file(s) over the network? This solution will also depend on network traffic.

Whichever it is, I really can't tell "it will last x hours and y minutes".

Report message to a moderator