Code Snippet

Just another Code Snippet site

Oracle – Remote/External access as sysdba

1.Set the database parameter REMOTE_LOGIN_PASSWORDFILE = { shared | exclusive | none }

2. Check/Create a password file at location $ORACLE_HOME/dbs/ with command :

$ORACLE_HOME/bin/./orapwd file=$ORACLE_HOME/dbs/orapw<YOUR SID> password=syspass

3. Restart DB

,


Leave a Reply

Your email address will not be published. Required fields are marked *