Sample tnsnames entry for sysdba

P

PlSQlEnthusiast

Member
Hi,

I have several working tnsname entries, so no problem with setting that up in general.

But I can't figure out how to write a tnsnames entry specifically for sysdba in oracle express.

I've searched for several days, and cannot locate an example on the web, specifically for sysdba XE.
 
Last edited:
The tnsnames.ora file maps logical database names to database instances on the network. It does not contain any definitions about users or roles. What exactly do you mean by "sysdba" in this context?
 
I can log in as sysdba with sqlplus, in order to create users or grant privileges.

But I'd like to do that in an editor like Pl/Sql Developer, if possible. Is that possible, or does that role require sqlplus? I don't know how to create a connection with pl/sql developer, even though it's easy to do with SqlPlus.

I thought that it would be possible by creating a tnsnames entry for sysdba. But nobody seems to understand what I'm asking.

The goal - to be able to type in commands with a sysdba role with a third party editor (like Pl/Sql Developer), just like it's done with sqlplus.
 
To connect with the SYSDBA role, enter the credentials of a DBA user and select "SYSDBA" from the "Connect as" list.

The tnsnames.ora file only applies to database locations, not to users or roles within those databases.
 
You must log in or register to reply here.
Back
Top