OraFAQ Forum: Server Administration » Installing Oracle on Unix

Home » RDBMS Server » Server Administration » Installing Oracle on Unix

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

Installing Oracle on Unix [message #146169]

Wed, 09 November 2005 00:18

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Hi Everyone

I have one cold back of datafiles and oracle home and I want to install the Oracle to new server.

Do I need to install Oracle (8.1.7.4) on new server or can I just coppy accross the files and bring the database up.

Is there any documentation avaliable how can I go about it.

Please help me how to go about it, if I copy across the files and oracle home what all I have to do to bring up the database.

I'm in the process of cloning one apps instance. and unfortunately we are not following standard Oracle guidlines, so cannot ask help from metalink.

Puneet

Report message to a moderator

Re: Installing Oracle on Unix [message #146215 is a reply to message #146169]

Wed, 09 November 2005 06:57

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Search the forum for 'cold copy clone' or 'cloning'.
The topic is been discussed many many times.

Report message to a moderator

Re: Installing Oracle on Unix [message #146233 is a reply to message #146215]

Wed, 09 November 2005 08:59

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

I would say

1. Install the Oracle binaries in the new server (keep it at the same level, including the patch (8.1.7.4.0)
2. make same file structure as in the original db
3. copy the cold backup in the corresponding folder.
3. make sure you get the init.ora, listener.ora and tnsnames.ora also
4. fire up the database

Note: The only reason I would do a clean install of the binaries is bocoz during the install, there can be soft links in the server you are not aware of.

I would say, if done carefully, you have a 98% chance your new db will fire up.

IF you want to change the file structure, then you will have to create the control files.

I am in the process of moving to a new server (all 21 databases) and this is exactly what I am doing. In fact I am creating the control files on the new server as I did make changes in the file structure.

And as said above, do a search in this group for other threads.

Good luck.
--
Sanjay

[Updated on: Wed, 09 November 2005 09:01]

Report message to a moderator

Re: Installing Oracle on Unix [message #147281 is a reply to message #146169]

Thu, 17 November 2005 00:49

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Hi Sanjay,

We have copied across the Oracle(home as well as datafiles) from cold backup and then try to restore the oracle.

We have maintained same directory structure.

Now we encountered few issues while bringing up the listner

Error -
LSNRCTL> service ZIPPY
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCZIPPY))
Services Summary...
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
ZIPPY has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
The command completed successfully

==========================================================
Log file

NSLSNR for Solaris: Version 8.1.7.4.0 - Production on 17-NOV-2005 00:11:47

(c) Copyright 1998 Oracle Corporation. All rights reserved.

System parameter file is /ora1/app/ZIPPY/product/8.1.7/network/admin/listener.ora
Log messages written to /ora1/app/ZIPPY/product/8.1.7/network/admin/zippy.log
Trace information written to /ora1/app/ZIPPY/product/8.1.7/network/admin/zippy.trc
Trace level is currently 0

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCZIPPY)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.72.2.24)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
17-NOV-2005 00:11:47 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=srv40019)(USER=orazippy))(COMMAND=status)(ARGUMENTS=64)(SERVICE=ZIPPY)(VERSION=135296000)) * status * 0
17-NOV-2005 00:12:04 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=srv40019)(USER=orazippy))(COMMAND=services)(ARGUMENTS=64)(SERVICE=ZIPPY)(VERSION=135296000)) * services * 0
~============================================================

listner .ora

#
# LISTENER.ORA FOR APPLICATIONS - Database Server
# Created by Rapid Install
#

#
# Net8 definition for Database listener
#

ZIPPY =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL = IPC)(KEY = EXTPROCZIPPY))
(ADDRESS= (PROTOCOL = TCP)(Host = 10.72.2.24)(Port = 1521))
)

SID_LIST_ZIPPY =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ZIPPY)
(ORACLE_HOME = /ora1/app/ZIPPY/product/8.1.7)
(SID_NAME = ZIPPY)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /ora1/app/ZIPPY/product/8.1.7)
(PROGRAM = extproc)
)
)

STARTUP_WAIT_TIME_ZIPPY = 0
CONNECT_TIMEOUT_ZIPPY = 10
TRACE_LEVEL_ZIPPY = OFF

LOG_DIRECTORY_ZIPPY = /ora1/app/ZIPPY/product/8.1.7/network/admin
LOG_FILE_ZIPPY = ZIPPY
TRACE_DIRECTORY_ZIPPY = /ora1/app/ZIPPY/product/8.1.7/network/admin
TRACE_FILE_ZIPPY = ZIPPY_INDIA

===============================================================

While trying to start oracle I encountered following error

ORACLE_HOME=db[/ora1/app/ZIPPY/product/8.1.7]
bash-2.03$ sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Nov 17 00:40:11 2005

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup nomount
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
SQL> startup
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-01034: ORACLE not available
=============================================================

This to remind you I have not installed oracle, just copied across the oracle home and datafile and trying to buildup the new system.

Is there any other file which is required to run or required to relink it.

Please help... if I'm not able to finish this task.. by friday it will be a .......

Puneet

Report message to a moderator

Re: Installing Oracle on Unix [message #147305 is a reply to message #146169]

Thu, 17 November 2005 02:12

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Now I receive this error

ORA-27102: out of memory
SVR4 Error: 22: Invalid argument

Listner is running and able to tnsping from my machine

but geting error-->
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument

Please help

Report message to a moderator

Re: Installing Oracle on Unix [message #222821 is a reply to message #146169]

Tue, 06 March 2007 09:26

--Ex--
Messages: 1
Registered: March 2007

Junior Member

Hello, I have the same problem and I resolved it.

<ORACLE>$ export ORACLE_SID= <INSTANCE>
<ORACLE>$ sqlplus /nolog
SQL> connect /as sysdba
SQL> shutdown abort
SQL> exit

2 processes are not stoped and I kill them.
For me, these processes are: "ora_dbw0_xxx" and "ora_pmon_xxx"

and after-, I can start my database without problem:
<ORACLE>$ sqlplus /nolog
SQL> connect /as sysdba
SQL> startup

Report message to a moderator

Re: Installing Oracle on Unix [message #222892 is a reply to message #146169]

Tue, 06 March 2007 21:13

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

I guess 'shutdown abort' failed to stop the Oracle processes?
How about kill -9 <processnumber>

Report message to a moderator

Re: Installing Oracle on Unix [message #222906 is a reply to message #147305]

Tue, 06 March 2007 23:09

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

ORA-27102: out of memory

http://www.cryer.co.uk/brian/oracle/ORA27102.htm

hope this helps
Taj

Report message to a moderator

Previous Topic:	"ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded"
Next Topic:	Archive log not able to write.....query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 02:39:15 CDT 2024