I this how? Which bosses out solutions, the small white, got a day

CodePudding user response:

CodePudding user response:

Database is not open success, of course, can't create user

CodePudding user response:

1. Close the database
2. Restart the database
3. To build the user

CodePudding user response:

You in the mount state, the alter database open to add users

CodePudding user response:

Is an obvious error, control file has a problem,

CodePudding user response:

Look at the pictures in the prompt to launch successfully put so cause you can't build a user,

CodePudding user response:

The database open the instructions did not show that the database is not fully open as mentioned in upstairs you restart the database to add users

CodePudding user response:

The control file has a problem, restoring the control file or control file,

CodePudding user response:

Restart the database, check the error log

CodePudding user response:

Reading the wrong prompt if both control file has a problem,
1, according to the position error check two control file exists, if there is a oracle permissions, execute the alter database mount; Statements, see if it is an error, if not to, that's ok, and then execute the alter database open; Open the database,
2, check if the control file to see the log, the two backup control file, and then according to the latest date of kao to two paths, then rev up (startup), if ok,
3, if prompt control documents have problems, then see if rman backup, if useful rman restore the control file,
4, what if a few to all have no, the congratulations, reconstruction of the control file;

Step see https://blog.csdn.net/kpp19920121/article/details/79769717