Home » RDBMS Server » Server Administration » Installing Oracle on Unix
Installing Oracle on Unix [message #146169] Wed, 09 November 2005 00:18 Go to next message
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
Re: Installing Oracle on Unix [message #146215 is a reply to message #146169] Wed, 09 November 2005 06:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Installing Oracle on Unix [message #146233 is a reply to message #146215] Wed, 09 November 2005 08:59 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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

Re: Installing Oracle on Unix [message #147305 is a reply to message #146169] Thu, 17 November 2005 02:12 Go to previous messageGo to next message
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
Re: Installing Oracle on Unix [message #222821 is a reply to message #146169] Tue, 06 March 2007 09:26 Go to previous messageGo to next message
--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
Re: Installing Oracle on Unix [message #222892 is a reply to message #146169] Tue, 06 March 2007 21:13 Go to previous messageGo to next message
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>
Re: Installing Oracle on Unix [message #222906 is a reply to message #147305] Tue, 06 March 2007 23:09 Go to previous message
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
Previous Topic: "ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded"
Next Topic: Archive log not able to write.....query
Goto Forum:
  


Current Time: Sun Dec 11 08:20:09 CST 2016

Total time taken to generate the page: 0.09383 seconds