Home » RDBMS Server » Backup & Recovery » OEM Backup settings - ORA-27040, ORA-12505. (Oracle DB 11g, Windows Server 2008 R2.)
|
|
| Re: OEM Backup settings - ORA-27040, ORA-12505. [message #638797 is a reply to message #638796] |
Sun, 21 June 2015 14:49   |
 |
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 |
John Watson
Messages: 8963
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 #638817 is a reply to message #638804] |
Mon, 22 June 2015 08:19 |
 |
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:\> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed Jan 22 00:44:42 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
Im new on Oracel DB.
