User name: internal? Password: Oracle Bone Inscriptions?
2. User name: system password: manager?
3. User name: sys password: change_on_install
4. Among them, the direct management mode can be sysdba or the latter three. If it is a cluster, the system will be removed.
Extended data:
One: the reset method of oracle sys password
Input: sqlplus /nolog in system operation.
Execute it alone in the command window: conn /as sysdba.
Alter user scott identified by tiger
Change the user scott account unlock;
Then change the password of "scott" user to "tiger", and users can reset the password according to their own needs.
Two: ORACLE database security solution?
1. At present, application systems rely more and more on databases. Application database can make the development of application system more convenient, and it is no longer necessary to design a separate grammar for tedious retrieval, query and statistics. At the same time, the integrity of the transaction can also be reliably guaranteed. However, the continuous integration of database vendors has brought new challenges to enterprise applications:
(1), Informix was acquired by IBM.
(2) Mysql was acquired by Oracle Bone Inscriptions.
(3) Sybase was acquired by SAP.
Microsoft's acquisitions are numerous, and it has acquired many small database vendors, especially open source. Tracing back to the source, the database technology of big manufacturers is getting bigger and bigger, but the architecture is not suitable for flexible development. Faced with the rapid development of small and medium-sized database manufacturers, they have to take the road of acquisition, but after the acquisition, they are not allowed to develop, and the customer base of small and medium-sized enterprises is ultimately injured.
2. Safety course
At present, no matter the comprehensive banking system, mobile billing system or regime trading system, large databases are used for transactions without exception. So what are the special considerations for the security scheme after the 9 1 1 market tragedy?
Database disaster tolerance is undoubtedly the best technical solution at present. In addition to network firewall, anti-virus and permission design, the security of application system data also includes database backup. It can be said that database backup has gone through the following stages:
Disk backup of stand-alone system
Data tape backup
LAN backup
Dual hot standby /RAID
Tape library backup
Disk tower backup
Remote disaster recovery backup
Global multipoint disaster recovery backup
3. Safety considerations
At present, most applications in application system solutions still mainly consider the construction of system functions, but with the increase of database capacity, the query and audit of historical data need to be accelerated, and the analysis of historical data and the real-time availability of online data become more and more urgent.
Customers not only need to be able to query the database quickly, but also put forward clearer requirements for the real-time availability and load balance of the current application system. For this reason, in addition to most solutions of dual-machine hot standby+tape library cold standby, many large financial securities companies have also begun to establish data centers, and large-scale remote disaster backup centers have also begun to be put on the agenda.
4. Relatively perfect
In fact, when planning application systems, we should consider providing customers with security solutions. When the enterprise means safety, I'm afraid it will take a lot of manpower.
Material resources to migrate data and establish a disaster recovery center, but this is only physical. How to protect the data of 1 byte from the database level? There is no doubt that we should consider the related products of database synchronous hot standby.
Because even if a disaster recovery center is not established, real-time data hot standby does not require too much investment. Just install the database synchronization product, you can easily check whether the data is really synchronized for hot standby. When customers realize that it is necessary to establish a disaster recovery center, they just redeploy the location and network.
Synchronization software grows with the growth of customers and data. What the integrator will do for the customer at that time is to plan the equipment and layout of the disaster recovery center, so that a perfect disaster recovery plan can be easily established by you. And with the gradual increase of data, customers will rely more on the load balancing function provided by the disaster recovery center, which not only reduces the hardware investment, but also reduces the resource occupation of the query to "0".
5. Product classification
At present, only the PAC database synchronization product of Woxin Technology can be used as the synchronization server, because the products of ORACLE DATAGUARD, DSG, Kinmen, SHAREPLEX and other manufacturers must be installed on the main database, which not only occupies the resources of the main database, but also puts forward higher requirements for the stability of the application system.
The products of Woxin Technology can be installed on the third-party server independent of the main and standby libraries, so that the database synchronization software does not occupy the resources of the main library system, and at the same time, it avoids the limitation of inconsistency between the operating system and the database version. At the same time, it has the highest cost performance among all products, and it is the only one that provides free trial download of Huajun Software Park.
References:
CSDN-oracle default initialization username password and password modification? Baidu Encyclopedia -ORACLE Database Security Solution