N
N
NightFantom2015-01-25 19:47:54
Oracle
NightFantom, 2015-01-25 19:47:54

What should be done to connect to Oracle DB as SYSDBA?

Hello. Guys, please show "on your fingers" how to enter sqlPlus as SYSDBA and start a database instance? I can't get past the ora-01031 error. The database is on Ubuntu.
Thanks in advance!

Answer the question

In order to leave comments, you need to log in

2 answer(s)
P
protven, 2015-01-26
@NightFantom

export ORACLE_SID=<database instance name>
sqlplus / as sysdba
It must be executed from under the user who is in the dba group, or from under the one from under which they were set.
PS Strongly recommend - learn materiel. Start with the guides on the vendor's website.

G
Georgy Pichugin, 2015-01-28
@Cresh

in the classic example
su - oracle
env | grep ORA_
check that ORACLE_HOME is in the place where your database you want to run
ps -elf | grep ORA
and make sure that the instance is not started
sqlplus / as sysdba
get into the database and read the first lines
should be the word idle
startup
PROFIT +)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question