I have just installed Oracle Enterprise Edition, i tried to run SQL Plus. I requested username and password. I googled and by chance i found username should be scott and password is tiger which did not make sense to me. In the other hand, our instructor's gave us a username, password and host string to logon SQL*Plus in the institution lab as the following:
SQL> conn username/pass@hoststring;
I do not even think we had to insert username and password to use SQL*Plus
When i installed Enterprise Edition 11g to my pc, i thought the username, passowrd, and host string that i got my instructor's would work in my PC! It didn't so i had to go and search for a solution and i found that the username should scott and password is tiger! How an earth i would have known that? I'm not given this information after installation. Who is scott? Who is tiger? Why scott and tiger! Anyway, i inserted it and i have been requested to re-new the password and then i logged in. It did not ask me for a host string at all. Thus, here are my questions:
1. Why i could not logon SQL*Plus in my PC by using the instructor's username and password?
2. Doesn't SQL*Plus connects remotely to a server?
3. Why am i asked to insert username and password before using SQL*Plus! Because SQL> is useless accept i try to connect remotely as following conn username/pass@hostring;
4. Just curious to know! Is SQL*Plus allows you to insert a remote username and password, instead of my local "scott" username and password?
5. "Host string is your System Identifier (SID), which you would have specified while installation. Host string is an alias to the server/database. If you are running Developer on the same machine as the database server, leave host string empty." Is this true definition of Host String? If not, what is it? Please explain in a simple way.
6. Based on the quote above: " Host string is an alias to the server/database." what does this mean? Is it like a hint word?
7. Why SQL*Plus in Lab asks me to insert host string, while my SQL*Plus in my PC does not? Note: i know my SID, i set it when i first installed the application.
I'm new to all these database thing, so bear with me. Expect many questions on the way!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
1. If the listener answers that he can not find the instance
check if the listener is up and has registered the listener:
lsnrctl status
lsnrctl services
Static registration is the fix, if you do not see the instance
2. SCOTT/TIGER account is locked by default. To unlock:
SQL> alter user scot identified by tiger account unlock;
Now you will enjoy the Oracle world!
I tried to unlock tiger, but i get this message:
SQL> alter user scot indentified by tiger account unblock;
SP2-0640: Not connected
Moreover, i did
SQL> connect username/pass@hoststring;
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
I tried to use the remote username, pass and hoststring that i have been given by institution. As you see, i get TNS error. Can you explain what does it mean! Is the remote server down?
Further more, i did
SQL> connect username/password@hoststri
ERROR:
ORA-01017: invalid username/password; logon denied
I used my local details that i set in my pc when installed Oracle application. I know how to get hoststring. However, the only username and password i set and i know is
username: scott
password: tiger (i re-set it to my own password)
Yet did not work!
I got the file tnsname.ora, i checked its details, everything looks fine as i expected.
Can anybody advice please...
Business Accounts
Answer for Membership
by: schwertnerPosted on 2009-05-19 at 12:19:37ID: 24425534
Installing Oracle 11g you have choosen a SID name for your instance.
The connection string is an alias for 4 components without which the client can not understand where the server is:
Host (Computer) name
Port (1521)
Service Name (SID)
Protocol (TCP)
Now go the the file tnsname.ora (...\network\admin directory)
You will find some rows in front of which stays the alias (here it is QSYS):
QSYS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = developqsysdb.dev.intercom
)
(CONNECT_DATA =
(SERVICE_NAME = qsys)
)
So the connection will be:
SQL>connect sys/password@QSYS as sysdba
QSYS stands for the 4important entries that direct the client where to find the instance.
But there are 2 surprises that you have to overcome.