Ora-xxxx,x, your brother-in-law!

First, connect remote database error: Ora-12514:listener does not currently know of service requested in Connect descriptor

Listener Balabala a bunch, and then use idea to connect the next, Success!!! This is strange, how to do!!! Then began to search the online answer to the relevant questions, as a result, I put my local Oracle configuration messed up, and ultimately, even the database is not connected to the computer ...

Later really did not recruit, find the project manager to help, then, then put the idea of the configuration CV to navicat inside, the result is connected successfully!!! The manager's disdain for the eyes, estimated to cover me for several days.

Later looked carefully, is Sid wrote a wrong letter. Well, that's a long lesson to remember.

But, now my database has collapsed, swollen??? Another lesson here is to back up the original files before changing the configuration!!!

Second, well, the second question is derived from the first one:

Re-installed database, version number, installation address and even password, and so on, all completely with the previous consistency, but also secretly grateful, fortunately, before the Business data table space on the other disk, otherwise the data is all over.

However, after reloading, how to associate the original DBF file with this new database???

Absorb the previous lesson, I first back up the DBF file, in the beginning to follow the online "tutorial" to do a step-by-step, the result is no way, the association does not come, so I would like to create a new and then replace, see here. Tragedy from now on: After the replacement, the database directly open ...

Report this error: Ora-01031:insufficient privileges

OK, come again Baidu!!!

Third, the second problem has not been solved, and then encountered a third problem, the question is in the second answer: When logged in Sysdba account, prompt no permissions!!!

Rely on Ah, Lao Tzu is the administrator rights to log on, I drop on the authority?? Later found that the answer to this question, most farfetched, I want is the authority, not a messy SQL, even login is not on the, which SQL can run??!!

Later, in the sea after a few, only to understand that this goods is a thing of Windows: My Computer--right-management---Local Users and groups----double-click Open ora_dba-> member addition, input object name to select (Do not know the native user name, Use Cmder's whoami to find), after adding users, all the way to confirm, restart the computer->over

After that, it solves the problem of permissions. After this, Lao Tzu wanted to say: whoami!!! I'm just doing Java development, is this going to be a DBA's rhythm?

Finished back to the second question: ora-01031!!!

The command is as follows:

Sqlplus/  asSysdbasql*Plus:release11.2.0.1.0Production onSunday January A  -: -: +  .Copyright (c)1982, ., Oracle. Allrights reserved. Connect to: OracleDatabase11g Enterprise Edition Release11.2.0.1.0 -64bitProduction withThe partitioning, OLAP, Data Mining and RealApplication Testing Optionssql> shutdownNormalora-01109: The database is not open and the database has been unloaded. The ORACLE routine has been closed. SQL>The startup Mountoracle routine has been started. Total System Global Area3373858816bytesfixed Size2180424bytesvariable Size1845496504bytesDatabaseBuffers1509949440Bytesredo Buffers16232448The bytes database is loaded. SQL> Alter Database Open;Alter Database Open*Section1line error: ORA-01110: Data Files6:'E:\DATABASE\DEMO_DATA. DBF'ORA-01115: From File6IO Error when reading block (Block #1) ORA-27069: Attempt to exceed file scope execution I/OOSD-04026: The passed parameter is not valid. O/S-Error: (OS1) function is incorrect. SQL> Alter DatabaseDataFile6OfflineDrop; the database has changed. SQL> Alter Database Open; the database has changed. SQL> shutdownThe normal database is closed. The database has been uninstalled. The ORACLE routine has been closed. The Startuporacle routine has been started. Total System Global Area3373858816bytesfixed Size2180424bytesvariable Size1845496504bytesDatabaseBuffers1509949440Bytesredo Buffers16232448The bytes database is loaded. The database is already open. SQL>

At this point, finished!!!

But, how is the original DBF file associated with the new database?? This is still not resolved AH.

Off work, TODO.

Ora-xxxx,x, your brother-in-law!