The file in which the Oracle database connection name is set

In the database view of MyEclipse, click Right->New to pop up the Database Driver window, select Oracle (Thin Driver) for Driver Template, and enter Oracle for Driver Name

connection url=jdbc:oracle:thin:

localhost:1521: oracle Note localhost:

1521: The oracle in oracle is the database to replace the sid with your own database.

username: the username of the user who logs in to the database and has the system permission.

password: the password for logging in to the database with the system permission.

Click on the add jar to select the storage location, and there is no file that can be called next.

Click on the test driver to go to this successful configuration.

Workaround for prompting ora-12505 after starting the database:

The second possibility is that there is no error in the SID configuration, but the error is still reported, which may mean that there is a problem with the Oracle listening configuration and you need to check the file and open it with Notepad

There are only two main ones that are commonly used. "This is to configure the database program to listen to the host. "This is configured with an oracle instance, and then you don't need to write that string to directly write the name to access the database.

There is no such thing as an oracle connection alias.

In addition to the username and password, the Oracle remote login user also needs to connect to the string call: connection string, host string, network service name, etc. For example: Scott tiger@orcl

If you refer to a join alias of a table, use the alias instead of the cumbersome table name to simplify the query statement.

For example: select x*,y.* from dept x, emp y where ;

where x and y are both aliases for the table.

Many people mistakenly think that the value of datasours in oracle is the database name, but it is actually wrong.

Because in Oracle, the client's links are all through listening, and the database instances obtained by listening are distinguished by configuring the alias of the server, which is the database alias set by the target database.

It is the name of the database that you define.

Data files are stored in an oracle-defined format with no fixed suffix. dbf and. ORA and DBF by default.

Oracle Database, also known as Oracle RDBMS, or Oracle for short. is a relational database management system from Oracle. It is a product that has been leading the way in the field of databases.

It can be said that Oracle database system is currently the world's most popular relational database management system, the system is portable, easy to use, strong functions, suitable for all kinds of large, medium, small and microcomputer environments. It is a database solution with high efficiency, good reliability, and high throughput.

The default is dbf, unless a different extension is specified when creating the database.

Generally useddbf

It doesn't matter if you don't, because the UNIX system has no requirements for file suffixes, and can generally be based on the convention dbf

If the Oracle database is installed on a Unix or Linux system, you can use the Oracle operating system user telnet to enter the operating system and then change the password

sqlplus /nolog

connect /as sysdba

alter user username identified by password;

The username in the alter statement is the username you want to forget the password, and password is the new password.

The database is a Windows operation similar to this operation.

Your question is more general, if you can't find a file, you should search your installation files to see if it exists. If you can't find the file, you can change the installation file. If you have the file, see if the path is correct.

It shows what other security there is.

Initial user: system

Password: The password you entered when you installed it.

In addition, Oracle comes with 2 users, one is upstairs.

Account Number: Scott Password: Tiger

The second is: account sh and password sh

But you just need to log in as a system user, and then alter the user username account unlock. It seems that this command unlocks these 2 users, otherwise you won't be able to use it.

You can just open the Windows DOS window and log in;

Enter "sqlplus syste password as sysdba".

That's it.

There are a few default users, system, sys, scott, hr, and generally scott and hr as your practice users.

The default password for system is manager

The default password for sys is change on install practice users, which will need to be unlocked after oracle 10g.

After logging in as a sys or system user, use the following command to unlock alter user scott identified by tiger account unlock;

alter user hr identified by hr account unlock ；

Where Scott Tiger and HR HR are username passwords.

I can understand the above command even if I have a little English to understand it.

The default password for system is manager

The default password for sys is change on install