Home » Other » General » How to check oracle installation. ?
How to check oracle installation. ? [message #213720] Fri, 12 January 2007 01:04 Go to next message
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 Go to previous messageGo to next message
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.
Re: How to check oracle installation. ? [message #213726 is a reply to message #213721] Fri, 12 January 2007 01:12 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
to see if the database is running do a ps -ef|grep pmon
Re: How to check oracle installation. ? [message #213734 is a reply to message #213726] Fri, 12 January 2007 02:05 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Yes it's working.

Thankyou
Re: How to check oracle installation. ? [message #213739 is a reply to message #213726] Fri, 12 January 2007 02:21 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: How to check oracle installation. ? [message #213755 is a reply to message #213742] Fri, 12 January 2007 03:48 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: How to check oracle installation. ? [message #213795 is a reply to message #213772] Fri, 12 January 2007 05:54 Go to previous messageGo to next message
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".
Re: How to check oracle installation. ? [message #213841 is a reply to message #213795] Fri, 12 January 2007 08:39 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

OK. this is development server, I'm using Rman, Backup type

" Disk "
Re: How to check oracle installation. ? [message #213959 is a reply to message #213841] Sat, 13 January 2007 00:05 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
so why you wait...
just try yourself and findout how much time taking during backup process.



regards

taj
Previous Topic: Tom Kyte -Expert one on one Oracle
Next Topic: which is better oracle developer or dba??
Goto Forum:
  


Current Time: Fri Dec 06 17:15:31 CST 2024