OraFAQ Forum: Backup & Recovery » Backup database from client

Home » RDBMS Server » Backup & Recovery » Backup database from client

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

Backup database from client [message #209500]

Fri, 15 December 2006 04:06

nvhcuong
Messages: 1
Registered: December 2006
Location: HCMC

Junior Member

I try to backup oracle database from client but cannot.
I was install Oracle client same version with oracle database server.
When I use exp command, it show message

EXP-00056:
ORA-12560:

Anyone can help me please.
How to configuration for client to connect to server.

Report message to a moderator

Re: Backup database from client [message #209509 is a reply to message #209500]

Fri, 15 December 2006 04:38

ebrian
Messages: 2794
Registered: April 2006

Senior Member

What exactly does your exp command look like ?

Report message to a moderator

Re: Backup database from client [message #209533 is a reply to message #209509]

Fri, 15 December 2006 07:05

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Post the export command that you used.

Are you using tnsservice to run this export?

Report message to a moderator

Re: Backup database from client [message #209543 is a reply to message #209500]

Fri, 15 December 2006 08:16

dba_blr
Messages: 43
Registered: December 2006

Member

Check if the tnsnames entry is proper.

Report message to a moderator

Re: Backup database from client [message #209674 is a reply to message #209500]

Sat, 16 December 2006 10:26

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

Senior Member

hi,
try like

first check ur oracle services is start
cmd>set oracle_sid=<sid>
cmd> net start oracleservice<sid>

http://www.dbmotive.com/oracle_error_codes.php?errcode=12560

Report message to a moderator

Re: Backup database from client [message #209675 is a reply to message #209674]

Sat, 16 December 2006 11:06

dba_blr
Messages: 43
Registered: December 2006

Member

user52 wrote on Sat, 16 December 2006 21:56

hi,
try like

first check ur oracle services is start
cmd>set oracle_sid=<sid>
cmd> net start oracleservice<sid>

http://www.dbmotive.com/oracle_error_codes.php?errcode=12560

I think this solution will not work from client systems (other than the Oracle Server). He's got to check the LISTENER and the TNASNAMES.ORA entry for that connection.

Report message to a moderator

Re: Backup database from client [message #209690 is a reply to message #209675]

Sat, 16 December 2006 22:14

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

Senior Member

I think this solution will not work from client systems

right.
but where i said check on client system ...
my point is check oracle services is start or not.
and set oracle_sid enviourment variable.

regards
Taj

Report message to a moderator

Previous Topic:	how to take backup
Next Topic:	export problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 20:15:26 CDT 2024