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: 7
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: 26766
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: 7
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: 26766
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: 68624
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: Thu Mar 28 04:38:24 CDT 2024