Home » RDBMS Server » Server Administration » How to find out Database Owner in Oracle? (Oracle 12c)
How to find out Database Owner in Oracle? [message #664427] Mon, 17 July 2017 07:03 Go to next message
muniraj_tomar
Messages: 6
Registered: July 2017
Junior Member
Hi all , is there any query to find out the Database Owner(who has created the database) name?

Currently we are trying with below query

SELECT host_name FROM v$instance

Is there any other way to find the Owner. please reply.
Re: How to find out Database Owner in Oracle? [message #664429 is a reply to message #664427] Mon, 17 July 2017 07:07 Go to previous messageGo to next message
BlackSwan
Messages: 25523
Registered: January 2009
Location: SoCal
Senior Member
muniraj_tomar wrote on Mon, 17 July 2017 05:03
Hi all , is there any query to find out the Database Owner(who has created the database) name?

Currently we are trying with below query

SELECT host_name FROM v$instance

Is there any other way to find the Owner. please reply.
database owner is OS user who owns the files.
Re: How to find out Database Owner in Oracle? [message #664432 is a reply to message #664429] Mon, 17 July 2017 07:21 Go to previous messageGo to next message
muniraj_tomar
Messages: 6
Registered: July 2017
Junior Member
ok, if we are creating multiple instances then owner would be same ? or it would be the one which we will give at the time of database creation?
Re: How to find out Database Owner in Oracle? [message #664433 is a reply to message #664432] Mon, 17 July 2017 07:27 Go to previous messageGo to next message
BlackSwan
Messages: 25523
Registered: January 2009
Location: SoCal
Senior Member
muniraj_tomar wrote on Mon, 17 July 2017 05:21
it would be the one which we will give at the time of database creation?
HUH? No username is given or required to create new Oracle database.
SYS schema always owns DB metadata objects.

What business problem are you trying to solve?
What will you do different after this question has been answered?
Re: How to find out Database Owner in Oracle? [message #664437 is a reply to message #664432] Mon, 17 July 2017 09:37 Go to previous message
Michel Cadot
Messages: 65079
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
muniraj_tomar wrote on Mon, 17 July 2017 14:21
ok, if we are creating multiple instances then owner would be same ? or it would be the one which we will give at the time of database creation?
Instance owner is the one that starts it, it is not necessary the same one for all instances of a database.
Database owner is the one that owns the database files.

Previous Topic: Unable to connect to Oracle DB (11g R2)
Next Topic: Is there any way to find out if a database is a copy of another database?
Goto Forum:
  


Current Time: Fri Jul 21 00:19:21 CDT 2017

Total time taken to generate the page: 0.12584 seconds