how to tell if oracle database is installed on pc

Question

i work for a company as java developer, they gave me laptop that was previously used by another person, to test my java application i need to have oracle on laptop and create some sample database with sample data. when I got the laptop i found that there is oracle installed on it, but i don't know if this is only oracle client or full oracle installation (server + client) please can you tell me how to figure out if there is only oracle client on laptop or full database installation, plus i need to know if there is some default username and password so that i can access the database and create schema and tables in it, so that i can test my java application. i thinking to see DBA but i thought of dropping a question here first, maybe i can solve the problem by myself

Solution 1

If it is an Oracle Client, it doesn't have bin/dbca

Oracle Home may indicate the installation's type. The default Oracle Home folder names are:

• Oracle Database: dbhome_1
• Oracle Client: client_1

Although to make sure, you should check the services looking for OracleServiceSID entry on Windows.

Solution 2

Run Command sqlplus on command prompt.

Solution 3

Check services of windows to know that the oracle database was installed on laptop or not.

Try to find oracle universal installer in all programs by this also you can get which version of database is installed.

Your second question is about default username/password For this you can give username : "/ as sysdba". It will not ask for password because it will authenticate thorugh OS authentication.

after login you can able to create new schema or user and tables.

Comments

[yhu420]

Does this come with the client, database, or both?