Database Reference
In-Depth Information
Now, currently the only user in that file is
SYS
, even if there are other
SYSDBA
accounts on that database (they
are not in the password file yet). Using that knowledge, however, we can for the first time connect as
SYSDBA
over the
network:
[tkyte@dellpe ~]$ sqlplus sys/bar@ora12cr1 as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Tue Sep 3 14:21:08 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SYS@ORA12CR1>
■
if you experience an Ora-12505 “tNs:listener does not currently know of siD given in connect Descriptor”
error during this step, that means that the database listener is not configured with a static registration entry for this
server. the DBa has not permitted remote sYsDBa connections when the database instance is not up. this will be the
case for most Oracle installations for version 9
i
and above. You would need to configure static server registration in
your
listener.ora
configuration file. please search for "Configuring static service information" (in quotes) on the OtN
(Oracle technology Network) documentation search page for the version of the database you are using for details on
configuring this static service.
Note
We have been authenticated, so we are in. We can now successfully start up, shut down, and remotely administer
this database using the
SYSDBA
account. Now, we have another user,
OPS$TKYTE
, who has been granted
SYSDBA
, but
will not be able to connect remotely yet:
[tkyte@dellpe ~]$ sqlplus 'ops$tkyte/foobar'@ora12cr1 as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Tue Sep 3 14:22:21 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
The reason for this is that
OPS$TKYTE
is not yet in the password file. In order to get
OPS$TKYTE
into the password
file, we need to “regrant” that account the
SYSDBA
privilege:
[tkyte@dellpe ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Tue Sep 3 14:23:11 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.