By default windows services are started under local system account which obviously has no permissions on mapped drives. You need to create a local user with same name as domain user with proper permissions on mapped drive. Then modify and start oracle services as that user.
Thanks SY. But I am not complete understood on this.
I have a user 'DEMO.DEV', which i used to login to the DB server(Win 2008) and the Apps Server( Win 2003). I have the database user as 'DEMOTST'.
Kindly clarify me on the above solution.
Thanks in advance.
It's not who you log into oracle as, it's the user on the server that the Oracle services are running as.
When the server it booted up, apart from the operating system itself, various programs and services are started by the server. Some of those will start as the "root" or "Administrator" user, and some will be installed and running as some other user(s). The Oracle database instance is one such service and will have been installed on the server so that it starts up under the guise of a particular user on that server. (We're talking server users, not database users). Who that user is, depends on who installed the database instance and what options they chose when installing. They could have picked the default options or they could have customized it to be some other user. As we cannot see your server we cannot tell you exactly. You'll have to speak to the person/DBA who installed it, or who can check for you.