Home » RDBMS Server » Backup & Recovery » OEM Backup settings - ORA-27040, ORA-12505. (Oracle DB 11g, Windows Server 2008 R2.)
OEM Backup settings - ORA-27040, ORA-12505. [message #638796] Sun, 21 June 2015 14:33 Go to next message
elisabethde
Messages: 6
Registered: June 2015
Junior Member
Hi,

I have problem with running backup RMAN.
I use Oracle Enterprise Manager to test connection to share folder. On backup settings i put location \\oracle\backup
On "host credentionals" i wrote domain user and password (ad user). This user have permissions to share folder.

When i check "test disk backup" i get error ORA-27040 to create data on \\oracle\backup.

I have searched that the problem is on the service. I change the logging to the db service from local to doimain user. And restart the service.

Afeter this i logged to the Oracle Enterprise Manager. And I got a message that database is down ORA-12505.
What I do wrong? Sad Im new on Oracel DB.

Sorry for my english.
Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638797 is a reply to message #638796] Sun, 21 June 2015 14:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

27040, 00000, "file create error, unable to create file"
// *Cause: create system call returned an error, unable to create file
// *Action: verify filename, and permissions

[oracle@localhost dbs]$ oerr ora 12505
12505, 00000, "TNS:listener does not currently know of SID given in connect descriptor"
// *Cause: The listener received a request to establish a connection to a
// database or other service. The connect descriptor received by the listener
// specified a SID for an instance (usually a database instance) that either
// has not yet dynamically registered with the listener or has not been
// statically configured for the listener. This may be a temporary condition
// such as after the listener has started, but before the database instance
// has registered with the listener.
// *Action:
// - Wait a moment and try to connect a second time.
// - Check which instances are currently known by the listener by executing:
// lsnrctl services <listener name>
// - Check that the SID parameter in the connect descriptor specifies
// an instance known by the listener.
// - Check for an event in the listener.log file.


post results from OS commands below

lsnrctl status
lsnrctl service
Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638799 is a reply to message #638796] Sun, 21 June 2015 15:54 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Unless you have changed the default, your database instance will probably be running under the Windows local system account, which would not normally have any permissions on a file system mounted from a remote machine. If I remember correctly (I am not very good with Windows) if you map the remote filesystem on to a drive letter and use that rather than using a UNC path, it may work.
You need to think about the effective user id of the process that is actually generating the backup piece, and how the remote system will assign permissions to it.
Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638803 is a reply to message #638799] Mon, 22 June 2015 00:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
if you map the remote filesystem on to a drive letter and use that rather than using a UNC path, it may work.


No, mapping does not change the "remote" status of the directory/file and so access will not be permitted.

Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638804 is a reply to message #638796] Mon, 22 June 2015 00:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I change the logging to the db service from local to doimain user.


NEVER do that it is a security hole.
Database instance (service) should have NO access to remote resources.

Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638817 is a reply to message #638804] Mon, 22 June 2015 08:19 Go to previous messageGo to next message
elisabethde
Messages: 6
Registered: June 2015
Junior Member
Michel Cadot wrote on Mon, 22 June 2015 00:13

Quote:
I change the logging to the db service from local to doimain user.


NEVER do that it is a security hole.
Database instance (service) should have NO access to remote resources.



OK. But when I have local I don't have permission to shared folder.



Local Service

Q:\>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 22-JUN-2015 14:19
:13

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Produ
ction
Start Date                20-JUN-2015 08:08:24
Uptime                    2 days 6 hr. 11 min. 9 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\Oracle\product\11.2.0\dbhome_1\network\admin\listen
er.ora
Listener Log File         C:\Oracle\diag\tnslsnr\ORACLE\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE.domain.com)(PORT=1521)))
Services Summary...
Service "oraXDB" has 1 instance(s).
  Instance "ora", status READY, has 1 handler(s) for this service...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ora" has 1 instance(s).
  Instance "ora", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
  Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
  Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully

Q:\> lsnrctl service

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 22-JUN-2015 14:19
:30

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "oraXDB" has 1 instance(s).
  Instance "ora", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: ORACLE, pid: 4588>
         (ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE.domain.com)(PORT=51495))
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "ora" has 1 instance(s).
  Instance "ora", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:1165 refused:0 state:ready
         LOCAL SERVER
Service "test" has 1 instance(s).
  Instance "test", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:2829 refused:0 state:ready
         LOCAL SERVER
Service "testXDB" has 1 instance(s).
  Instance "test", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: ORACLE, pid: 4076>
         (ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE.domain.com)(PORT=49320))
The command completed successfully

Q:\>


Domain service

Q:\>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 22-JUN-2015 15:14
:06

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Produ
ction
Start Date                20-JUN-2015 08:08:24
Uptime                    2 days 7 hr. 6 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\Oracle\product\11.2.0\dbhome_1\network\admin\listen
er.ora
Listener Log File         C:\Oracle\diag\tnslsnr\ORACLE\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE.domain.com)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
  Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
  Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully

Q:\> lsnrctl service

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 22-JUN-2015 15:14
:14

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "test" has 1 instance(s).
  Instance "test", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:2870 refused:0 state:ready
         LOCAL SERVER
Service "testXDB" has 1 instance(s).
  Instance "test", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: ORACLE, pid: 4076>
         (ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE.domain.com)(PORT=49320))
The command completed successfully

Q:\>
Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638818 is a reply to message #638817] Mon, 22 June 2015 08:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
OK. But when I have local I don't have permission to shared folder.


Yes, this is the point and this is the goal.
You have to change your process not to open the gates for hackers.

I don't understand what you want to show with your "local service" and "domain service" ouputs.

Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638821 is a reply to message #638818] Mon, 22 June 2015 10:43 Go to previous messageGo to next message
elisabethde
Messages: 6
Registered: June 2015
Junior Member
Local service means Local account service permissions
Domain service means Domain account service permissions

http://oi57.tinypic.com/294ju4l.jpg

Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638822 is a reply to message #638821] Mon, 22 June 2015 10:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

"Database works OK/Database is down", expected and desirable.

Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638823 is a reply to message #638822] Mon, 22 June 2015 11:06 Go to previous messageGo to next message
elisabethde
Messages: 6
Registered: June 2015
Junior Member
But what i must do to backup database to windows server shared folder?
Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638824 is a reply to message #638823] Mon, 22 June 2015 11:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Change your process, do it locally then copy it to shared folder.

Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638830 is a reply to message #638824] Mon, 22 June 2015 13:27 Go to previous messageGo to next message
elisabethde
Messages: 6
Registered: June 2015
Junior Member
You don't help Wink
Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638831 is a reply to message #638830] Mon, 22 June 2015 13:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can't do what you want to do so you have to do what you can do. Wink

Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638834 is a reply to message #638831] Mon, 22 June 2015 13:49 Go to previous messageGo to next message
elisabethde
Messages: 6
Registered: June 2015
Junior Member
Sad

storm is comming

[Updated on: Mon, 22 June 2015 13:49]

Report message to a moderator

Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638839 is a reply to message #638834] Mon, 22 June 2015 15:55 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You can't push a string.
Previous Topic: apply archive logs to old incarnation
Next Topic: I need help
Goto Forum:
  


Current Time: Thu Mar 28 12:05:18 CDT 2024