Home » RDBMS Server » Server Administration » Can Initialization parameter on client side?
Can Initialization parameter on client side? [message #63283] Fri, 24 September 2004 00:34 Go to next message
BhavinShah
Messages: 105
Registered: February 2004
Senior Member
Hello frends,

Can we put initalization parameter on client side ?? if ans is yes then what is a use of it? and how it is work to read parameter?

 

Report message to a moderator

Re: Can Initialization parameter on client side? [message #63284 is a reply to message #63283] Fri, 24 September 2004 01:08 Go to previous messageGo to next message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
Hi

no client side has to do nothing with init parameter file,if though you copy it,no change will reflect to client.The init parameter file is used only by the server

D.Dilip

Report message to a moderator

Re: Can Initialization parameter on client side? [message #63296 is a reply to message #63283] Fri, 24 September 2004 05:49 Go to previous message
croK
Messages: 170
Registered: April 2002
Senior Member
YES you can.
Actually, i have 15 oracle databases on 15 sun enterprise servers, and placed all those init.ora files
on one sun server intended for maintanance and backup procedures.

1. I created directory on my local server. Let's
say remote_db
2. then created 15 directories under the parent directory remote_db
remote_dbdb01 (whatever name)
remote_dbdb02
3. ftp every init.ora from production servres to
my local directories

you can now startup or shutdown db remotely

1. sqlplus sys/pwd@remote_db01 as sysdba
2. startup pfile=remote_dbdb01init.ora

Best luck.
Remote DBA for hire.

Report message to a moderator

Previous Topic: how to check out listener and intelligent agency?
Next Topic: How to login as SYS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 08:28:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.