How to use oracle as root

When you install Oracle, the setup wizard prompts you to create an Oracle user to manage Oracle. This user is usually called 'oracle'.

You cannot log in to Oracle as root, and you need to access the Oracle user to connect to the database.

su - oracle

SQLPuplus as Sysdba -- Log in to Oracle as an administrator

Log in as an Oracle user first.

su Remember that you can't add -, get the environment variable of the oracle user and export oracle sid=aaa (instance name) dbca and follow the prompts to do it.

The same solution, I am running dbca, directly reporting an error, exception thead"main"What's with?

It is strongly recommended not to do this, and should follow the instructions in the Oracle installation documentation to install and create instances with different users. This avoids a lot of follow-up management troubles. Root is not a panacea.

c:\documents and settings\administrator>sqlplus /nolog

sql*plus: release - production on Star Hall Posture Intense Period 1 Mar 5 14:11:06 2012

sql> conn as sysdba;

Please enter the username: sys

Enter Password: Connected. Socks.

sql> code select name from v$database; name

orcl

Fang slag elimination method 1:

root@ogg1 ]cat home oracle cheats. bash_profile |grep sid

export oracle_sid=ogg1

Method 2: View any background Mingliang family process in Oracle, for example, lgwr and ora lgwr ogg1, where ogg1 is the sid

oracle@ogg1 ~]ps -ef|grep lgwr

oracle 4864 1 0 11:30 ? 00:00:00 ora_lgwr_ogg1

oracle 5442 2329 0 12:18 pts/0 00:00:00 grep lgwr

You've just changed the owner and group of the database file, and it should be OK to change the permissions.

For example, chmod 777 database gives read and write execution permissions to the oracle user, its group, and others.

It's all right, but if you install it as root, you won't be able to manage permissions on your machine.

If it is installed by an oracle user, then there is no superuser permission, only normal permissions are required.

You cannot install Oracle as the root user, but you can create an Oracle user as the root user, log in as the Oracle user, and install the database as the Oracle user.

Do you have an oracle package, just compile and install it.

Go to the root user and run xhost + then go back to the oralce user and run xclock to see.

There is no radical solution, because root has all the permissions of the system, and many restrictions do not take effect on the root account; And even if you set a limit, root can be changed back again.

root seems to have all the permissions.

I've just learned.

Root is invincible, and you can do whatever you want, so you can't do it. No one can limit him.

Yes, it can be restricted, but it should be remote login. After all, root has all the permissions.