It's time to get used to controlling your database from SQL*Plus rather than server manager. Yet many DBAs still use server manager for tasks like startup and shutdown.
To connect as internal in SQL*Plus, connect as SYSDBA as any user who possesses the SYSDBA privilege. You cannot provide the password on the command line. You must use the /nolog option.
LINUX> sqlplus /nolog,br> SQL> Connect sys/change_on_install as sysdba
To connect as internal in export or import, place your connect string in the quotation marks within a parameter file like this:
USERID = "sys/pinnacle as sysdba"
Get more tips in minutes! Return to the main page.
About the author: Kenny Smith has been working with Oracle technology on HP servers for over a decade. He specializes in Oracle database architecture, database administration and development. He has presented at numerous Oracle conferences on two continents. He has published many articles describing Oracle solutions and has co-authored "Oracle backup and recovery 101" from Oracle Press.
IOUG: Become a member of the IOUG to access the paper referenced here and a repository of technical content created for Oracle users by Oracle users.