Re: All Sample Schemas Locked and Expired

Hello Morgan,
thanks for writing in ... I did what yuo said .... and it seemed like it worked ..

however when ever I am trying to connect to the HR sample database ... its giving me the following error

ERROR:
ORA-12154: TNS:could not resolve service name

Warning: You are no longer connected to ORACLE.

. ok now I connect as a normal user into SQL Plus . then I connect as sysdba . It works fine .

then I give the following commands .. which you mentioned below. works fine.

now as connected as sysdba I try loggin in with sysdba uid and password....
it gives the same error

I also try loggin in with the user ID ... and password... nothing happens .. its gives that error. I know i am making a mistake some where ... Please advice..

thanks

DA Morgan wrote:
> Jquest wrote:
> > Hello All,
> >
> > Since I have installed personal oracle 9.2 with sample schemas to
> > practice on.... when I see the enterprice manager ... I see the schemas
> > locked and expired ... all I can do those is unlock not activate...
> > need any ones help on activating and using the schemas.
> >
> > How do you connect to those schemas .... whats the uid and password for
> > those ...
> >
> > thanks JQ
>
> conn / as sysdba
>
> alter user <schema_name> account unlock;
>
> alter user <schema_name> identified by <new_password>;
>
> Documented in Morgan's Library at www.psoug.org on the Users page.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Wed Aug 02 2006 - 16:10:38 CDT