First of all, I'm not a dba, so maybe the answers will obvious but I need ask
I created a db19 with RU .27 using dbca, all standards, nothing special.
if i login sqlplus sys@orcl as sysdba, it works if the databse is mount, but what I want is to startup the database remotely, so I create the static entry in the listener.ora. Now when i try sys@orcl as sysdba and the database is not running I'm getting ORA-1017 invalid username/password …
I believe the statis entry in the listener.ora is OK because if I remove it says something like listener not listening for that service
any tip?
SQL> show parameter remote_login_passwordfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL> SELECT * FROM V$PASSWORDFILE_INFO;
FILE_NAME
--------------------------------------------------------------------------------
FORMAT IS_AS CON_ID
------ ----- ----------
/u02/app/oracle/product/19.0.0.0/dbhome_1/dbs/orapworcl
12 FALSE 0