OraFAQ Forum: Security » DEFAULT PASSWORDS TO CONNECT TO A NEW INSTANCE

Home » RDBMS Server » Security » DEFAULT PASSWORDS TO CONNECT TO A NEW INSTANCE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DEFAULT PASSWORDS TO CONNECT TO A NEW INSTANCE [message #56307]

Tue, 18 March 2003 05:59

Neil Bennett
Messages: 5
Registered: March 2003

Junior Member

I have recently created a new instance using the following script;

REM
REM Create database instance RATO
REM
REM Neil Bennett February 2003

SET ORACLE_SID=RATO

oradim80 -delete -sid RATO

oradim80 -new -sid RATO -startmode auto -intpwd RATO -maxusers 100 -pfile v:RATOinitRATO.ora

svrmgr30 @v:RATOSQL_create_RATO.sql
svrmgr30 @v:RATORATO_deftsp.sql
svrmgr30 @v:RATORATO_rollback.sql
svrmgr30 @v:RATORATO_ddpls.sql
svrmgr30 @v:RATORATO_user.sql

The main script to create RATO is as follows;

REM
REM SQL to create RATO
REM
REM Neil Bennett February 2003

CONNECT internal/RATO
SPOOL v:RATORATO_build.log

STARTUP NOMOUNT pfile=v:RATOinitRATO.ora

CREATE DATABASE RATO
MAXLOGFILES 255
MAXDATAFILES 255
MAXLOGMEMBERS 4
ARCHIVELOG
DATAFILE 'v:RATORATO_SYSTEM.ora' SIZE 100 M
LOGFILE GROUP 1 ('v:RATORATO_LOG_G1.ora') SIZE 100 M
,GROUP 2 ('v:RATORATO_LOG_G2.ora') SIZE 100 M

CHARACTER SET WE8ISO8859P1;

SPOOL OFF
quit

I'm trying to connect to the instance directly on the server via SQL*PLUS using the username SYSTEM, password MANAGER and Host String RATO. I understood the username and password above to be set by default when the instance was created. However, I an unable to connect and get an error message returned about being unable to connect to the SID descriptor. I think the TNSNAMES.ORA file has the right SID listed.

Can anyone advise please or tell me the default passwords? I can supply the TNSNAMES and LISTENER files for checking if necessary.

Thanks

Neil

Report message to a moderator

Re: DEFAULT PASSWORDS TO CONNECT TO A NEW INSTANCE [message #56308 is a reply to message #56307]

Tue, 18 March 2003 06:12

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

default accounts are
sys/change_on_install
system/manager.

if you have one only one database and you are working directly in server (client and server in same machine)
a connecString is not required.
you can connect with username/password
else
you need to edit tnsnames.ora file to create a connect string.

-- this is a sample tnsnames.ora file entry

C:>tail c:oracleora81networkadmintnsnames.ora
STAFFA_PMWR =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = staffa)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = pmwr)
    )
  )
-- first make sure the the listener in server is running

C:>tnsping staffa_pmwr

TNS Ping Utility for 32-bit Windows: Version 8.1.6.0.0 - Production on 18-MAR-2003 07:59:28

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=staffa)(PORT=1521))
OK (50 msec)

-- for the above entries i would connect as

C:>sqlplus dbadmin@staffa_pmwr

SQL*Plus: Release 8.1.6.0.0 - Production on Tue Mar 18 07:58:29 2003

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Enter password:

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

dbadmin@staffa_pmwr >

Report message to a moderator

Previous Topic:	Security concern: connect internal
Next Topic:	grant schema level privilege to other user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:49:49 CDT 2024