I can?t login to SQL plus in oracle
mohamed, November 25, 2001 - 7:44 am UTC
Hi,
I have installed Oracle Personal Edition and Developer 2000 on my home PC . They Ware Installed Successfully .
Now , I want to Make practice for First Part(SQL, PL/SQL) So I try to run SQL PLUS 8.5 From Oracle For Windows 98 But It display this message : error
Ora-12203: TNS unable to connect to destination. and ask me about User name , Password And Host String
I tried to Enter scott/tiger or system/manager But It still Ask me about User Name, Password And Host String
I tried to check tnsnames.ora file in oracle\network\admin folder
Here is the sentence in it
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
TcpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
SpxExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
NmpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
CMExample.world =
(DESCRIPTION=(address_list=
(ADDRESS=
(PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER))
(ADDRESS=
(PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER)))
(CONNECT_DATA=(SID=ORCL))
(SOURCE_ROUTE=yes)
)
extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = EXTPROC%ORACLE_HOME_ID%)
)
(CONNECT_DATA = (SID = extproc)
)
)
what changes exactly should I do to run SQL plus?
Are there Sites That Can Support Me In This Part?
my email :mohamed_F33@hotmail.com
please help me immediately
thanks so much.
November 25, 2001 - 11:27 am UTC
Well, it'll depend on your default Oracle home and which sqlplus you are using.
Oracle8i PE will have been installed in one oracle home. If you use the default oracle home selector tool from the start menu and set it to the database oracle home and run sqlplus, using "scott/tiger" will work (it'll be a direct connection)
It is more likely that you are using the sqlplus from D2K. This sqlplus is in a different oracle home and uses a different version of support files. It cannot directly connect to your local 8i instance, rather it must use the "network" to connect over net8 (even on your single machine).
See
</code>
http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:447620106871 <code>
for details.
oracle_home
atul, October 16, 2003 - 11:58 am UTC
Hi Tom,
If a database is running on 8.0.6 and if we upgrade it
to 8.1.7..
Then ,
1)Can we open database again by using 8.0.6 home?
2)Also How to recognise that this database has been upgraded?
Thanks.
Atul
October 16, 2003 - 5:14 pm UTC
1) you can check out the migration guide -- it has downgrade options -- but, in general NO, once upgraded, you be upgraded. downgrading -- very hard and only in some cases
2) you wouldn't know? you'd have to sort of startup and see what happens. but -- i would certainly hope you would "know" (if not, you need a little tighter control on your systems maybe?)
ORACLE_HOME
atul, October 16, 2003 - 11:05 pm UTC
Hi,
I just want to know that can the database get started
with 8.0.6 home as well as 8.1.7 ..
Once we finish upgrade..
Thanks.
Atul
October 17, 2003 - 9:38 am UTC
"no"
Password request
Lydia Watkins, July 14, 2004 - 11:34 am UTC
I successfully installed Oracle8i Personal Edition on Windows Professional 2000 and used SYSTEM as the username, as instructed by the book "Sams Teach Yourself PL/SQL". However, after entering SYSTEM it asks for a password. Nothing I try works. How do I go about getting or assigning a password? I've looked through all your related answers for this answer and can't find one. Please help soon!
July 14, 2004 - 12:11 pm UTC
manager is the default
system/manager