server manager

[fog2k]

How I use command line?

I use svrmgrl on 8i and connect
when i use command ex: create table like on book
svrmgrl shows belows
svrmgr>create table temp
2) ( ......... , 3) , 4) ,...
how i execute it?
i press F6 to ^Z on last line. and Enter, nothing works just error and exit out to c:>.
I think I'm wrong. What's true way? I should use sql+ better,
but I failed to connect it? what is user name, password, and host string which can be connect to sql+?

[sreddy]

SQL Terminator ';' at the end of statement should execute it for you. Use and get used to SQL*Plus which gives lot flexibility for SQL manipulations. Anyway, you don't see 'svrmgr' from 9i.

[fog2k]

Hi sreddy;
I surprise to find you in 3 mins. Thanks about you advise.

But I cann't connect to sql+,
I try with sysman, sys, system, and internal and host string is
half:1521:ora8i, half is my computer name.

Please tell me too?

[sreddy]

What error messages you are getting ? What OS ? Whats your database name.

1)Check for ORACLE_PATH. Say if your Oracle Home is D:/Ora816. See your path should be having an entry D:/Ora816/bin. You can type in path at cmd prompt and see you have Oracle Bin set or not.
2) Try executing binaries from that location. Goto O_H/bin and try running SQL*Plus
3) See what you have in tnsnames.ora ? If your dbname is XYZ9. You should be having an entry in tnsnames.ora with the SID name and HOST name.
4)Try like this after making an entry in tnsnames.ora:
$ sqlplus system/manager@xyz1
$ sqlplus scott/tiger@xyz1

See the following example: My hostname is "nikhi" and dbname is "KRIS"
<font face=courier>
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

KRIS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nikhi)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = KRIS)
)
)
</font>

[fog2k]

It's work only I connect with "ora8i" (sid) in host string.

Thanks a lot your kindness.

see my next question